Purge Release Interface Tables
Use the Purge Release Interface Tables scheduled process to delete data within a specified date range from the Oracle Fusion Cloud Supply Chain Planning release-interface tables that are created during release processes.
When to Use
Use the process to delete data from the release interface tables to free up space and improve performance. Run the scheduled process in the Scheduled Processes work area.
Privileges Required
- Release Planning Recommendations (MSC_RELEASE_PLANNING_RECOMMENDATIONS_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 | No incompatibilities. |
Parameters
| Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
|
From Release Date or To Release Date |
Either a From Date or a To Date is required. Otherwise, the process will not delete data from the release-interface tables. | Provide these dates to purge data within a specific time frame. | Released Dates | None | NA |
Troubleshooting Information
- This process is nonrecoverable. All the release interface tables will be lost.
- Don't run the Release Planning Interface scheduled process when this scheduled process is running.
- You can view the status of the Purge Release Interface 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.