How You Purge Collected Data from the Data Repository for Supply Chain Planning

Use the Purge Data Repository scheduled process to purge data collected by supply chain planning collections processes into the database tables that comprise the planning data repository.

Delete data from these 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 Data Repository scheduled process.

The parameters for the Purge Data Repository scheduled process are in one of these categories:

The Source System and Purge Global Entities parameters
Parameters on the Reference Data tab
Parameters on the Demand Planning Data tab
Parameters on the Supply Planning Data tab

Note: If you're purging Customer dimension data or measure data at the Customer Site level for a demand plan that uses a planning level profile, you must manually run the Aggregated Collected Planning Data and Create Trees for Dimensions scheduled processes after you've purged the data.

The Source System and Purge Global Entities Parameters

Provide values for these parameters to determine which data records for reference data will be purged from the staging tables when you run the Purge Data Repository 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.
Purge Global Entities	You can select Yes if you want to delete data for the entities for which the planning data repository stores only one record for each instance of the global entity so there's no reference to a source system. The default is No.

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.

Purge Global Entities

You can select Yes if you want to delete data for the entities for which the planning data repository stores only one record for each instance of the global entity so there's no reference to a source system. The default is No.

Parameters on the Reference Data Tab

Provide values for these parameters on the Reference Data tab to determine which data records for reference data will be purged from the staging tables when you run the Purge Data Repository scheduled process.

Parameter	Notes
The set of entities categorized as reference entities. The entities you haven't selected yet are included in the Reference Entities list on the Reference Data tab.	You select which reference entities you want data deleted for. The entities you select are included in the Selected Entities list on the Reference Data tab.

Parameters on the Demand Planning Data Tab

Provide values for these parameters on the Demand Planning Data tab to determine which data records for demand planning data will be purged from the staging tables when you run the Purge Data Repository scheduled process.

Parameter	Notes
The set of entities categorized as reference entities. The entries you haven't selected yet are included in the Demand Entities list on the Demand Planning Data tab.	You select which demand entities you want data deleted for. The entities you select are included in the Selected Entities list on the Demand Planning Data tab.
Limit the Days to Purge	You can choose to limit the number of days to purge by selecting one of three choices. For each choice you must also specify the additional details needed for that choice: By date range, followed by a from date and a to date By number of days in the future, followed by a number of most recent days to keep By number of days in the past, followed by either a number of most recent days to keep or a number of oldest days to purge

Parameter

Notes

The set of entities categorized as reference entities. The entries you haven't selected yet are included in the Demand Entities list on the Demand Planning Data tab.

You select which demand entities you want data deleted for. The entities you select are included in the Selected Entities list on the Demand Planning Data tab.

Limit the Days to Purge

You can choose to limit the number of days to purge by selecting one of three choices. For each choice you must also specify the additional details needed for that choice:

By date range, followed by a from date and a to date
By number of days in the future, followed by a number of most recent days to keep
By number of days in the past, followed by either a number of most recent days to keep or a number of oldest days to purge

Parameters on the Supply Planning Data Tab

Provide values for these parameters on the Supply Planning Data tab to determine which data records for supply data will be purged from the staging tables when you run the Purge Data Repository scheduled process.

Parameter	Notes
The set of entities categorized as supply entities. The entities you haven't selected yet are included in the Supply Entities list on the Supply Planning Data tab.	You select which supply entities you want data deleted for. The entities you select are included in the Selected Entities list on the Supply Planning Data tab.