Hrglobal errors with ORA-00001: unique constraint (HR.PAY_FORMULA_RESULT_RULES_F_PK) violated (Doc ID 1959710.1)

Last updated on JANUARY 02, 2017

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Oracle HRMS (UK)

When attempting to apply hrglobal, the following error occurs.
<Patch 18004477> (RUP7) has just been applied and we are following the instructions in the readme to run in the amended hrglobals.drv.


"Log file: /u02/oracle/oracle_SID/apps/apps_st/appl/admin/oracle_SID/log/loc_gb_pergbfrr_ldt.log
Error calling FNDLOAD function.

Loading data using FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @PAY:patch/115/import/pyseedfrr.lct @PER:patch/115/import/US/loc_gb/pergbfrr.ldt - LEG_VIEW=hr_per_gb_implementation


Uploading from the data file /u02/oracle/oracle_SID/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbfrr.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u02/oracle/oracle_SID/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedfrr.lct(120.1.12010000.9), /u02/oracle/oracle_SID/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbfrr.ldt) to staging tables
Dumping LCT file /u02/oracle/oracle_SID/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyseedfrr.lct(120.1.12010000.9) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u02/oracle/oracle_SID/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_gb/pergbfrr.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_STATUS_PROCESSING_RULES_F Advance Clearup GB 0001/01/01 4712/12/31 P , PAY_FORMULA_RESULT_RULES_F Working Tax Credit GB 2003/04/06 2006/04/05 P V_MESS_STOP ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for PAY_FORMULA_RESULT_RULES_F: ELEMENT_NAME = NI, ASSIGNMENT_STATUS_TYPE = , BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, EFFECTIVE_START_DATE = 0001/01/01, EFFECTIVE_END_DATE = 4712/12/31, PROCESSING_RULE = P, SPR_ELEMENT_NAME = NI, SPR_ASSIGNMENT_STATUS_TYPE = , BUSINESS_GROUP_NAME = , LEGISLATION_CODE = GB, EFFECTIVE_START_DATE = 2012/01/01, EFFECTIVE_END_DATE = 4712/12/31, SPR_PROCESSING_RULE = P, RESULT_NAME = L_RET_MSG, ELEMENT_NAME = NI, INPUT_NAME = Message, ORA-00001: unique constraint (HR.PAY_FORMULA_RESULT_RULES_F_PK) violated "



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Apply <Patch 18004477>
2. Run hrglobal
 


Changes

 

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