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 DECEMBER 03, 2019
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-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