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 FEBRUARY 22, 2019
Applies to:
Oracle US Federal Human Resources - Version 12.2 HRMS RUP8 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |