My Oracle Support Banner

Patch 17395845 Fails On PERGBELE.ldt (Doc ID 1606936.1)

Last updated on SEPTEMBER 14, 2022

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

When attempting to apply the hrglobal.drv file, 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.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
ORA-04088: error

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.