Archive and Purge Ends in Error ORA-06502: PL/SQL: Numeric or Value Error: NULL Index Table Key Value (Doc ID 1620284.1)

Last updated on JUNE 20, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Attempting to run the Archive and Purge program and receive the following errors:

53187customer_trx_id :53187 p_worker_number : 1
Processing id:53187 type:CT at 26-sep-2013 03:42:28
  ...archiving
  ...deleting rows
  Processing id: type:CT at 26-sep-2013 03:42:31
Failed while checking the unpurgeable_trxn list
sqlcode = -6502ORA-06502: PL/SQL: numeric or value error: NULL index table key value
  Failed in Recursive purge
  sqlcode = -6502ORA-06502: PL/SQL: numeric or value error: NULL index table key value
Failed while dealing with Trx.
Error -6502 ORA-06502: PL/SQL: numeric or value error: NULL index table key value
  Failed in Recursive purge
  sqlcode = -6502ORA-06502: PL/SQL: numeric or value error: NULL index table key value
  Failed in the for loop
  sqlcode = -6502ORA-06502: PL/SQL: numeric or value error: NULL index table key value
  sqlcode = -6502ORA-06502: PL/SQL: numeric or value error: NULL index table key value
  Failed in drive_by_invoice
------------------------------------------------------------
Total No. of Chains Processed : 1742
End Time : 26-sep-2013 03:42:31
------------------------------ End -------------------------
Error -6502 ORA-06502: PL/SQL: numeric or value error: NULL index table key value


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