Purging Transaction History

You can purge all transaction history and associated accounting information for your current organization, where the transaction date is before and including the purge date you enter and is in a closed period.

Note: You should be extremely cautious when purging transaction information. Once you commit the process, Oracle Inventory removes all related information from the database. You cannot view or report on this information once you purge it. For example, you can no longer report purged information with the Accrual Reconciliation Report, the Transaction Register, and so on.

Since the Job/Lot Composition functionality in Oracle Work in Process depends on the material transaction history, you should not enter a purge date which purges material transactions that are part of a genealogy you want to retain. See: the Job Lot Composition Report.

Prerequisites

arrow icon   To purge transactions:

  1. Navigate to the Purge Transactions or All Reports window.

  2. Enter Transaction Purge in the Name field. The Parameters window appears.

  3. Enter a name for your purge.

  4. Enter a date. Oracle Inventory purges transaction information if the transaction date is less than or equal to this date. This date must be less than or equal to the most recently closed period date.

  5. Choose Submit to launch the process.

    This concurrent process may actually spawn several independent requests, based on the number of accounting periods you are purging and the setting of the profile option INV: Max # of Txn Purge Processes.

Related Topics