Using Archive and Purge (Oracle Receivables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Using Archive and Purge

Databases with high volumes of transactions rapidly increase in size and memory requirements. This can have a detrimental impact on performance for both online and background processing. Receivables stores large quantities of historical data to maintain audit trails, but this data need not be available online. The Archive and Purge feature lets you periodically save and delete transactions that you no longer need online to reclaim space in your database and improve system performance.

Depending on your business needs, you can archive records at one of three levels of detail: 'header-level', 'header and line-level', and 'header, line, and distribution-level'. Transactions are purged from the database based on the parameters you specify. The purge process will remove eligible transactions and all activities relating to these transactions such as adjustments, credits, reversals, calls, sales credits, and receipts.

For example, in the following diagram Invoice A has been paid by Receipt 1, which also partially paid Invoice B. Receipt 2 is used to pay the remainder of Invoice B. In addition, Invoice B is applied to a commitment with Invoice C. Invoice C is paid by Receipt 3 and a Credit Memo. All of these transactions are considered to be members of a single chain of related transactions. The Archive and Purge program rejects the entire chain if any member does not meet the purge criteria.

It is important to read this essay in its entirety before running the Archive and Purge programs. Archive and Purge deletes transaction information from your database and this essay outlines the steps you must take to ensure that all critical information and reports are available for future use.

Attention: You should not use the Receivables Archive and Purge program if you are using cash basis accounting.

Using Archive and Purge

See Also