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 SEPTEMBER 19, 2017

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP8 and later
Information 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



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