Purge Item Structure Events Affecting Work Definitions

Item structure events affecting work definitions get populated in the WIS_ITEM_STRUCTURE_EVENTS table. Use the Purge Item Structure Events Affecting Work Definitions scheduled process to purge processed and optionally unprocessed item structure events, with creation date older than 90 days, that affect work definitions.

When to Use

The scheduled process purges processed item structure events by default. Unprocessed item structure events with creation date 90 days old or newer can’t be purged.

Privileges Required

Purge Item Structure Events Impacting Work Definitions (WIS_PURGE_ITEM_STRUCTURE_EVENTS)

Specifications

Review these specifications before setting up this scheduled process:

Specification Description
Job Type Scheduled or as needed.
Frequency As needed.
Time of Day Off peak hours.
Duration Typically, less than a few minutes after the initial purge. The initial purge can take a few minutes depending on the data volume.
Compatibility There should be only one instance of the job running at any time for a given organization.

Parameters

Use these parameters when running the scheduled process:

Parameter Optional or Required Description Parameter Value Special Combinations Required Notes
Organization Required Manufacturing plant in which item structure events were generated for the work definitions. Organization None N/A
Purge Unprocessed Structure Events Older than 90 Days Required Option to purge unprocessed structure events with creation date older than 90 days. Unprocessed structure events with creation date 90 days old or newer can’t be purged. Yes or No. The default is No. None N/A

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area.
  • When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, and Release Process, as provided by the Scheduled Processes work area.