Transaction Data Archive & Purge

1) Login to corresponding AR Archive & Purge User responsibility

2) Run ‘Call New Archive and Purge’ program from SRS window which will eventually calls ‘New Archive and Purge’ program

3) This program archives the data in tables- AR_ARCHIVE_HEADER & AR_ARCHIVE_DETAIL and deletes transaction data from following base tables:

AR_ACTION_NOTIFICATIONS

AR_ADJUSTMENTS

AR_BATCHES

AR_CALL_ACTIONS

AR_CASH_BASIS_DISTRIBUTIONS

AR_CASH_RECEIPTS

AR_CASH_RECEIPT_HISTORY

AR_CORRESPONDENCE_PAY_SCHED

AR_CUSTOMER_CALL_TOPICS

AR_MISC_CASH_DISTRIBUTIONS

AR_NOTES

AR_PAYMENT_SCHEDULES

AR_RATE_ADJUSTMENTS

AR_RECEIVABLE_APPLICATIONS

RA_BATCHES

RA_CUSTOMER_TRX

RA_CUSTOMER_TRX_LINES

RA_CUST_TRX_LINE_GL_DIST

RA_CUST_TRX_LINE_SALESREPS

AR_CORRESPONDENCES

AR_DISTRIBUTIONS

4) If in case, Archive & Purge program fails, you can submit ‘Archive-Restart’ program from SRS window. It can be used to save the system from having to

revalidate all purge candidates, if Archive & Purge has completed the selection and validation phase, then fails during the archive phase. Archive-Restart

clears the Archive Header and Detail tables and submits the archive report. When submitting the Archive-Restart program you must provide the following

parameters: Archive Level, Summary Report Only, Number of Workers, Commit Size, and Archive Id

5) Run ‘Archive to File’ program from SRS window to move your archive data to a file in the directory with the file name . Also ensure that you move your

archive output from the AR_TOP/out directory to an appropriate storage area. Otherwise, it will be deleted when your system administrator clears the output

directories.

6) Once archive data has been stored the archive tables must be cleared before the next purge run. To clear the archive tables use the TRUNCATE command in

SQL with the following tables:

AR_ARCHIVE_HEADER

AR_ARCHIVE_DETAIL

7) The following tables will be cleared automatically the next time you run the Archive/Purge programs.

AR_PURGE_TRX_AUX

AR_PURGE_REC_AUX

AR_ARCHIVE_PURGE_LOG

AR_ARCHIVE_PURGE_INTERIM

AR_PURGE_OE_EXCEPTIONS

8) After you purge your database, you should contact your Database Administrator (DBA), so that he can export and import the tables and indexes from which

you purged data. By recreating these objects, you can reduce the memory each object occupies in your tablespace and increase the performance of your system.

/