Applying Patch 25886885. Errors: Error loading seed data for GHR_REMARKS: REMARK_CHAR = 1027, ORA-00001: unique constraint (HR.GHR_REMARKS_PK) violated (Doc ID 2288268.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle US Federal Human Resources - Version 12.2 HRMS RUP8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 HRMS RUP8 version, Patch Application Issues

While applying <Patch 25886885> US FEDERAL HR LEGISLATIVE PATCH APR-2017 the following issue is seen while loading seed data:


Uploading from the data file
/u61/oracle/r122appstst/fs2/EBSapps/appl/ghr/12.0.0/patch/115/import/US/ghrremk.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files
(/u61/oracle/r122appstst/fs2/EBSapps/appl/ghr/12.0.0/patch/115/import/ghrremk.
lct(120.3.12020000.1), /u61
/oracle/r122appstst/fs2/EBSapps/appl/ghr/12.0.0/patch/115/import/US/ghrremk.ldt) to staging tables
Dumping LCT file
/u61/oracle/r122appstst/fs2/EBSapps/appl/ghr/12.0.0/patch/115/import/ghrremk.lct(120.3.12020000.1) into FND_SEED_ST
AGE_CONFIG
Dumping LDT file
/u61/oracle/r122appstst/fs2/EBSapps/appl/ghr/12.0.0/patch/115/import/US/ghrremk.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (GHR_REMARKS 1 , GHR_REMARKS 367 ) into
FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for GHR_REMARKS: REMARK_CHAR = 1026, ORA-00001:
unique constraint (HR.GHR_REMARKS_PK) violated
 Error loading seed data for GHR_REMARKS: REMARK_CHAR = 1027, ORA-00001:
unique constraint (HR.GHR_REMARKS_PK) violated
There are two issues that need to be addressed.

 

Changes

 Applied <Patch 25886885> US FEDERAL HR LEGISLATIVE PATCH APR-2017

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