View Statement of Earnings (SOE) Errors: ORA-20101: Error in pay_us_soe_balances_pkg.populate_local_balance, ORA-01422 and ORA-06512 at PAY_US_SOE_BALANCES_PKG (Doc ID 2220425.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to view the Statement of Earnings (SOE) detail for an employee, the following error occurs.

ERROR
-----------------------
ORA-20101: Error in pay_us_soe_balances_pkg.populate_local_balance - ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PAY_US_SOE_BALANCES_PKG", line 2634

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
View SOE



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