ORA-00001: unique constraint (IDM_OIM.PK_USR) violated at line number xxxx

Issue - ORA-00001: unique constraint (IDM_OIM.PK_USR) violated at line number 1308
 

Problem Summary - Bulk Load Failed due to users already present with the usr_key, so find out the failed users from table
select * from USR_11G_FROM_PROD_EX1;
Update the usr_key and bulk load the failed users.
 

Solution - Onboard the failed users with different usr_key

No comments:

Post a Comment

Basic Perfomance Tuning For stuck threads and response times

Documentation for performance tuning: https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/asper/redundant-cross-references-remo...