CA Leg: hrglobal.drv Fails On Percafrrules.ldt Ora-20001: Hr_7135_spr_formula_no_update (Doc ID 1580389.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle HRMS (Canada) - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : Canadian Payroll
After application of 12.0. HRMS Rup 11 patch

When attempting to run hrglobal.drv
the following error occurs.

ERROR
-----------------------
 Uploading with option(s)
 LEG_VIEW=hr_per_ca_implementation
Uploading from the data file ....per/12.0.0/patch/115/import/US/loc_ca/percafrrules.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (....pay/12.0.0/patch/115/import/pyseedfrr.lct(120.1.12000000.6), ...per/12.0.0/patch/115/import/US/loc_ca/percafrrules.ldt) to staging tables
Dumping LCT file /....pay/12.0.0/patch/115/import/pyseedfrr.lct(120.1.12000000.6) into FND_SEED_STAGE_CONFIG
Dumping LDT file /....per/12.0.0/patch/115/import/US/loc_ca/percafrrules.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_STATUS_PROCESSING_RULES_F CANADIAN_TAX   CA 0001/01/01 4712/12/31 P , PAY_FORMULA_RESULT_RULES_F WCB Calculator   CA 0001/01/01 4712/12/31 P WCB_pre_tax_redns WCB Paid ) 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 = CA, EFFECTIVE_START_DATE = 1901/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 = CA, EFFECTIVE_START_DATE = 1901/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. Process DataInstaller and HRglobal.drv
2. Receive the error above in one of the stages

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