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.


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

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

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


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