My Oracle Support Banner

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 FEBRUARY 23, 2019

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.