OAPP jobs abort after patching the EBS system

Document ID : KB000084556
Last Modified Date : 14/04/2018
Show Technical Document Details
Error Message :
In Aborted job logs:
**Starts**14-JAN-2018 04:30:16
**SQL error and free**14-JAN-2018 04:30:16
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'MAIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Several OAPP Jobs ( not all of them) Abort systematically with the above errors after having patched the OEBS Server with some fixes.
It is still unclear what is the procedure applied to Patch the OEBS systems, but the OEBS Application is not bounced.
A restart of Dollar Universe does not fix the problem.
OS: Linux
OS Version: Linux server where Oracle E-Business Suite 12.2 is installed
Cause type:
Root Cause: The Jobs Abort because the number of Arguments passed to the Jobs is incorrect.
Somehow, the Oracle Package (ux_get_default_params_du6) that is launched by the Dollar Universe Manager for Oracle Application would return some duplicated values when the Run Filesystem is the one that was not Patched.

This would work:

RUN File System : /ebs01/KEPR/fs2/EBSapps/appl
PATCH File System : /ebs01/KEPR/fs1/EBSapps/appl

This would not work:

RUN File System : /ebs01/KEPR/fs1/EBSapps/appl
PATCH File System : /ebs01/KEPR/fs2/EBSapps/appl
The issue is gone as soon as the OEBS Members are restarted so that the Run filesystem switches again to the primary one after having being Patched.

Fix Status: No Fix