My Oracle Support Banner

Viewing Statement of Earnings fails with Error: ORA-20101: Error in pay_us_soe_balances_pkg.populate_earn_bal (Doc ID 1321248.1)

Last updated on AUGUST 16, 2023

Applies to:

Oracle HRMS (US) - Version 12.1 to 12.2.7 [Release 12.0 to 12.2]
Information in this document applies to any platform.


When attempting to view Statement of Earnings, the following error occurs.

ORA-20101: Error in pay_us_soe_balances_pkg.populate_earn_bal – ORA-01403: no data found
ORA-06512: at “APPS.PAY_US_SOE_BALANCES_PKG”, line 1204
FRM-40735: KEY-EXEQRY trigger raised unhandled exception ORA-20101.


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

1. Run Quickpay
2. Attempt to view SOE from quickpay, assignment, or assignment process results
3. Receive error





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.