My Oracle Support Banner

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 01, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.