New Archive and Purge Not Purging Same Set of Transactions are Related in More Than One Way: Errors Are: Failed in Recursive Purge, ORA-01403: No Data Found (Doc ID 1330159.1)

Last updated on JANUARY 25, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:ARARCALL - Call New Archive and Purge
Release 11i and Release 12


Symptoms

New Archive and Purge fails with the following errors in the logfile:

4859224 customer_trx_id :4859224 p_worker_number : 1
Processing id:4859224 type:CT at 28-mar-2011 01:28:09
...archiving
...deleting rows
No need to lock ra_batches table
Processing id:2723083 type:CR at 28-mar-2011 01:28:09
...deleting rows
Receipt_id: 2723083 do not have a batch_id stamped
Processing id:4927309 type:CT at 28-mar-2011 01:28:13
...archiving
...deleting rows
No need to lock ra_batches table
Processing id:2723088 type:CR at 28-mar-2011 01:28:15
...deleting rows
Receipt_id: 2723088 do not have a batch_id stamped
Processing id:4927309 type:CT at 28-mar-2011 01:28:15
Processing id:4927309 type:CT at 28-mar-2011 01:28:15
Processing id:2723088 type:CR at 28-mar-2011 01:28:15
Failed in Recursive purge
sqlcode = 100ORA-01403: no data found
Failed while dealing with Trx.
Error 100 ORA-01403: no data found
Failed in Recursive purge
sqlcode = 100ORA-01403: no data found
Id : 4859224
...deleted by another instance

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