HRGLOBAL Errors: 'Error loading seed data for PAY_USER_ROWS_F: B_USER_TABLE_NAME = SOE Balances' (Doc ID 2095119.1)

Last updated on JANUARY 10, 2017

Applies to:

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

Symptoms

When attempting to execute HRGLOBAL, an error occurs.

ERROR
-----------------------
Uploading from the data file /dnoili/applmgr/1200/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/dnoili/applmgr/1200/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.11), /dnoili/applmgr/1200/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt) to staging tables
Dumping LCT file /dnoili/applmgr/1200/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.11) into FND_SEED_STAGE_CONFIG
Dumping LDT file /dnoili/applmgr/1200/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES CTO_COURT_ORDER_DAILY GB , PAY_USER_COLUMNS SOE Balances GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for PAY_USER_ROWS_F: B_USER_TABLE_NAME = SOE Balances, B_LEGISLATION_CODE = GB, USER_TABLE_NAME = SOE Balances, B_LEGISLATION_CODE = GB, ORA-20001: PAY_7884_USER_TABLE_UNIQUE:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Execute HRGLOBAL after patching



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