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 MAY 07, 2024
Applies to:
Oracle Payroll - Version 11.5.10.2 and laterInformation 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
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
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
Debug5899 2
Debug8201 1
perform_asg_rollback 30
Cause
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
Symptoms |
Cause |
Solution |
References |