How You Purge Staging Tables for Supply Chain Planning

Use the Purge Staging Tables scheduled process to delete data from the staging tables used during collections processes for supply chain planning.

Delete data from the staging tables to free up space and improve performance. Use the Scheduled Processes work area to run the scheduled process. This topic explains the parameters of the Purge Staging Tables scheduled process. For information on how to run scheduled processes, refer to the Scheduled Processes chapter in the Implementing Common Features for SCM guide.

Provide values for these parameters to determine which data records will be purged from the staging tables when you run the Purge Staging Tables scheduled process.

Parameter	Notes
Source System	You must select a source system. For data collected from the Oracle Fusion source system, select OPS. For data collected from an external system, select the applicable source system code.
Record Type	You must select a record type, but you can select All if you want to purge all records that meet the values of the other parameters, regardless of their record type. The record types other than the All type are the status of records in the staging tables in regard to the next stage of the collections process. The next stage of the collections process is the import of the records that are in the staging tables into the tables that comprise the planning data repository. All: All records regardless of status. Complete: Records that were successfully imported into the tables that comprise the planning data repository. Error: Records that are in the Error status in the staging tables after import into the planning data repository was tried, but not successful. New: Records that were collected into the staging tables, but import into the planning data repository hasn't been tried yet. Retry: Records in the staging tables for which import into the planning data repository is being tried again. Warning: Records in the staging tables for which a warning occurred when the record was imported into the planning data repository.
Collection Cycle ID	You can enter a request number if you want to do so.
Collected From Date and Collected To Date	You can provide these dates if you want to purge data within a specific time frame.
The set of specific entities for which data is collected and deletion of the data from the staging tables is supported.	Each entity is a parameter for the scheduled process. You can select No for any of the parameters if you don't want to purge the data for that entity. The default value for each parameter is Yes.