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 APRIL 08, 2016

Applies to:

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




Symptoms

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
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Too many errors encountered while processing
ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3159
ORA-06512: at line 2

OR  

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

OR

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

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