DUAS: OAPP Uprocs fail as submitted with wrong number of arguments

Products

• CA Automic Dollar Universe

Issue/Introduction

After an OEBS patching ( FND cumulative fix) that did not go well, all OAPP_PGM Jobs fail when launched via Dollar Universe with Manager for Oracle Applications 6.x

The jobs are launched with a wrong number of parameters ( many more than the Program expects).

When looking in the APPS database, we observe this abnormally high and duplicated Arguments for the new Executions performed via Dollar Universe:

The following kind of error appears in the Job Log:

_{The request (REQUESTID) is ended with error.}

_{The concurrent program 'PROGRAM' with request id REQUESTID ended with errors.}

 

_{....................}

_{**SQL error and free**12-AUG-2019 00:38:12}

_{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}

_{....................}

 

 

Environment

Release : 6.x

Component : DOLLAR UNIVERSE 

Subcomponent: Manager for Oracle Applications

Cause

OEBS 12.2 Issue: Unsucessful Patching of the OEBS system with FND cumulative patches that did not complete succesfully.

Resolution

Since the issue is located in OEBS, please perform the following:

Clean / Rollback the FND patches from impacted OEBS systems.

Restart the associated OEBS Application and Database.

 

After that Jobs should run fine.