HRGLOBAL Fails Loading Pygbutable.ldt With ORA-01422: Exact Fetch Returns More on User Table DIRECT_EARNINGS_ATTACHMENT (Doc ID 2261863.1)

Last updated on MAY 08, 2017

Applies to:

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

Symptoms

Hrglobal fails loading pygbutable.ldt with the following error:

Uploading from staging tables
Error loading seed data for PAY_USER_COLUMN_INSTANCES_F: B_USER_TABLE_NAME = DIRECT_EARNINGS_ATTACHMENT_D
AILY, B_LEGISLATION_CODE = GB, B_USER_COLUMN_NAME = DEA_PERCENTAGE, B_LEGISLATION_CODE = GB, ORA-01422: exa
ct fetch returns more than requested number of rows
Error loading seed data for PAY_USER_COLUMN_INSTANCES_F: B_USER_TABLE_NAME = DIRECT_EARNINGS_ATTACHMENT_M
ONTHLY, B_LEGISLATION_CODE = GB, B_USER_COLUMN_NAME = DEA_PERCENTAGE, B_LEGISLATION_CODE = GB, ORA-01422: e
xact fetch returns more than requested number of rows
Error loading seed data for PAY_USER_COLUMN_INSTANCES_F: B_USER_TABLE_NAME = DIRECT_EARNINGS_ATTACHMENT_W
EEKLY, B_LEGISLATION_CODE = GB, B_USER_COLUMN_NAME = DEA_PERCENTAGE, B_LEGISLATION_CODE = GB, ORA-01422: ex
act fetch returns more than requested number of rows

 Steps to Reproduce

The issue can be reproduced at will with the following steps:

1. Apply any patch that contains pygbutable.ldt.
2. Run DataInstall and hrglobal.drv.
3. Worker job fails loading pygbutable.ldt

Cause

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