Pay Archive and SOE, Errors: ORA-20001: Assertion failure detected at location get_new_latest_bal_value:1 (Doc ID 1610579.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.

Symptoms

When attempting to run payroll archive the following error occurs for a few employees.

Payroll Archive error: Error at step 7 in pay_ac_action_arch.populate_elements-ORA-20001: Assertion failure detected at location get_new_latest_bal_value:1.

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.

 

SOE error:

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



Cause

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