US HRGLOBAL Fails on Payusfrrules.ldt With ORA-20001: HR_7135_SPR_FORMULA_NO_UPDATE PAY_STATUS_PROCESSING_RULES_F: ELEMENT_NAME = Regular Salary
(Doc ID 2064773.1)
Last updated on AUGUST 22, 2024
Applies to:
Oracle Payroll - Version 12.1 HRMS RUP8 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1 HRMS RUP8 version, Core Payroll - General
When attempting to run HRGLOBAL for US Legislation the following error occurs.
ERROR
-----------------------
Uploading from the data file /oracle/erp1213/TEST2/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payusfrrules.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/oracle/erp1213/TEST2/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedfrr.lct(120.1.12010000.11), /oracle/erp1213/TEST2/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payusfrrules.ldt) to staging tables
Dumping LCT file /oracle/erp1213/TEST2/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedfrr.lct(120.1.12010000.11) into FND_SEED_STAGE_CONFIG
Dumping LDT file /oracle/erp1213/TEST2/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_us/payusfrrules.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_STATUS_PROCESSING_RULES_F ALIEN_POST_VERTEX US 0001/01/01 4712/12/31 P , PAY_FORMULA_RESULT_RULES_F Workers Compensation US 0001/01/01 4712/12/31 P WCABLE_HOURS ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_STATUS_PROCESSING_RULES_F: ELEMENT_NAME = Regular Salary, ASSIGNMENT_STATUS_TYPE = , BUSINESS_GROUP_NAME = , LEGISLATION_CODE = US, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, PROCESSING_RULE = P, ORA-20001: HR_7135_SPR_FORMULA_NO_UPDATE:
Error loading seed data for PAY_STATUS_PROCESSING_RULES_F: ELEMENT_NAME = Regular Wages, ASSIGNMENT_STATUS_TYPE = , BUSINESS_GROUP_NAME = , LEGISLATION_CODE = US, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, PROCESSING_RULE = P, ORA-20001: HR_7135_SPR_FORMULA_NO_UPDATE:
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute DataInstall utility. Re-Select Global PER, US PER, US PAY legislations and explicitly select Jit/Geocode for Install.
Make sure the column 'Action' has 'Install'
2. Use adpatch to apply $PER_TOP/patch/115/driver/hrglobal.drv
Changes
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 |