hglobal.drv fails on pergbele.ldt with ORA-20001: Formula result rules use this input value (Doc ID 1207151.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to apply the hrglobal.drv, the following error occurs.

Uploading from the data file $PER_TOP/patch/115/import/US/loc_gb/pergbele.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files ($PAY_TOP/patch/115/import/pyseedele.lct(120.0.12010000.4), $PER_TOP/patch/115/import/US/loc_gb/pergbele.ldt) to staging tables
Dumping LCT file $PAY_TOP/patch/115/import/pyseedele.lct(120.0.12010000.4) into FND_SEED_STAGE_CONFIG
Dumping LDT file $PER_TOP/patch/115/import/US/loc_gb/pergbele.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_ELEMENT_TYPES_F Advance Clearup 0001/01/01 4712/12/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_ELEMENT_TYPES_F: ELEMENT_NAME = NI Car Payment, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 2006/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: Formula result rules use this input value

Check your formula result rules for indirect results that feed this input value.
Error loading seed data for PAY_ELEMENT_TYPES_F: ELEMENT_NAME = NI Car Payment Secondary, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 2006/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: Formula result rules use this input value

Check your formula result rules for indirect results that feed this input value.
Error loading seed data for PAY_ELEMENT_TYPES_F: ELEMENT_NAME = NI Car Primary, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 2006/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: Formula result rules use this input value

Check your formula result rules for indirect results that feed this input value.
Error loading seed data for PAY_ELEMENT_TYPES_F: ELEMENT_NAME = NI Car Secondary, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 2006/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: Formula result rules use this input value

Check your formula result rules for indirect results that feed this input value.
Error loading seed data for PAY_ELEMENT_TYPES_F: ELEMENT_NAME = NI Y, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 2006/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: Formula result rules use this input value

Check your formula result rules for indirect results that feed this input value.
Error loading seed data for PAY_ELEMENT_TYPES_F: ELEMENT_NAME = NIC Holiday, EFFECTIVE_START_DATE = 1996/04/06, EFFECTIVE_END_DATE = 2006/04/05, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: Formula result rules use this input value

Check your formula result rules for indirect results that feed this input value.





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply necessary patches:


    Then apply hrglobal.drv via adpatch
2. Check for problems as the patching progresses
3. Review necessary worker log files on failure.

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