What is the significance of threshold value in Oracle Workflows?

Oracle Apps Interview QuestionsCategory: WorkflowsWhat is the significance of threshold value in Oracle Workflows?
Questions Master asked 10 years ago

How does it impact the workflow process?

1 Answers
Shailender Thallam Staff answered 10 years ago

Threshold value pertains to cost of activities of workflow process. The Workflow Engine threshold is set to 50 as a default. Activities with a cost higher than 50 are deferred for background engines to process.

The engine threshold is set in an externalized constant called THRESHOLD. Include the following line in your PL/SQL procedure to set the WF Engine threshold to a different value:

WF_ENGINE.THRESHOLD := n;

In some cases, you may want to force the engine to defer an activity although the activity’s cost is less than fifty. You can do this by altering the Workflow Engine threshold in the PL/SQL stored procedure for a function activity.