OAPP_SET uprocs fail with "Error during package initialization"
Article ID: 85400
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
Error Message :
The following kind of errors should appear on the job log when the variable UXOAPP_TRACE is set to Y
################
2015-11-16 15:03:11 - UxInitPackage - PL/SQL exception raised for responsibility_id.
2015-11-16 15:03:11 - ERROR - UxInitPackage - SQLCODE=-1422
2015-11-16 15:03:11 - ERROR - UxInitPackage - SQLERRM=ORA-01422: exact fetch returns more than requested number of rows
2015-11-16 15:03:11 - UxInitPackage - Exit
Error during package initialization.
2015-11-16 15:03:11 - UxStartRequestSet - Error during package initialization. Abort
2015-11-16 15:03:11 - UxStartRequestSet - Exit
2015-11-16 15:03:11 - uxstroapp - Can not start the request set.
2015-11-16 15:03:11 - uxstroapp - Exit
2015-11-16 15:03:11 - uxstroapp - l_status = FALSE - p_req_status =
=============================== END OF SQL TRACE ===============================
Technical error. Command in error because an error occured during the SQL statement execution. (exit code: 10)
An error occured during the SQL statement execution (SQL exit code: 10).
################
In case the variable UXOAPP_TRACE is not set, these errors appear on the job log:
################
Error during package initialization.
=============================== END OF SQL TRACE ===============================
Technical error. Command in error because an error occured during the SQL statement execution. (exit code: 10)
An error occured during the SQL statement execution (SQL exit code: 10).
The submission of the request set generated some errors.
Check the log and err files.
Exit code of /orsyp/DUAS/UKEMET_ebscm1prod/bin/bin_oapp/uxstroapp is 10.
Patch level detected:Dollar Universe 6.2.01
Product Version: Dollar.Universe 6.2.01
Description :After replicating an Oracle Application from Oracle Applications 11i to Oracle Applications 12.2, the uprocs of type OAPP_SET are aborting with the following errors on the job log:
################
Error during package initialization.
################
The following kind of errors should appear on the job log when the variable UXOAPP_TRACE is set to Y
################
2015-11-16 15:03:11 - UxInitPackage - PL/SQL exception raised for responsibility_id.
2015-11-16 15:03:11 - ERROR - UxInitPackage - SQLCODE=-1422
2015-11-16 15:03:11 - ERROR - UxInitPackage - SQLERRM=ORA-01422: exact fetch returns more than requested number of rows
2015-11-16 15:03:11 - UxInitPackage - Exit
Error during package initialization.
2015-11-16 15:03:11 - UxStartRequestSet - Error during package initialization. Abort
2015-11-16 15:03:11 - UxStartRequestSet - Exit
2015-11-16 15:03:11 - uxstroapp - Can not start the request set.
2015-11-16 15:03:11 - uxstroapp - Exit
2015-11-16 15:03:11 - uxstroapp - l_status = FALSE - p_req_status =
=============================== END OF SQL TRACE ===============================
Technical error. Command in error because an error occured during the SQL statement execution. (exit code: 10)
An error occured during the SQL statement execution (SQL exit code: 10).
################
In case the variable UXOAPP_TRACE is not set, these errors appear on the job log:
################
Error during package initialization.
=============================== END OF SQL TRACE ===============================
Technical error. Command in error because an error occured during the SQL statement execution. (exit code: 10)
An error occured during the SQL statement execution (SQL exit code: 10).
The submission of the request set generated some errors.
Check the log and err files.
Exit code of /orsyp/DUAS/UKEMET_ebscm1prod/bin/bin_oapp/uxstroapp is 10.
Patch level detected:Dollar Universe 6.2.01
Product Version: Dollar.Universe 6.2.01
Description :After replicating an Oracle Application from Oracle Applications 11i to Oracle Applications 12.2, the uprocs of type OAPP_SET are aborting with the following errors on the job log:
################
Error during package initialization.
################
Environment
OS: Linux
Cause
Cause type:
Configuration
Root Cause: The reason about these issue is the fact that the database contains duplicated items on both the responsibility_id and the application_id, due to the way the data was injected on the newer database.Example:Result:
Configuration
Root Cause: The reason about these issue is the fact that the database contains duplicated items on both the responsibility_id and the application_id, due to the way the data was injected on the newer database.Example:Result:
Resolution
The solution for this issue is removing all the duplicated items on the database, this can be checked via the query:
SELECT application_id FROM applsys.fnd_application;
The workaround for this issue is:
- Modify the package UX_CONC_REQUEST_SET_DU6 Body in the oracle database used by the manager oracle for application replacing these two lines:
SELECT application_id INTO p_application_id
by
SELECT DISTINCT application_id INTO p_application_id
and
SELECT resp.responsibility_id, resp.application_id
by
SELECT DISTINCT resp.responsibility_id, resp.application_id
- Then compile the package in the database and rerun the jobs failing with that error "ERROR - UxInitPackage - SQLERRM=ORA-01422: exact fetch returns more than requested number" on the job log
Fix Status: Released
Fix Version(s):
Component: Application.Server
Version: Dollar.Universe 6.2.01
SELECT application_id FROM applsys.fnd_application;
The workaround for this issue is:
- Modify the package UX_CONC_REQUEST_SET_DU6 Body in the oracle database used by the manager oracle for application replacing these two lines:
SELECT application_id INTO p_application_id
by
SELECT DISTINCT application_id INTO p_application_id
and
SELECT resp.responsibility_id, resp.application_id
by
SELECT DISTINCT resp.responsibility_id, resp.application_id
- Then compile the package in the database and rerun the jobs failing with that error "ERROR - UxInitPackage - SQLERRM=ORA-01422: exact fetch returns more than requested number" on the job log
Fix Status: Released
Fix Version(s):
Component: Application.Server
Version: Dollar.Universe 6.2.01
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
