Error loading seed data for PAY_INPUT_VALUES_F and ORA-20001: HR_7220_INVALID_PRIMARY_KEY Can Be Seen in the pergbele.ldt Log File When Running Hrglobal.drv
(Doc ID 3058980.1)
Last updated on NOVEMBER 15, 2024
Applies to:
Oracle HRMS (UK) - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run hrglobal.drv, the following error occurs in the pergbele.ldt log file.
Uploading from the data file /app/soft/ebstest03/appsoft/fs2/EBSapps/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/app/soft/ebstest03/appsoft/fs2/EBSapps/appl/pay/12.0.0/patch/115/import/pyseedele.lct(120.8.12020000.14), /app/soft/ebstest03/appsoft/fs2/EBSapps/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt) to staging tables
Dumping LCT file /app/soft/ebstest03/appsoft/fs2/EBSapps/appl/pay/12.0.0/patch/115/import/pyseedele.lct(120.8.12020000.14) into FND_SEED_STAGE_CONFIG
Dumping LDT file /app/soft/ebstest03/appsoft/fs2/EBSapps/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_ELEMENT_TYPES_F ASPP Adoption Corrections 2011/01/01 2012/03/31 GB , PAY_INPUT_VALUES_F Stop Reason 0001/01/01 2006/04/13 GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_INPUT_VALUES_F: ELEMENT_NAME = ITIP Details, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, NAME = Tax Reference, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 2001/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: HR_7220_INVALID_PRIMARY_KEY:
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/app/soft/ebstest03/appsoft/fs2/EBSapps/appl/pay/12.0.0/patch/115/import/pyseedele.lct(120.8.12020000.14), /app/soft/ebstest03/appsoft/fs2/EBSapps/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt) to staging tables
Dumping LCT file /app/soft/ebstest03/appsoft/fs2/EBSapps/appl/pay/12.0.0/patch/115/import/pyseedele.lct(120.8.12020000.14) into FND_SEED_STAGE_CONFIG
Dumping LDT file /app/soft/ebstest03/appsoft/fs2/EBSapps/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_ELEMENT_TYPES_F ASPP Adoption Corrections 2011/01/01 2012/03/31 GB , PAY_INPUT_VALUES_F Stop Reason 0001/01/01 2006/04/13 GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_INPUT_VALUES_F: ELEMENT_NAME = ITIP Details, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, NAME = Tax Reference, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 2001/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: HR_7220_INVALID_PRIMARY_KEY:
The issue can be reproduced at will with the following steps:
1. Run hrglobal.drv.
2. Check the log file.
Changes
Upgrade from 12.2.5 to 12.2.12 release.
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 |