Purge Data Repository

When to Use

By using this scheduled process, you can delete data from the collection tables to free up space and improve performance. Run the scheduled process in the Scheduled Processes work area.

Privileges Required

Perform Order Orchestration and Planning Data Collection (MSP_PERFORM_ORDER_ORCHESTRATION_AND_PLANNING_DATA_COLLECTION_PRIV)

Specifications

Review these specifications before setting up this scheduled process:

Specification	Description
Job Type	Can be run at any time or as a scheduled job.
Frequency	Can be run on an as-needed basis.
Time of Day	It's recommended to run this scheduled process after hours when there is no user on the system.
Duration	Depends on the number of entities you select and their volume in the source system.
Compatibility	It's incompatible with the Collection Run Job Set scheduled process.

Parameters

Parameter	Optional or Required	Description	Parameter Value	Special Combinations Required	Notes
Source System	Required	Identifies the source system of the planning data repository. You must select a source system.	For data collected from the Oracle Fusion source system, select the applicable Oracle Fusion source system code. For data collected from an external system, select the applicable external source system code.	None	NA
Purge Global Entities	Required	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. Doing so removes any reference to a source system.	Yes No (default)	None	In Supply Chain Planning, these entities are classified as global entities: Order Orchestration Reference Objects Units of Measure and UOM Conversions Demand Classes Currency and Currency Conversion Class Shipping Methods (Carrier, Mode of Transport, Service Level) Customer and Customer Site Suppliers and Supplier Sites Regions and Zones Approved Supplier List Supplier Capacity Planners
Reference Data	Optional You must select at least one entity from the list of Reference Data, Demand Planning Data, or Supply Planning Data entities.	The set of entities categorized as reference entities.	Examples of Reference Data are Calendars and Currencies.	None	Select the reference entities for which you want the data deleted. The entities you select are included in the Selected Entities list on the Reference Data tab.
Demand Planning Data	Optional You must select at least one entity from the list of Reference Data, Demand Planning Data, or Supply Planning Data entities.	The set of entities categorized as demand entities.	Examples of Demand Entities are Bookings Forecast, Shipments Forecast, and Sales Forecast.	None	Select the demand entities for which you want the data deleted. The entities you select are included in the Selected Entities list on the Demand Planning Data tab.
Limit the Days to Purge	Optional	Select one of three options to limit the number of days to purge. For each option, you also must specify any additional details that are required.	The three options are: 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	None
Supply Planning Data	Optional You must select at least one entity from the list of Reference Data, Demand Planning Data, or Supply Planning Data entities.	The set of entities categorized as supply entities.	Examples of Supply Entities are On Hand, Sales Orders, and Resource Availability.	None	Select the supply entities for which you want the data deleted. The entities you select are included in the Selected Entities list on the Supply Planning Data tab.

Troubleshooting Information

This process is nonrecoverable. All data in Data Repository will be lost.
You should run Targeted Collection again to collect data from the source instance.
Rerun your plans.
It's recommended not to run any plan or collection while this process is running.
Review input parameters of the Purge Data Repository job:
- To delete all data from Planning System, select all instances and then select the required business objects.
- To delete from a specific Planning Source System, select a specific instance and specific business objects.
Note: The first option runs faster than the second one.
You can view the status of the Purge Data Repository process in the Scheduled Processes work area.
The validation errors and warning messages that prevented the data-purge operation from completing display in the error log.
Interactive warning validations are not performed.
After you submit the scheduled process, you can perform any of these tasks in the Scheduled Processes work area:
- Resubmit it
- Put it on hold
- Cancel the process
- Release the process
If the job fails:
- Review the error messages in the log file.
- If the reason for the failure isn’t clear from the logs, review the diagnostic logs and contact product support for more help.