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
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.
|
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:
|
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. |