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

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Workflow Cartridge - Version 2.6 to 2.6.3.5 [Release 2]
Oracle Workflow Cartridge - Version 11.5.10.2 to 12.2.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
FNDWFPR - Oracle Workflow Purge Obsolete Data
Checked for relevance on 24-MAR-2012


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms