Error While Running Hrglobal After Applying Patch 17245427 (Doc ID 1606805.1)

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.
***Checked for relevance on 04-Jan-2016***

Symptoms

On :  12.1.3 version, UK Payroll,

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

Uploading from the data file /dnoili/applmgr/1200/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/dnoili/applmgr/1200/pay/12.0.0/patch/115/import/pyseedele.lct(120.0.12010000.12), /dnoili/applmgr/1200/per/12.0.0/patch/115/import/US/loc_gb/pergbele.ldt) to staging tables
Dumping LCT file /dnoili/applmgr/1200/pay/12.0.0/patch/115/import/pyseedele.lct(120.0.12010000.12) into FND_SEED_STAGE_CONFIG
Dumping LDT file /dnoili/applmgr/1200/per/12.0.0/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_INPUT_VALUES_F:  ELEMENT_NAME = Setup RTI Earnings Free of Tax and NI Balance, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, NAME = Earnings Free of NI Amount, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB,  ORA-20001: The name 'SETUP_RTI_EARNINGS_FREE_OF_TAX_AND_NI_BALANCE_EARNINGS_FREE_OF_NI_AMOUNT_VALEUR_' is already used by a Database Item

Cause:        There is already a Database Item called by the name that you have chosen.

Action:        Please choose another name.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.FFDICT", line 1601
ORA-06512: at "APPS.FF_DATABASE_ITEMS_BRI", line 8
ORA-04088: error during execution of trigger 'APPS.FF_DATABASE_ITEMS_BRI'




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 17245427.
2. Run Data install, choose global option along with UK PER and PAY.
3. Apply hrglobal.drv
4. Review log files.



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