Purge Staging Tables

Use the Purge Staging Tables scheduled process to delete data from the Supply Chain Planning staging tables that are used during collections processes.

When to Use

By using this scheduled process, you can delete data from the staging 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 staging tables. You must select a source system.	For data collected from the Oracle Fusion source system, select the applicable Oracle source system code. For data collected from an external system, select the applicable external source system code.	None	NA
Record Type	Required	Select All to purge all records that meet the values of the other parameters, regardless of their record type. Record types other than All are the statuses of records in the staging tables, indicating the next stage of the collections process. The next stage of the collections process is the import of records from 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 in the staging tables that were unsuccessfully imported into the planning data repository. New: Records that were collected into the staging tables, but import into the planning data repository hasn't been attempted. Retry: Records in the staging tables for which import into the planning data repository is being attempted again. Warning: Records in the staging tables for which a warning occurred when the record was imported into the planning data repository.	None	NA
Collection Cycle ID	Optional	Indicates the refresh number of the collection job.	Refresh Number	None	You can get the refresh-number value from the log file of that particular collection job.
Collected From Date and Collected To Date	Optional	You can provide these dates to purge data within a specific time frame.	Collected Dates	None	NA
The set of specific entities for which data is collected and deletion of the data from the staging tables is supported.	Optional	Each entity is a parameter for the scheduled process. Select No for any parameter if you don't want to purge the data for that entity	Yes (default) No	None	NA

Troubleshooting Information

• Analyze the error records in the staging tables before running this scheduled process.
• The scheduled process runs faster when you set the Source System and Record Type parameters to All.
• You can view the status of the Purge Staging Tables process in the Scheduled Processes work area.
• The validation errors and warning messages that prevented the data purge operation 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.