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.