HRGLOBAL Fails After Patch 27683815 With "B_USER_TABLE_NAME = PQP_COMPANY_WORK_PATTERNS" ORA-20001: PAY_7038_USERTAB_VALUE_UNIQUE

(Doc ID 2401776.1)

Last updated on MAY 22, 2018

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, UK Payroll

When attempting to run HRGLOBAL
the following error occurs.

ERROR
-----------------------
Uploading from the data file /u02/oracle/EPPD/apps/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u02/oracle/EPPD/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.11), /u02/oracle/EPPD/apps/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbutable.ldt) to staging tables
Dumping LCT file /u02/oracle/EPPD/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.11) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u02/oracle/EPPD/apps/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES PQP_COMPANY_WORK_PATTERNS GB , PAY_USER_COLUMNS PQP_TRAVEL_PURPOSE GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_USER_COLUMN_INSTANCES_F:  B_USER_TABLE_NAME = PQP_COMPANY_WORK_PATTERNS, B_LEGISLATION_CODE = GB, B_USER_COLUMN_NAME = PQP_MON_FRI_8_HOURS, B_LEGISLATION_CODE = GB,  ORA-20001: PAY_7038_USERTAB_VALUE_UNIQUE:



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. 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