Hrglobal Fails Loading pqpgbpsi.ldt with ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2082407.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

Problem Statement:

When attempting to run hrglobal, loading pqpgbpsi.ldt fails with the following error.

Uploading from the data file /xxx/pqp/12.0.0/patch/115/import/US/loc_gb/pqpgbpsi.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/xxx/ben/12.0.0/patch/115/import/benextse.lct(120.13), /xxx/pqp/12.0.0/patch/115/import/US/loc_gb/pqpgbpsi.ldt) to staging tables
Dumping LCT file /xxx/ben/12.0.0/patch/115/import/benextse.lct(120.13) into FND_SEED_STAGE_CONFIG
Dumping LDT file /xxx/pqp/12.0.0/patch/115/import/US/loc_gb/pqpgbpsi.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXTRACT PQP GB PenServer Standard Interface File - Address , EXTRACT PQP GB PenServer Standard Interface File - Scheme Contribution Rate History ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for EXTRACT: FILE_NAME = PQP GB PenServer Standard Interface File - Payment History, 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.  Upgrade to R12.HR_PF.C.Delta.7.
  2. Run DataInstall/hrglobal.drv.
  3. Worker job failed loading pqpgbpsi.ldt.

 

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