Hrglobal Fails Loading pqgbfun.ldt with ORA-01422: exact fetch returns more than requested number of rows
Last updated on FEBRUARY 06, 2018
Applies to:Oracle HRMS (Ireland) - Version 12.2.5 and later
Information in this document applies to any platform.
When attempting to run hrglobal, loading pqgbfun.ldt fails with the following error.
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/xxx/ff/12.0.0/patch/115/import/fffunction.lct, /xxx/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbfun.ldt) to staging tables
Dumping LCT file /xxx/ff/12.0.0/patch/115/import/fffunction.lct into FND_SEED_STAGE_CONFIG
Dumping LDT file /xxx/pqp/12.0.0/patch/115/import/US/loc_gb/pqgbfun.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FUNCTIONS GB BEN_GET_ABSENCE_ADDITIONAL_ATTRIBUTES , FUNCTION_CONTEXT_USAGES 2 DATE_EARNED ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for FUNCTION_PARAMETERS: LEGISLATION_CODE = GB, FUNCTION_NAME = PQP_GAP_GET_ABSENCE_ELEMENT_ENTRY_SUBPRIORITY, SEQUENCE_NUMBER = 1, PARAMETER_NAME = P_ABSENCE_START_DATE, 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:
- Upgrade to R12.HR_PF.C.Delta.7.
- Run DataInstall/hrglobal.drv.
- Worker job failed loading pqgbfun.ldt.
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