My Oracle Support Banner

Shipping Workflow Persistence_Days is Set For 90 Days - Why And How To Change? (Doc ID 1981263.1)

Last updated on OCTOBER 18, 2023

Applies to:

Oracle Shipping Execution - Version 12.1.1 and later
Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.


Workflow analyzer shows there are 3 Shipping workflows with a setting of persistence_days = 90.
All other workflow have persistence_days = 0.
Purging of workflow is 30 days after workflow has completed.

Using an example, if the shipping workflow  persistence_days were set to 0 (in line with all other workflows), it would remove 25,000 workflow records from wf_items.
Due to it having persistence_days = 90, this is not happening.

Query used to retrieve the values:


1) All other workflows persistence_days is set to 0.  Is this the intended, default setting for Shipping workflows to be set to persistence_days = 90?
2) Is there a process/report/functional reason that relies on keeping these workflows open?
3) How would this setting be changed?


To view full details, sign in with your My Oracle Support account.

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

In this Document

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