Last updated on OCTOBER 04, 2016
Applies to:Oracle Workflow Cartridge - Version 2.6 to 220.127.116.11 [Release 2]
Oracle Workflow Cartridge - Version 18.104.22.168 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
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms