My Oracle Support Banner

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

Last updated on FEBRUARY 16, 2019

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


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

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