Patch 17395845 Fails On PERGBELE.ldt
Last updated on JANUARY 10, 2017
Applies to:Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Patch Application Issues, on development instance patched to R12.HR_PF.B.delta.5
When attempting to apply the hrglobal.drv file, the following error occurs.
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files $PAY_TOP/patch/115/import/pyseedele.lct(120.0.12010000.7), /u01/software/apphr/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt) to staging tables
Dumping LCT file $PAY_TOP/patch/115/import/pyseedele.lct(120.0.12010000.7) 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 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_ELEMENT_TYPES_F: ELEMENT_NAME = PAYE Details, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, ORA-20001: The item 'PAYE_DETAILS_TAX_CODE_ENTRY_VALUE' is referenced by one or more verified formulae.
Cause: You have attempted to change or remove an item which is referenced by one or more formulae. Removal of this item will invalidate the verified formula and cannot be allowed.
Action: Remove the verified formula before removing the item.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.FFDICT", line 2557
ORA-06512: at "APPS.FF_DATABASE_ITEMS_BRD", line 4
The issue can be reproduced at will with the following steps:
1. Apply <patch 17395845>
2. Run Data install, choose GB PER and PAY
3. Apply hrglobal.drv.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms