OAPP_SET uprocs fail with "Error during package initialization"

Document ID : KB000085400
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
################
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:
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
Additional Information:
Workaround :
N/A