Error Message :
In Aborted job logs:
**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 Version: Linux server where Oracle E-Business Suite 12.2 is installed
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