1 Answers
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.