procedure Background (itemtype in varchar2 default '', minthreshold in number default null, maxthreshold in number default null, process_deferred in boolean default TRUE, process_timeout in boolean default TRUE, process_stuck in boolean default FALSE);
Runs a background engine for processing deferred activities, timed out activities, and stuck processes using the parameters specified. The background engine executes all activities that satisfy the given arguments at the time that the background engine is invoked. This procedure does not remain running long term, so you must restart this procedure periodically. 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. You can run a script called wfbkgchk.sql to get a list of the activities waiting to be processed by the next background engine run. See: Wfbkgchk.sql.
You must not call Background() from within application code. If you want to call this procedure directly, you can run it from SQL*Plus. Otherwise, you can use the concurrent program version of this procedure and take advantage of the concurrent manager to schedule the background engine to run periodically. You can also use the Workflow Manager component of Oracle Applications Manager to submit the background engine concurrent program. See: To Schedule Background Engines.
| itemtype | A valid item type. If the item type is null the background engine will run for all item types. |
| minthreshold | Optional minimum cost threshold for an activity that this background engine processes, in hundredths of a second. There is no minimum cost threshold if this parameter is null. |
| maxthreshold | Optional maximum cost threshold for an activity that this background engine processes in hundredths of a second. There is no maximum cost threshold if this parameter is null. |
| process_deferred | Specify TRUE or FALSE to indicate whether to run deferred processes. Defaults to TRUE. |
| process_timeout | Specify TRUE or FALSE to indicate whether to run timed out processes. Defaults to TRUE. |
| process_stuck | Specify TRUE or FALSE to indicate whether to run stuck processes. Defaults to FALSE. |