BEE Batch Transfer Process Error ORA-01403: No Data Found ORA-06512: In "APPS.PY_ROLLBACK_PKG (Doc ID 2066708.1)

Last updated on OCTOBER 15, 2015

Applies to:

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

Symptoms

On : 12.2.4 version, Element Types, Links, Entries

When attempting to run BEE Batch Process, the following error occurs.

ERROR
-----------------------
perform_asg_rollback                                                    10
assact_id : 297865                                                                                                       
py_rollback_pkg.val_assact_rollback                                     10
py_rollback_pkg.val_assact_rollback                                     40
perform_asg_rollback                                                    30
pay_payroll_actions_bru                                                 10
pay_payroll_actions_bru                                                 3
payplnk.set_header_status                                               5
payplnk.set_header_status                                               35
-------------------------------------------------------------------------
   Out } pyfldlf
   In  { pylogseh
     In  { pyxpmsh
     Out } pyxpmsh
     In  { pylogpop
     Out } pylogpop
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01403: no data found
ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3360
ORA-06512: at line 2

SQL_NO 4809
TABLE_NAME py_rollback_pkg.rollback_payroll_action
APP-PAY-06881: Error ORA-01403: no data found
ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3360
ORA-06512: at line 2
has occurred in table py_rollback_pkg.rollback_payroll_action at location 4809

Cause:        an oracle error has occurred.  The failure was reported on table py_rollback_pkg.rollback_payroll_action at location 4809 with the error text ORA-01403: no data found
ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 3360
ORA-06512: at line 2
.  

Action:        Please contact your support representative.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run process Bee Batch Process


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