Search Results get_jms_queue_status

Overview

APPS.WF_DIAGNOSTICS is a diagnostic utility package within the Oracle Workflow (WF) schema of Oracle E-Business Suite. Its principal business function is to expose troubleshooting and introspection information about the workflow runtime environment, particularly concerning notifications, event queues, message extraction, and routing configuration. Rather than driving transactional business logic, the package serves operational and support personnel who must investigate why notifications were not delivered, why events stalled in a queue, or how a particular workflow message was constructed.

The package is classified under the ETRM as API classification OTHER, meaning it is not a documented public integration API intended for customer extension logic. Instead, it is an internal support and diagnostic surface. In Oracle EBS 12.1.1 and 12.2.2, WF_DIAGNOSTICS is recorded with a VALID status in the APPS schema. It is referenced by no other packages, according to the documented metadata, and depends only on SYS.STANDARD and itself. This shallow dependency footprint reflects its nature as a leaf-level diagnostic module invoked directly by administrative tooling.

Key Procedures and Functions

The ETRM documents 39 procedures and functions in this package. They fall into recognizable thematic groups:

• Notification introspection: GET_NTF_ITEM_INFO, GET_NTF_ROLE_INFO, GET_NTF_ROLE_USERS, GET_NTF_ATTRS, GET_NTF_MSG_ATTRS, GET_NTF_MORE_INFO, GET_NTF_TEMPLATES, GET_NTF_MESSAGE, GET_NTF_MSG_FROM_IN, GET_NTF_MSG_FROM_OUT, GET_USER_COMMENTS, and GET_ROUTING_RULES. These retrieve details about a notification's item, role assignments, attributes, template, message body, and routing, which is essential when validating why a notification reached or failed to reach a recipient.
• Summary variants: GET_SUMMARY_NTF_ROLE_USERS, GET_SUMMARY_NTF_ROLE_INFO, GET_SUMMARY_TEMPLATES, GET_SUMMARY_NTF_MESSAGE, and GET_SUMMARY_MSG_FROM_OUT return condensed forms of the corresponding detail functions, suitable for high-level diagnostics reporting.
• Queue and event status: GET_EVENT_QUEUE_STATUS and GET_JMS_QUEUE_STATUS report on the state of the business event system queues and Java Message Service integration, supporting investigation of backlog and stuck-event conditions.
• Grouping helpers: GET_GROUP_NTFS supports grouping of notifications for aggregate analysis across a workflow or role.

No parameter lists are documented in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

WF_DIAGNOSTICS reads from a defined set of APPS synonyms that mirror the workflow and foundation data model:

• Workflow runtime tables: WF_AGENTS, WF_AGENT_T, WF_ITEM_ACTIVITY_STATUSES, and WF_COMMENTS provide agent definitions, activity status history, and user comments attached to workflow items.
• Event system tables: WF_EVENTS, WF_EVENT_T, and WF_EVENT_SUBSCRIPTIONS support event queue diagnosis.
• Notification structure: WF_MAILER_TAGS and WF_LOOKUPS_TL supply mailer tag definitions and lookup translations.
• Service foundation tables: FND_SVC_COMPONENTS, FND_SVC_COMP_PARAMS_B, FND_SVC_COMP_PARAM_VALS, FND_SVC_COMP_REQUESTS, plus FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES, allow the package to correlate component configuration and profile settings with observed behavior.

Usage Notes

WF_DIAGNOSTICS is typically invoked from Oracle Workflow administrative interfaces and diagnostic concurrent programs, including the Workflow Notification Mailer and Business Event System troubleshooting pages. Support engineers may also call its functions directly from SQL*Plus or from custom diagnostic scripts when investigating a specific notification ID, item key, or event. Because the package depends only on SYS.STANDARD and itself, it is safe to invoke in isolation without triggering workflow engine side effects. It should not be extended or embedded in production business logic, as the ETRM classifies it as an internal, non-public API subject to change without notice.