Purge Collaboration Interface Tables

Use the Purge Collaboration Interface Tables scheduled process to purge all temporary supplier commit data from the collaboration interface tables. After you publish the plan, receive supplier commits, and the collaboration cycle ends, this temporary commit data is no longer needed and can be purged.

When to Use

We recommend that you schedule this process to run whenever a new collaboration cycle begins, before the supply plan is published.

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 run regularly using a schedule that corresponds with the end of your collaboration cycle. It also can run at any time, if required.
Frequency	Once per collaboration cycle, or less frequently.
Time of Day	Can be run at any time.
Duration	Typically less than five minutes, but may vary based on the number of interface records that were created after you last ran the scheduled process.
Compatibility	Only one instance of the job should be running at any time. There’s no current functional need to run multiple instances of this process simultaneously.

Parameters

Parameter	Optional or Required	Description	Parameter Value	Special Combinations Required	Notes
Plan	Required	The name of the associated plan for which you want to purge interface records.	Plan Name	None	NA

Troubleshooting Information

None.