R12: Upgrade To 12.2.7 Fails With ORA-00001: Unique Constraint (PA.PA_PROJECT_STATUSES_U2) Violated and ORA-01403: No Data Found

(Doc ID 2320376.1)

Last updated on OCTOBER 23, 2017

Applies to:

Oracle Project Foundation - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

While upgrading to 12.2.7 the following error is encountered:

Uploading from the data file /u01/oracle/QA/fs1/EBSapps/appl/pa/12.0.0/patch/115/import/US/papsta.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/oracle/QA/fs1/EBSapps/appl/pa/12.0.0/patch/115/import/paprjsta.lct(120.2), /u01/oracle/QA/fs1/EBSapps/appl/pa/12.0.0/patch/115/import/US/papsta.ldt) to staging tables
Dumping LCT file /u01/oracle/QA/fs1/EBSapps/appl/pa/12.0.0/patch/115/import/paprjsta.lct(120.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01/oracle/QA/fs1/EBSapps/appl/pa/12.0.0/patch/115/import/US/papsta.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PA_PROJECT_STATUSES APPROVED PROJECT , PA_PROJECT_STATUSES 1000 OPEN_ASGMT ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column PROJECT_STATUS_NAME value changed to Possible(1)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column DESCRIPTION value changed to Possible Requirement(1)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column PROJECT_STATUS_NAME value changed to Possible(2)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column DESCRIPTION value changed to Possible Requirement(2)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column PROJECT_STATUS_NAME value changed to Possible(3)
  Uploading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, Translatable column DESCRIPTION value changed to Possible Requirement(3)
  Error loading seed data for PA_PROJECT_STATUSES: PROJECT_STATUS_CODE = 1000, STATUS_TYPE = OPEN_ASGMT, ORA-00001: unique constraint (PA.PA_PROJECT_STATUSES_U2) violated
ORA-01403: no data found

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms