Symptoms
US_pncat01_ldt.log in failed worker log shows below errors
Uploading from the data file /dodiapps/prod/prodapps/fs1/EBSapps/appl/pn/12.0.0/patch/115/import/US/pncat01.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/dodiapps/prod/prodapps/fs1/EBSapps/appl/gl/12.0.0/patch/115/import/glmlscat.lct(120.4.12020000.3), /dodiapps/prod/prodapps/fs1/EBSapps/appl/pn/12.0.0/patch/115/import/US/pncat01.ldt) to staging tables
Dumping LCT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/gl/12.0.0/patch/115/import/glmlscat.lct(120.4.12020000.3) into FND_SEED_STAGE_CONFIG
Dumping LDT file /dodiapps/prod/prodapps/fs1/EBSapps/appl/pn/12.0.0/patch/115/import/US/pncat01.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (GL_JE_CATEGORIES PN Lease Booking , GL_JE_CATEGORIES PN Lease Termination ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Booking, Translatable column USER_JE_CATEGORY_NAME value changed to PN LEASE BOOKING(1)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Booking, Translatable column DESCRIPTION value changed to Property Manager Expense Lease Booking(1)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Booking, Translatable column USER_JE_CATEGORY_NAME value changed to PN LEASE BOOKING(2)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Booking, Translatable column DESCRIPTION value changed to Property Manager Expense Lease Booking(2)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Booking, Translatable column USER_JE_CATEGORY_NAME value changed to PN LEASE BOOKING(3)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Booking, Translatable column DESCRIPTION value changed to Property Manager Expense Lease Booking(3)
Error loading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Booking, ORA-00001: unique constraint (GL.GL_JE_CATEGORIES_TL_U3) violated
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Revision, Translatable column USER_JE_CATEGORY_NAME value changed to PN LEASE REVISION(1)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Revision, Translatable column DESCRIPTION value changed to Property Manager Lease Revision(1)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Revision, Translatable column USER_JE_CATEGORY_NAME value changed to PN LEASE REVISION(2)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Revision, Translatable column DESCRIPTION value changed to Property Manager Lease Revision(2)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Revision, Translatable column USER_JE_CATEGORY_NAME value changed to PN LEASE REVISION(3)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Revision, Translatable column DESCRIPTION value changed to Property Manager Lease Revision(3)
Error loading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Revision, ORA-00001: unique constraint (GL.GL_JE_CATEGORIES_TL_U3) violated
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Termination, Translatable column USER_JE_CATEGORY_NAME value changed to PN TERMINATION(1)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Termination, Translatable column DESCRIPTION value changed to Property Manager Lease Termination(1)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Termination, Translatable column USER_JE_CATEGORY_NAME value changed to PN TERMINATION(2)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Termination, Translatable column DESCRIPTION value changed to Property Manager Lease Termination(2)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Termination, Translatable column USER_JE_CATEGORY_NAME value changed to PN TERMINATION(3)
Uploading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Termination, Translatable column DESCRIPTION value changed to Property Manager Lease Termination(3)
Error loading seed data for GL_JE_CATEGORIES: JE_CATEGORY_NAME = PN Lease Termination, ORA-00001: unique constraint (GL.GL_JE_CATEGORIES_TL_U3) violated
Concurrent request completed
Current system time is Wed May 17 18:47:50 2023
Solution:
1. Perform below data fix
sqlplus apps
SQL> create table GL_JE_CATEGORIES_TL_b4pncat01fix as select * from GL_JE_CATEGORIES_TL;
Table created.
SQL> select count(*) from GL_JE_CATEGORIES_TL_b4pncat01fix;
COUNT(*)
———-
503
SQL> select count(*) from GL_JE_CATEGORIES_TL;
COUNT(*)
———-
503
SQL> update gl_je_categories_tl set JE_CATEGORY_NAME=’PN Lease Booking’ where USER_JE_CATEGORY_NAME=’PN LEASE BOOKING’ and je_category_name=60;
2 rows updated.
SQL> update gl_je_categories_tl set JE_CATEGORY_NAME=’PN Lease Revision’ where USER_JE_CATEGORY_NAME=’PN LEASE REVISION’ and je_category_name=61;
2 rows updated.
SQL> update gl_je_categories_tl set JE_CATEGORY_NAME=’PN Lease Termination’ where USER_JE_CATEGORY_NAME=’PN TERMINATION’ and je_category_name= 62;
2 rows updated.
SQL> commit;
Commit complete.
2. Restart failed worker using adctrl Option 2
Oracle Reference:
Above data fix was provided in SR 3-32740907261 : Patch 31856789 fails at pncat01.ldt,
Orama.blog 