HRGLOBAL Fails Loading Pygbutable.ldt With ORA-01422: Exact Fetch Returns More on table PQP_LGPS_SCOTLAND_CONTRIBUTION_RATES (Doc ID 2129812.1)

Last updated on MAY 03, 2017

Applies to:

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

Symptoms

Hrglobal fails loading pygbutable.ldt with the following error.

Uploading from the data file $PAY_TOP/patch/115/import/US/loc_gb/pygbutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files ($PAY_TOP/patch/115/import/pyusertable.lct(120.5.12020000.5), $PAY_TOP/patch/115/import/US/loc_gb/pygbutable.ldt) to staging tables
Dumping LCT file $PAY_TOP/patch/115/import/pyusertable.lct(120.5.12020000.5) into FND_SEED_STAGE_CONFIG
Dumping LDT file$PAY_TOP/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_COLUMN_INSTANCES_F: B_USER_TABLE_NAME = PQP_LGPS_SCOTLAND_CONTRIBUTION_RATES, B_LEGISLATION_CODE = GB, B_USER_COLUMN_NAME = LGPS Salary Band, B_LEGISLATION_CODE = GB, ORA-01422: exact fetch returns more than requested number of rows



Steps to Reproduce:

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


  1. Apply <Patch 22810386> or any patch that contains pygbutable.ldt.
  2. Run DataInstall and hrglobal.drv.
  3. Worker job fails loading pygbutable.ldt

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