Post 20627170 HRGLOBAL Fails Loading Pygbutable.ldt With ORA-01422: Exact Fetch Returns More on User Table PQP_PCSPS_ALPHA_EMPLOYER_CONTRIBUTION_RATES
(Doc ID 2103997.1)
Last updated on OCTOBER 22, 2023
Applies to:
Oracle HRMS (UK) - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
hrglobal fails loading pygbutable.ldt with the following error.
Uploading from the data file /xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8), xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt) to staging tables
Dumping LCT file /xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file /xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES CTO_COURT_ORDER_DAILY GB , PAY_USER_COLUMNS SOE Balances GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_USER_ROWS_F: B_USER_TABLE_NAME = PQP_PCSPS_ALPHA_EMPLOYER_CONTRIBUTION_RATES, B_LEGISLATION_CODE = GB, USER_TABLE_NAME = PQP_PCSPS_ALPHA_EMPLOYER_CONTRIBUTION_RATES, B_LEGISLATION_CODE = GB, ORA-01422: exact fetch returns more than requested number of rows
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8), xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt) to staging tables
Dumping LCT file /xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/pyusertable.lct(120.2.12010000.8) into FND_SEED_STAGE_CONFIG
Dumping LDT file /xxx/apps/apps_st/appl/pay/12.0.0/patch/115/import/US/loc_gb/pygbutable.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (PAY_USER_TABLES CTO_COURT_ORDER_DAILY GB , PAY_USER_COLUMNS SOE Balances GB ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for PAY_USER_ROWS_F: B_USER_TABLE_NAME = PQP_PCSPS_ALPHA_EMPLOYER_CONTRIBUTION_RATES, B_LEGISLATION_CODE = GB, USER_TABLE_NAME = PQP_PCSPS_ALPHA_EMPLOYER_CONTRIBUTION_RATES, B_LEGISLATION_CODE = GB, 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:
- Apply patch:20627170 or any patch that contains pygbutable.ldt.
- Run DataInstall and hrglobal.drv.
- Worker job fails loading pygbutable.ldt.
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 |