Unable To Run Hrglobal.drv due to File Layouts of Penserver (Doc ID 2082832.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

 
Find that HRGlobal.drv is failing after the application of <Patch 19667418> . Encountering the following issue:

Uploading from the data file /oracle/clnbug01/apps/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpgbpsi.ldt

Altering database NLS_LANGUAGE environment to AMERICAN Dump from LCT/LDT files ($BEN_TOP/patch/115/import/benextse.lct(120.11.12010000.3), $PQP_TOP/patch/115/import/US/loc_gb/pqpgbpsi.ldt) to stage tables Dump LCT file $BEN_TOP/patch/115/import/benextse.lct(120.11.12010000.3) into FND_SEED_STAGE_CONFIG Dump LDT file $PQP_TOP/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 Upload from stage 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
 

Error
FNDLOAD APPS/***** 0 Y UPLOAD_PARTIAL @BEN:patch/115/import/benextse.lct @PQP:patch/115/import/US/loc_gb/pqpgbpsi.ldt EXTRACT LEG_VIEW=hr_pay_gb_implementation



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

1. Apply Patch 19667418 tye15: implementation of shared parental leave and pay april 2015
2. Run hrglobal.drv
3. Error is faced

Changes

 Applied Patch 19667418

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