R12 Diagnostics Notes

Posted by on August 19, 2011 No comments

My Oracle Support Community is located at:

https://communities.oracle.com/portal/server.pt/community/support/219

My Oracle Support Community – Diagnostic Tools is located at:

https://communities.oracle.com/portal/server.pt/community/Diagnosibility/242

Overview of EBS Diagnostics Video:

https://support.oracle.com/CSP/main/article?cmd=show&type=ATT&id=232116.1:OVERVIEW&inline=1

How to run Oracle DBS Diagnostics:

Log on as a user with access to the Application Diagnostics responsibility. Then click:

Application Diagnostics > Diagnose > Select Application

Check checkbox to left of the test you wish to run.

Scroll to bottom of page and click Execute button.

Enter parameters, then click Submit.

Diagnostic Tests Catalog:

Release 12: MOS Doc ID: 421245.1

Other Diagnostics documents:
* Overview
* Installation Guide
* Frequently Asked Questions (FAQ)
* Training

Also My Oracle Support (MOS) Community

Could not reserve record

Posted by on August 18, 2011 No comments

Problem: When trying to add lines to a Standard RFQ (Request for Quotation), the user encounters the following error:

Could not reserve record [2 tries].

Solution: Kill lock on session.

Read more »

SQL Code Not Running In EBS

Posted by on July 29, 2011 No comments

Problem: The following code runs in SQL Developer and SQL*Plus from the server:

SELECT person_name,
  employee_number,
  date_from,
  date_to,
  segment_details
FROM apps.hrfg_detailed_special_info
WHERE to_date('&1', 'RRRR/MM/DD HH24:MI:SS') BETWEEN date_from AND date_to
 AND information_type = 'ABC Full Time Payroll Remarks'
 AND segment_name = 'Remarks'
ORDER BY person_name
/

However, when it is registered as a concurrent program and run, no output appears.

Solution: The apps_initialize subroutine must be called before running the script.

Read more »

Installing FSCM 9.0 PeopleBooks for SQL Server on Windows

Posted by on July 29, 2011 No comments

Problem: Procedure for installing PeopleBooks for Financials/Supply Chain Management (FSCM) 9.0 unclear.

Solution:

The documentation for installing PeopleBooks is available in the PeopleTools Installation guide. In this case, FSCM 9.0 was installed on PeopleTools 8.49 on the Microsoft SQL Server database.

Read more »

Installing PeopleTools PeopleBooks 8.49

Posted by on July 29, 2011 No comments

Problem: When user clicks on PeopleTools > Web Profile > Web Profile Configuration, clicks Search > Dev, and then clicks the Help link, the following message appears:

Help cannot be displayed because no help topic was found for the help context ID "WEB_PROF_GENERAL". 
To view the PeopleSoft Online Library, click here.

Solution: The PeopleTools PeopleBooks CD was not installed.

Read more »

Responsibilities Not Appearing After Logon

Posted by on July 20, 2011 No comments

Problem: After logging on to Oracle Applications E-Business Suite, a custom responsibility is not appearing. This responsibility has disappeared for all users.

Solution: Checked My Oracle Support document “During Login Responsibilities Assigned to Users do not Appear in the Navigator Page [ID 565130.1]”. However, this did not resolve the issue.

Under the System Administrator responsibility, navigated to Security > Responsibility > Define, then queried for the responsibility that was not appearing (F11, Ctrl+F11). Under the Available From section on the form, the “Oracle Mobile Applications” option was selected. Selected “Oracle Applications” option, and then saved. After logging out and logging back in, the user was able to access the responsibility.

EXEC FND_CONC_STAT.COLLECT Parameter Appearing in Concurrent Report Output

Posted by on July 6, 2011 No comments

Problem: After SQL*Plus concurrent job is registered and run, the concurrent job completes in error and the following message appears in the output:

Enter value for 10: EXEC FND_CONC_STAT.COLLECT;
Enter value for 20:
Enter value for 30: EXIT
     peed.start_date between to_date('EXEC FND_CONC_STAT.COLLECT;', 'RRRR/MM/DD HH24:MI:SS') and  to_date('','RRRR/MM/DD HH24:MI:SS')
                                     *
ERROR at line 18:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Solution: The parameters in the SQL script must be changed from ‘&P_Start_Date’, ‘&P_End_Date’ and ‘&P_Payroll’ to ‘&1’, ‘&2’ and ‘&3’.

Read more »

Printer No Longer Prints After Changing Ribbon

Posted by on June 29, 2011 1 comment

Problem: After changing the printer ribbon for the dot-matrix printer, E-Business Suite can no longer print to the printer.

Solution: The printer must be re-enabled under Linux. Log on as the root user to the machine with the Reports Server and issue the command ‘cupsenable PRINTERNAME’, where PRINTERNAME is the name of the printer as it is registered under Linux.

[amazon asin=0131855158&template=iframe image&chan=default]     [amazon asin=1449316697&template=iframe image&chan=default]     [amazon asin=0596006403&template=iframe image&chan=default]

“Compile Security” Concurrent Request completes in error

Posted by on June 29, 2011 No comments

Problem: When the user runs the concurrent request for “Compile Security”, it completes with error.

Solution: On the database server, the /var directory has completely filled up and there is no free space. This directory is used by E-Business Suite as the temp directory (in reality, EBS uses/usr/tmp, which symbolically links to /var/tmp). The space is filled due to the yum daemon, which automatically downloads updates from Red Hat to the /var/cache/yum directory.

To resolve this issue, log on to the system as the root user and either delete the contents of the /var/cache/yum directory using ‘rm -f /var/cache/yum’, or execute the command ‘yum clean all’. To stop the yum-updatesd daemon, run the command ‘service yum-updatesd stop’ or ‘/etc/init.d/yum-updatesd stop’.

ORA-12913: Cannot create dictionary managed tablespace

Posted by on May 25, 2011 No comments

Problem: While creating a dictionary managed tablespace in Oracle 9i, the following error appears:

SQL> r
 1  CREATE TABLESPACE data01
 2  DATAFILE '$HOME/oradata/ORCL/data01.dbf' SIZE 2M
 3* EXTENT MANAGEMENT DICTIONARY
 CREATE TABLESPACE data01
 *
 ERROR at line 1:
 ORA-12913: Cannot create dictionary managed tablespace
 Solution:

Consulting the Oracle 9i online documentation, the following cause and action is found:

Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.

Action: Create a locally managed tablespace.

As a result, the dictionary managed tablespace cannot be created in this Oracle 9i database.

Reference:

http://download.oracle.com/docs/cd/B10500_01/server.920/a96525/e12700.htm