R12: Patch R12.PJ_PF.C.DELTA.7 Patch 24715258 FAILED: File Papsta.ldt On Worker 3.

(Doc ID 2319283.1)

Last updated on OCTOBER 19, 2017

Applies to:

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

Symptoms



12.2 Delta7  Patch 24715258 application FAILED with below errors in one of the worker logs

ERROR
-----------------------
Uploading from the data file /ora/ple01/apps/RMPLE1/fs2/EBSapps/appl/pa/12.0.0/patch/115/import/US/papsta.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/ora/ple01/apps/RMPLE1/fs2/EBSapps/appl/pa/12.0.0/patch/115/import/paprjsta.lct(120.2), /ora/ple01/apps/RMPLE1/fs2/EBSapps/appl/pa/12.0.0/patch/115/import/US/papsta.ldt) to staging tables
Dumping LCT file /ora/ple01/apps/RMPLE1/fs2/EBSapps/appl/pa/12.0.0/patch/115/import/paprjsta.lct(120.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /ora/ple01/apps/RMPLE1/fs2/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 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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch 24715258

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

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