My Oracle Support Banner

Receivables Archive and Purge FAQ (Doc ID 1073185.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 to 12.1.2 [Release 11.5.10 to 12.1]
Oracle Receivables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
ARPURGE - New Archive and Purge
ARARCALL - Call New Archive and Purge
ARARCONT - Archive Preview

Purpose

This document discusses some of the commonly asked questions about Archive and Purge process in Oracle Receivables. All features mentioned are current as of the latest release till 12.1.1.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 1. Why Use Archive and Purge Program?
 2. Is it possible to rollback from Archive and Purge?
 3. On what levels Archive can be performed?
 4. What are the tables that are purged but not archived as part of the Archive/Purge process?
 5. What are the tables purged by AR Archive/Purge Process?
 6. What is the Criteria for Purge?
 7. What are the pre-requisites to be followed before Running Archive and Purge?
 8. What are Chain Transactions and are they Eligible for Archive and Purge Process?
 9. What can be one of the possible causes of Performance Problem Running the AR Archive and Purge Process?
 10. What can cause Miscellaneous receipts not getting Purged ?
 11. What is the difference in 'Standard Archive and Purge' and 'Call New Archive and Purge' Program?
 12 What is the role of GL Date parameter in Standard Archive and Purge Process?
 13. How do You Restart the Purge When it Fails?
 14. How do you Archive and Purge when using Cash Basis?
 15. What manual should I read for more information on Archive and Purge?
 16. Why certain transaction(s) are added to unpurgeable transaction list even though all the relevant criteria matches?
 17. Can you archive and purge customers like invoices or transactions can be archived and purged? (Can customers be deleted?)
 18. Why Archive and Purge Not Happen In Receivables When MOAC
Is Set In Multi Org Mode?
 19. Does Call new Archive and Purge Program considers set_of_books_id and org_id  while picking up the data?
 Commonly Encountered Errors:
    i) New Archive and Purge fails with ORA-06502: PL/SQL: numeric or value error: character to number conversion error
    ii) New Archive and Purge fails with Cause: FDPSTP failed due to ORA-22165: given index [1001] must be in the range of [1] to [1000]
    iii) The Log File of AR Purge Program states 'Already In The Unpurgeable List'
    iv) No Data Found In Ar_Archive_Header And Ar_Archive_Detail Tables
    v) Project Accounting invoices are not selected for Archive/Purge.
    vi) Cannot Submit Archive Preview. No LOV For Archive Period
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.