After Patch Application, pabrg.ldt Errors with ORA-00001: unique constraint (APPLSYS.FND_REQUEST_GROUP_UNITS_U1) violated (Doc ID 2829447.1)

Last updated on DECEMBER 20, 2021

Applies to:

Symptoms

On 12.1.3 in Production:

ACTUAL BEHAVIOR
--------------------------

Encounter the following error associated with pabrg.ldt when trying to apply patch 28493407 Oracle Projects Release Update Pack 8 for 12.1 (R12.PJ_PF.B.Delta.8).
 

ERROR
-------

Uploading from the data file /ebs/oracle/CBSDEV/apps/apps_st/appl/pa/12.0.0/patch/115/import/US/pabrg.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/ebs/oracle/CBSDEV/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpreqg.lct(120.0.12010000.1), /ebs/oracle/CBSDEV/apps/apps_st/appl/pa/12.0.0/patch/115/import/US/pabrg.ldt) to staging tables
Dumping LCT file /ebs/oracle/CBSDEV/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpreqg.lct(120.0.12010000.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /ebs/oracle/CBSDEV/apps/apps_st/appl/pa/12.0.0/patch/115/import/US/pabrg.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (REQUEST_GROUP All Project Billing Programs PA , REQUEST_GROUP_UNIT S PJI PJI_PJP_SUMMARIZE_PRTL ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for REQUEST_GROUP_UNIT: REQUEST_GROUP_NAME = All Projects Programs, APPLICATION_SHORT_NAME = PA, UNIT_TYPE = P, UNIT_APP = PER, UNIT_NAME = PERSLM, ORA-00001: unique constraint (APPLSYS.FND_REQUEST_GROUP_UNITS_U1) violated


STEPS
--------

1. Apply patch 28493407.

2. File pabrg.ldt errors with:

Error loading seed data for REQUEST_GROUP_UNIT: REQUEST_GROUP_NAME = All Projects Programs, APPLICATION_SHORT_NAME = PA, UNIT_TYPE = P, UNIT_APP = PER, UNIT_NAME = PERSLM, ORA-00001: unique constraint (APPLSYS.FND_REQUEST_GROUP_UNITS_U1) violated
 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.