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.

Goal

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:


Questions:

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?
 

Solution

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
Goal
Solution
References


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