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.
Symptoms
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.
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
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |