Issues faced while upgrading Oracle Applications (E-Business Suite) from 11i to R12.2

 Issue# 26:

While applying main upgrade merged patch

 

ATTENTION: All workers either have failed or are waiting:

 

                   FAILED: file umxroles.ldt on worker  1.

 

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

 

Worker log:

Time when worker started job: Sun Apr 23 2017 12:52:30

 

Loading data using  FNDLOAD function.

FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afrole.lct @FND:patch/115/import/US/umxroles.ldt -

 

Connecting to APPS......Connected successfully.

 

Calling FNDLOAD function.

 

Returned from FNDLOAD function.

 

Log file: /oracle/12.2/DPRO/fs1/EBSapps/appl/admin/DPRO/log/US_umxroles_ldt.log

Error calling FNDLOAD function.

 

 

Time when worker failed: Sun Apr 23 2017 12:52:30

 

Detailed log:

Uploading from the data file /oracle/12.2/DPRO/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/umxroles.ldt

Altering database NLS_LANGUAGE environment to AMERICAN

Dumping from LCT/LDT files (/oracle/12.2/DPRO/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7), /oracle/12.2/DPRO/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/umxroles.ldt) to staging tables

Dumping LCT file /oracle/12.2/DPRO/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/afrole.lct(120.7) into FND_SEED_STAGE_CONFIG

Dumping LDT file /oracle/12.2/DPRO/fs1/EBSapps/appl/fnd/12.0.0/patch/115/import/US/umxroles.ldt into FND_SEED_STAGE_ENTITY

Dumped the batch (FND_SECURITY_GROUPS STANDARD , WF_ROLE ZZZ_LAST_DUMMY_ROLE ) into FND_SEED_STAGE_ENTITY

Uploading from staging tables

  Error loading seed data for WF_USER_ROLE:  ROLE_NAME = UMX|SECURITY_ADMIN, USER_NAME = SYSADMIN, ROLE_NAME = UMX|SECURITY_ADMIN,  ORA-20002: 4016: User/Role relationship for user 'SYSADMIN' and role 'UMX|SECURITY_ADMIN' already exists.

 

 

Concurrent request completed

Current system time is Sun Apr 23 12:52:30 2017

 

 

Solution:

User/Role Relationship For User 'SYSADMIN' And Role 'UMX|SECURITY_ADMIN' Already Exists Running The 12.2 Driver u10124646.drv (Doc ID 1915370.1)

 

[apdpro@r12upgdb ~]$ sqlplus apps/apps

 

SQL*Plus: Release 10.1.0.5.0 - Production on Sun Apr 23 13:07:11 2017

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL> begin

   fnd_user_resp_groups_api.sync_roles_all_resp_secgrps(TRUE);

end;

/  2    3    4 

 

PL/SQL procedure successfully completed.

 

SQL> execute WF_LOCAL_SYNCH.BulkSynchronization('ALL');

 

PL/SQL procedure successfully completed.

 

SQL> execute wf_maintenance.ValidateUserRoles(p_BatchSize => null, p_UserName => 'SYSADMIN', p_check_dangling => TRUE, p_check_missing_ura => TRUE, p_UpdateWho => TRUE);

 

PL/SQL procedure successfully completed.

 

SQL>