Problem:
A preparer creates a purchase request and send it to the approver, who approves it. The preparer then receives a notification that the PR was approved, but the notification automatically disappears from the list after the browser is refreshed or when the user logs off.
Solution:
The AutoClose_FYI parameter must be changed from ‘Y’ to ‘N’ in Notification Mailer.
Then the Notification Mailer must be stopped and started for the change to take effect.
Problem:
The Notification Mailer shows the following error:
Navigation: Oracle Application Manager > Site Map > Administration tab >
Notification Mailer (under Workflow)
Click: Workflow Notification Mailer
Component Details: Workflow Notification Mailer: TEST3 shows an error in Status
Information:
This automatic Service Component has been restarted the maximum of 10 times after
stopping with error. Thus, it has been system deactivated ->
oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component;
performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation
failed for the following parameters -> {OUTBOUND_SERVER=Unable to make a network
connection.}.
Solution:
Change Outbound Server from EBS application tier server to mail server. The Outbound Server is usually automatically reset as part of the cloning process.
Change OUTBOUND_SERVER from oratestapps.domainname to 10.x.x.x.
Problem:
While running patch 9239090, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file OKLTXRBKUG.sql on worker 1. FAILED: file OKLTXRBKUG.sql on worker 2. FAILED: file OKLTXRBKUG.sql on worker 3. FAILED: file OKLTXRBKUG.sql on worker 4. FAILED: file OKLTXRBKUG.sql on worker 5. FAILED: file OKLTXRBKUG.sql on worker 6. FAILED: file OKLTXRBKUG.sql on worker 7. FAILED: file OKLTXRBKUG.sql on worker 8. FAILED: file OKLTXRBKUG.sql on worker 9. FAILED: file OKLTXRBKUG.sql on worker 10. FAILED: file OKLTXRBKUG.sql on worker 11. FAILED: file OKLTXRBKUG.sql on worker 12. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Solution:
The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus as sysdba and ran the following commands:
alter package APPS.OKL_TXL_ASSETS_PVT compile; alter package APPS.OKL_TXL_ASSETS_PVT compile body; alter package APPS.OKL_TXL_ASSETS_PUB compile; alter package APPS.OKL_TXL_ASSETS_PUB compile body; alter package APPS.OKL_SPLIT_ASSET_PVT compile; alter package APPS.OKL_SPLIT_ASSET_PVT compile body; alter package APPS.OKL_SECURITIZATION_PVT compile; alter package APPS.OKL_SECURITIZATION_PVT compile body; alter package APPS.OKL_TRANSACTION_PVT compile; alter package APPS.OKL_TRANSACTION_PVT compile body;
OKL_TRANSACTION_PVT now compiles without issue.
To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:
select count(*) from dba_objects where status = ‘INVALID’;
Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.
Problem:
When running the Diagnostics: Apps Check from the Purchasing responsibility in Oracle Applications E-Business Suite 11i, the concurrent request completes in error and following error appears at the bottom of the output log:
declare
*
ERROR at line 1:
ORA-20100: File o0150175.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at “APPS.FND_FILE”, line 407
ORA-06512: at “APPS.FND_FILE”, line 581
ORA-06512: at line 120
Solution:
Ran out of disk space on the db machine. The temp directory used by EBS is in the /var directory, which is only 1GB in size. The /var directory is being filled by yum updates.
As root user, execute the command ‘yum clean all’. Stop the yum updates by issuing the command ‘/etc/init.d/yum-updatesd stop’.
Problem:
After unsetting LD_ASSUME_KERNEL, began applying patch 5903765. The following errors appeared:
Removing $FND_TOP/$APPLBIN from PATH …
uname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
grep: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
tr: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
Solution:
Apply patch 6365595: 11IEBS CERT ON OEL5|RH5|SLES10:UNSET LD_ASSUME_KERNEL IN ADGETLNXVER.SH.
This patch fixes all references to the LD_ASSUME_KERNEL environment variable.
Problem: When running the Payments batches process in Oracle, the following error occurs.
ORACLE error 20100 in FDPSTP
Cause: FDPSTP failed due to ORA-20100: File o}|#{|.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at "APPS.FND_FILE", line 396 ORA-06512.
Solution: Free disk space.
The drive on which temp files were created (pointed to by %TEMP% or %TMP%) ran out of space. Clear some disk space, and then rerun the Payments batches process.
Problem: How can I minimize errors occurring while patching on the Windows platform?
Solution: Use a script to ensure that all environment variables are set and all supporting utilities are accessible.
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.
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.
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.
Recent Comments