HRGLOBAL.drv Is Failing After RUP8 HRMS ORA-1: unique constraint (HR.HR_STU_EXCEPTIONS_PK) violated (Doc ID 2054199.1)

Last updated on SEPTEMBER 10, 2015

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

When attempting to apply HRGLOBAL,
the following error occurs.

ERROR
-----------------------

Uploading from the data file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_gb/pegbutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files
(/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8),
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_gb/pegbutable.ldt) to staging tables
Dumping LCT file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file /code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_gb/pegbutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES BANK_HOLIDAYS GB ,PAY_USER_COLUMN_INSTANCES_F FORMULA_NAME GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for PAY_USER_TABLES:  B_USER_TABLE_NAME =PQP_CONTRACT_TYPES, B_LEGISLATION_CODE = GB,  ORA-1: unique constraint
(HR.HR_STU_EXCEPTIONS_PK) violated
 
Log file:
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/admin/goxhrp/log/loc_ie_perieutable_ldt.log
Error calling FNDLOAD function.
 
Uploading from the data file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_ie/perieutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files
(/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8),
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_ie/perieutable.ldt) to staging tables
Dumping LCT file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_ie/perieutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES EHECS_ASG_CATG_TAB IE , PAY_USER_COLUMNS PQP_CONTRACT_TYPES IE ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_USER_TABLES:  B_USER_TABLE_NAME =PQP_COMPANY_WORK_PATTERNS, B_LEGISLATION_CODE = IE,  ORA-1: unique
constraint (HR.HR_STU_EXCEPTIONS_PK) violated
  Error loading seed data for PAY_USER_TABLES:  B_USER_TABLE_NAME =PQP_CONTRACT_TYPES, B_LEGISLATION_CODE = IE,  ORA-1: unique constraint (HR.HR_STU_EXCEPTIONS_PK) violated
 
Log file:
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/admin/goxhrp/log/loc_nl_penlutable_ldt.log
Error calling FNDLOAD function.
 
Uploading from the data file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_nl/penlutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files
(/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8),
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_nl/penlutable.ldt) to staging tables
Dumping LCT file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file
/code01_336/applmgr/R12/goxhrp/apps/apps_st/appl/per/12.0.0/patch/115/import/US/loc_nl/penlutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES NL_ADDITIONAL_SENIOR_TAX_REDUCTION NL ,PAY_USER_COLUMN_INSTANCES_F J NL ) into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_COLUMN_INSTANCES_F J NL ,PAY_USER_COLUMN_INSTANCES_F UNDER65 NL ) into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_COLUMN_INSTANCES_F UNDER65 NL , PAY_USER_COLUMNS PQP_NL_PGGM_AGE_DEPENDANT_THRESHOLD_CUSTOM NL ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for PAY_USER_TABLES:  B_USER_TABLE_NAME =PQP_COMPANY_WORK_PATTERNS, B_LEGISLATION_CODE = NL,  ORA-1: uniqueconstraint (HR.HR_STU_EXCEPTIONS_PK) violated

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run HRGLOBAL

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