Pay Archive and SOE, Errors: ORA-20001: Assertion failure detected at location get_new_latest_bal_value:1
Last updated on OCTOBER 31, 2016
Applies to:Oracle Payroll - Version 12.1.3 and later
Oracle HRMS (US) - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
When attempting to run payroll archive the following error occurs for a few employees.
Cause: an internal error has occurred at location get_new_latest_bal_value:1.
Action: please contact your Oracle customer representative.
Error at step 20 in pay_ac_action_arch.get_current_elements-ORA-20001: Error at step 7 in pay_ac_action_arch.populate_elements
Error in pay_us_action_arch.process_actions-ORA-20001: Error at step 7 in pay_ac_action_arch.populate_elements
Error at step 21 in pay_us_action_arch.action_archive_data-ORA-20001: Error at step 7 in pay_ac_action_arch.populate_elements
For the same employees, there is an error when attempting to open the Statement of Earnings (SOE) form.
ORA-20101: Error in Pay_us_soe_balances_pkg.populate_fed_balance - ORA-20001 Assertion failure detected at location get_new_latest_bal_value:1.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Submit the Payroll archiver process and it errors upon running
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