Pqpenext.ldt Fails With ORA-01422: Exact Fetch Returns More Than Requested Number of Rows When Applying Hrglobal.drv
(Doc ID 2260260.1)
Last updated on SEPTEMBER 06, 2019
Applies to:
Oracle HRMS (UK) - Version 12.1 HRMS RUP9 to 12.1 HRMS RUP9 [Release 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1 HRMS RUP9 version, UK Payroll
After applying patches HRMS RUP 9 and <Patch 25487840>.
Performed DataInstall for Global and GB legislations.
Running the hrglobal.drv receive error:
Uploading from the data file /u01/app/oracle/PUAT/apps/puat/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpenext.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/app/oracle/PUAT/apps/puat/apps_st/appl/ben/12.0.0/patch/115/import/benextse.lct(120.11.12010000.3), /u01/app/oracle/PUAT/apps/puat/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpenext.ldt) to staging tables
Dumping LCT file /u01/app/oracle/PUAT/apps/puat/apps_st/appl/ben/12.0.0/patch/115/import/benextse.lct(120.11.12010000.3) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01/app/oracle/PUAT/apps/puat/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpenext.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXTRACT PQP GB TP Type 4 - Teachers Appointments ( England and Wales ) , EXTRACT PQP GB TP Type 4 - Teachers Appointments 2015 ( England and Wales ) ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 2 - Teachers Additional Contributions ( England and Wales ), RECORD_NAME = PQP GB TP Type 2 Detail - Teachers Additional Contributions ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 1 - Teachers Annual Returns ( England and Wales ), RECORD_NAME = PQP GB TP Type 1 - Teachers Annual Returns ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 1 - Teachers Annual Returns 2015( England and Wales ), RECORD_NAME = PQP GB TP Type 1 - Teachers Annual Returns 2015( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 4 - Teachers Appointments 2015 ( England and Wales ), RECORD_NAME = PQP GB TP Type 4 - Teachers Appointments 2015 ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/app/oracle/PUAT/apps/puat/apps_st/appl/ben/12.0.0/patch/115/import/benextse.lct(120.11.12010000.3), /u01/app/oracle/PUAT/apps/puat/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpenext.ldt) to staging tables
Dumping LCT file /u01/app/oracle/PUAT/apps/puat/apps_st/appl/ben/12.0.0/patch/115/import/benextse.lct(120.11.12010000.3) into FND_SEED_STAGE_CONFIG
Dumping LDT file /u01/app/oracle/PUAT/apps/puat/apps_st/appl/pqp/12.0.0/patch/115/import/US/loc_gb/pqpenext.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (EXTRACT PQP GB TP Type 4 - Teachers Appointments ( England and Wales ) , EXTRACT PQP GB TP Type 4 - Teachers Appointments 2015 ( England and Wales ) ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 2 - Teachers Additional Contributions ( England and Wales ), RECORD_NAME = PQP GB TP Type 2 Detail - Teachers Additional Contributions ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 1 - Teachers Annual Returns ( England and Wales ), RECORD_NAME = PQP GB TP Type 1 - Teachers Annual Returns ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 1 - Teachers Annual Returns 2015( England and Wales ), RECORD_NAME = PQP GB TP Type 1 - Teachers Annual Returns 2015( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
Error loading seed data for EXT_DATA_ELMT: FILE_NAME = PQP GB TP Type 4 - Teachers Appointments 2015 ( England and Wales ), RECORD_NAME = PQP GB TP Type 4 - Teachers Appointments 2015 ( England and Wales ), DATA_ELEMT_NAME = PQP GB TP Sex Digit - Detail Teachers Pension Extract ( England and Wales ), FIELD_SHORT_NAME = SEX, ORA-01422: exact fetch returns more than requested number of rows
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply HRMS RUP 9 and Patch 25487840 - TYE17: P11D LEGISLATIVE CHANGES FOR 2016-17
Cause
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
Symptoms |
Cause |
Solution |
References |