Unable to Rollback SLA Payroll Process, Errors: ORA-01403: no data found

(Doc ID 1303979.1)

Last updated on JULY 11, 2016

Applies to:

Oracle Payroll - Version 12.1.2 and later
Information in this document applies to any platform.

This note provides a brief overview of


Problem Statement:

When attempting to rollback Transfer to SLA process where Create Accounting was done in 'Draft' mode the following error occurs.

perform_asg_rollback 10
assact_id : 1505459
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.do_assact_rollback 10
p_info.assact_id1505459 11
p_info.action_date22-FEB-11 12
p_info.pact_id37746 13
pay_sla_pkg.delete_event 10
perform_asg_rollback 30
py_rollback_pkg.assact_error 10
py_rollback_pkg.assact_error 10
pay_core_utils.push_message 10

Fsev = Fsev = Fsev = Fsev = Fsev = Fsev = F Out } pyxpmsh
In { pylogpop
Out } pylogpop
ORA-01403: no data found
In { pyxipmt
message text = ORA-01403: no data found
message level = F,F
payroll_id text = 0
source_id text = 5,37746
line_text = 24, ORA-01403: no data found
Out } pyxipmt
In { pylogpop
Out } pylogpop

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1. Rollback Transfer to SLA process


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