Fusion Global Payroll: ORA-20001: An Internal Assertion Test Couldn't be Completed at Location pay_balance_pkg.chk_rel_action on Quickpay or Retro Proccess (Doc ID 3051635.1)

Last updated on OCTOBER 03, 2024

Applies to:

Symptoms

When attempting to QuickPay Or run the Retro process, the following error occurs. 

There was a ORA-20001: An internal assertion test couldn't be completed at location pay_balance_pkg.chk_rel_action:inv_rel_act. Contact your help desk.ORA-06512: at "FUSION.PAY_PROC_LOGGING", line 675ORA-06512: at "FUSION.PAY_CORE_UTILS", line 1700ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 5915ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 5976ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 6186ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 6249ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 6365ORA-06512: at line 1 system error in the database_item table at location 1520. Contact your help desk.

Note: The error is employee specific.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
-Create QP or run retro process
-Error prompted

Cause

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