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.
Cause type: Configuration 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
OS: Linux OS Version: Linux server where Oracle E-Business Suite 12.2 is installed
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.