Search Results wf_default

Overview

WF_OAM_METRICS is an Oracle Workflow utility package body owned by APPS and classified under ETRM as OTHER. Its business purpose is to pre-compute and persist operational metrics about workflow runtime state so that the Oracle Workflow Manager user interface and related monitoring pages can render summary counts without executing expensive aggregate queries at display time. The package gathers statistics on in-flight work items (active, deferred, errored, suspended, and completed), on agent activity, and on notification mailer processing, then writes the results into FND_USER_PREFERENCES under the reserved user name -WF_DEFAULT-. Because these preference rows are keyed by module and preference name, they function as a lightweight shared cache consumed by the Workflow Manager graphs and dashboards.

Key Procedures and Functions

• WORKITEMSSTATCONCURRENT — The top-level concurrent entry point, invoked by concurrent program FNDWFWITSTATCC. It orchestrates the population of all work item metric categories, commits the results, and returns an error buffer and error code, raising on failure after writing a WF_CORE context entry.
• POPULATEWORKITEMSGRAPHDATA — Computes the aggregate counts that drive the work item graph, including active, deferred, errored, and suspended totals, and updates the corresponding FND_USER_PREFERENCES rows.
• POPULATEACTIVEWORKITEMSDATA, POPULATEERROREDWORKITEMSDATA, POPULATEDEFERREDWORKITEMSDATA, POPULATESUSPENDEDWORKITEMSDATA, POPULATECOMPLETEDWORKITEMSDATA — Each procedure materializes the detail or summary data set for one work item state category.
• AGENTACTIVITYSTATCONCURRENT — The concurrent driver for agent activity statistics.
• POPULATEAGENTACTIVITYGRAPHDATA — Builds the graph-level aggregates for agent activity.
• POPULATEAGENTACTIVITYDATA — Materializes the underlying agent activity metric rows.
• EXTRACTAGENTNAME — A helper that derives the agent name used when assembling agent statistics.
• NTFMAILERSTATCONCURRENT — The concurrent driver for notification mailer statistics.
• POPULATENTFMAILERGRAPHDATA — Builds the graph-level aggregates for notification mailer processing.

Tables Accessed

The package reads runtime workflow tables through APPS synonyms and writes only to the preference store. WF_ITEM_ACTIVITY_STATUSES supplies the state counts, with queries filtering on ACTIVITY_STATUS values such as ACTIVE, NOTIFIED, WAITING, DEFERRED, ERROR, and SUSPEND. WF_ITEMS and WF_ITEM_TYPES provide item-level and type-level context. WF_AGENTS supports the agent activity metrics, while WF_NOTIFICATIONS underpins the notification mailer metrics. FND_USER_PREFERENCES is the target of the UPDATE statements, where values such as NUM_ACTIVE and NUM_DEFER are stored for user -WF_DEFAULT- under modules including WFManagerWFItemsGraph. DBMS_SQL and PLITBLM are referenced for dynamic SQL and PL/SQL table handling within the implementation.

Usage Notes

WF_OAM_METRICS is not intended for direct invocation by end users or custom applications. It is scheduled and executed exclusively through its companion concurrent programs (notably FNDWFWITSTATCC for work items), which are submitted from the Oracle Workflow Manager administrator responsibility or scheduled via the standard concurrent manager. The preference rows it maintains are read by Workflow Manager pages rather than recalculated interactively. Because the package explicitly COMMITs and raises on error, routine execution should be monitored through concurrent request logs. Custom code has no documented dependency on this package, and it is referenced by zero other packages, confirming its role as a terminal metrics-population utility tied to the Workflow Manager presentation layer.