Oracle Apps – Workflow Background Process Program

Oracle Apps – Workflow Background Process Program

Workflow Background Program:

Workflow background program is a concurrent program which is used to run for processing the deferred activities, notifications activities, wait activities, timeout activities & stuck processes using the specified input parameters. Based on the parameters the background engine executes all the activities & stuck processes. Any activities that are newly deferred or timed out or processes that become stuck after the current background engine starts are processed by the next background engine that is invoked by the concurrent program.

Workflow Background Process runs with the help of Workflow Background Engine which is PL/SQL Procedure which runs this concurrent program with specified parameters.

Workflow background process concurrent is available in both 11i & R12.

Navigation:

System Administrator Responsibility > View Requests > Submit a New Request

Parameters:

Item Type:

Specify an item type to restrict this engine to activities associated with that item type. If item type is not specified, the engine processes any activity regardless of its item type.

Minimum Threshold:

Specify the minimum cost that an activity must have for this background engine to execute it, in hundredths of a second.

Maximum Threshold:

Specify the maximum cost that an activity can have for this background engine to execute it, in hundredths of a second. By using Minimum Threshold and Maximum Threshold can create multiple background engines to handle very specific types of activities. The default values for these arguments are null so that the background engine runs activities regardless of cost.

Process Deferred:

Specify whether this background engine checks for deferred activities. Setting this parameter to Yes allows the engine to check for deferred activities.

Process Timeout:

Specify whether this background engine checks for activities that have timed out. Setting this parameter to Yes allows the engine to check for timed out activities.

Process Stuck:

Specify whether this background engine checks for stuck processes. Setting this parameter to Yes allows the engine to check for stuck processes.