Unable To Purge Transactions After Applying Write Off Receipt

(Doc ID 1494430.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
ARPURGE module: New Archive and Purge
Archive and Purge Not allowing Transaction to Purge after application of Write Off Receipt

Symptoms

After application of receipt to Receipt Write Off Transaction we ran the ARPURGE module: New Archive and Purge with cut off 30- Nov - 2012.
Records were not Purged and Transactions are Closed and processed to General Ledger.

Error in New Archive and Purge Log file shows the following.

Processing id:1013 type:CT at 25-sep-2012 05:24:57
  ...archiving
ENTERING OE_SYS_PARAMETERS.VALUE
Going to get the value for MASTER_ORGANIZATION_ID
ENTERING OE_SYS_PARAMETERS_PVT.VALUE
VALUE FROM DB125
Parameter value fetched from table.  
 PARAMETER VALUE: 125
  ...deleting rows
  Processing id:37349 type:CR at 25-sep-2012 05:25:00
    ...which has unpurgeable histories_37349
  Add id:1016 to unpurgeable transaction list
  Add id:1023 to unpurgeable transaction list
Rollback Work

 

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