My Oracle Support Banner

Rollback Payroll Run Errors: 'ORA-01403 No Data Found' and 'ORA-20001: Too Many Errors Encountered While Processing' OR Delete Record From Payroll Process Results form FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01403 (Doc ID 367717.1)

Last updated on OCTOBER 28, 2022

Applies to:

Oracle Payroll - Version and later
Information in this document applies to any platform.
Concurrent Program:ROLLBACK_RUN - Rollback Run


Problem Statement:

Rollback Payroll Run errors with

ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
ORA-01403: no data found
SQLERRMC ORA-20001: Too many errors encountered while processing
ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3159
ORA-06512: at line 2


ORA-20001: System Error: Procedure pay_balance_pkg.remove_asg_contribs at
Step missing assignment level balance for grp_defbal:xxxxx


FRM-40735: KEY-DELREC trigger raised unhandled exception ORA-01403

Output from the PYUPIP - shows

perform_asg_rollback 10
assact_id : 3832
py_rollback_pkg.val_assact_rollback 10
py_rollback_pkg.val_assact_rollback 40
py_rollback_pkg.val_assact_rollback 50
py_rollback_pkg.val_assact_rollback 30
py_rollback_pkg.val_assact_rollback 50
py_rollback_pkg.do_assact_rollback 10
p_info.assact_id3832 11
p_info.action_date22-MAR-06 12
p_info.pact_id2129 13
Entering: pay_balance_pkg.remove_asg_contribs 5
perform_asg_rollback 30


Further debug on pay_balance_pkg.remove_asg_contribs shows issue with defined_balance 8201

Debug5899 1
Debug5899 2
Debug8201 1
perform_asg_rollback 30


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

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