Unable To Run Hrglobal.drv due to File Layouts of Penserver

(Doc ID 2082832.1)

Last updated on MAY 01, 2018

Applies to:

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


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

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


 Applied Patch 19667418


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