How To Tell If A Workflow Item Type Will Be Purged Depending On Persistence Type? (Doc ID 847950.1)

Last updated on AUGUST 07, 2024

Applies to:

Goal

To check the Persistence type of a Workflow Item Type.  This is particularly important before submitting the FNDWFPR - Oracle Workflow Purge Obsolete Data concurrent program to purge workflow runtime data.

Persistence Type

When one defines an item type, one must also specify its persistence type. The
persistence type controls how long a status audit trail is maintained for each instance of the item type. If one sets the Persistence to Permanent, the runtime status information is maintained indefinitely until one specifically purges the information by calling the procedure WF_PURGE.TotalPerm().
If one sets an item type's Persistence to Temporary, one must also specify the number of days of persistence ('n'). The status audit trail for each instance of a Temporary item type is maintained for at least 'n' days of persistence after its completion date. After the 'n' days of persistence, one can then use any of the WF_PURGE APIs to purge the item type's runtime status information.

One can also use the Purge Obsolete Workflow Runtime Data concurrent program to purge obsolete item type runtime status information. The executable name for this concurrent program is "Oracle Workflow Purge Obsolete Data" and its short name is FNDWFPR.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.