Receivables Archive and Purge FAQ
(Doc ID 1073185.1)
Last updated on OCTOBER 22, 2018
Applies to:Oracle Receivables - Version 18.104.22.168 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
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.
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
|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  must be in the range of  to |
|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|