Scribd Logo
Upload

Welcome to Scribd!

  • 98 views

    AR Purge Notes 160212

    Uploaded by

    Harry Taieb
    There are two types of purging in Oracle Receivables: autoinvoice interface purge and transaction data archive & purge. The autoinvoice interface purge deletes data from specific tables for an operating unit by running the Autoinvoice Purge Program. The transaction data archive & purge archives data to archive tables, deletes transaction data from base tables, and clears the archive tables by running the Call New Archive and Purge program. After purging, the database administrator should export and import tables and indexes to reduce memory usage and increase performance.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as TXT, PDF, TXT or read online from Scribd

    AR Purge Notes 160212

    Uploaded by

    Harry Taieb
    98 views2 pages
    There are two types of purging in Oracle Receivables: autoinvoice interface purge and transaction data archive & purge. The autoinvoice interface purge deletes data from specific tables for an operating unit by running the Autoinvoice Purge Program. The transaction data archive & purge archives data to archive tables, deletes transaction data from base tables, and clears the archive tables by running the Call New Archive and Purge program. After purging, the database administrator should export and import tables and indexes to reduce memory usage and increase performance.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    There are two types of purging in Oracle Receivables: autoinvoice interface purge and transaction data archive & purge. The autoinvoice interface purge deletes data from specific tables for an operating unit by running the Autoinvoice Purge Program. The transaction data archive & purge archives data to archive tables, deletes transaction data from base tables, and clears the archive tables by running the Call New Archive and Purge program. After purging, the database administrator should export and import tables and indexes to reduce memory usage and increase performance.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    98 views2 pages

    AR Purge Notes 160212

    Uploaded by

    Harry Taieb
    There are two types of purging in Oracle Receivables: autoinvoice interface purge and transaction data archive & purge. The autoinvoice interface purge deletes data from specific tables for an operating unit by running the Autoinvoice Purge Program. The transaction data archive & purge archives data to archive tables, deletes transaction data from base tables, and clears the archive tables by running the Call New Archive and Purge program. After purging, the database administrator should export and import tables and indexes to reduce memory usage and increase performance.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 2

    AR Purging There are 2 Types of Purging in Oracle Receivables: 1) Autoinvoice Interface Purge 2) Transaction Data Archive & Purge

    Autoinvoice Interface Purge 1) Login to corresponding AR Purge User responsibility 2) Run Autoinvoice Purge Program from SRS window

    3) The program deletes the data from following tables for specific operating uni t attached to the responsibility RA_INTERFACE_DISTRIBUTIONS_ALL RA_INTERFACE_SALESCREDITS_ALL RA_INTERFACE_LINES_ALL RA_INTERFACE_ERRORS_ALL 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 ca lls New Archive and Purge program 3) This program archives the data in tables- AR_ARCHIVE_HEADER & AR_ARCHIVE_DETA IL 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 progr am 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 validat ion phase, then fails during the archive phase. Archive-Restart clears the Archi ve 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 ou tput 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 t he next purge run. To clear the archive tables use the TRUNCATE command in SQL w ith 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 p urged data. By recreating these objects, you can reduce the memory each object o ccupies in your tablespace and increase the performance of your system.

    You might also like