Search Results xnp_in_msg_q

Overview

The APPS.XDP_FQUEUE_TOOLS package body is a utility package within the Oracle E-Business Suite Advanced Planning and Scheduling / supply chain execution components tied to the XDP (Order Management back-end queue infrastructure) and XNP (XML/Native messaging queue) schemas. Its principal business purpose is to provide programmatic introspection of the Oracle Advanced Queueing (AQ) tables that underlie the order fulfillment, work item, workflow channel, and inbound/outbound messaging pipelines. Administrators and concurrent programs use these utilities to determine how many unconsumed entries exist in a given queue and to identify the most recent enqueue timestamp, commonly surfaced in monitoring and diagnostic reports as well as in operational dashboards that display queue depth and lag.

Within Oracle EBS 12.1.1 and 12.2.2, queue latency and backlog are critical operational metrics: a stalled order processor or adapter queue can block sales order release, fulfillment, and integration with external trading partners. This package provides the low-level queries that expose those metrics without requiring the caller to know which underlying *_QTAB or queue table holds the data.

Key Procedures and Functions

• NO_ENTRIES — Returns the number of rows currently present in the queue table identified by the supplied queue name (queued_id). It branches on the queue identifier and performs a count(1) against the matching queue table, returning the entry count as a NUMBER. Typical uses include queue-depth monitoring and threshold-based alerting.
• MAX_ENTRY_DATE — Returns the latest enqueue timestamp (the maximum ENQ_TIME) for the specified queue. The local variable is named entry_date, which is why the entry_date search term maps to this function. It is the canonical way to determine the age of the newest item waiting in a queue, and therefore whether a queue is actively receiving traffic.
• PROCESSORS_RUNNING — Reports on the status of queue processors, used to verify that the background consumers responsible for dequeuing order, work item, and messaging records are active. Operators consult this during incident triage to distinguish an idle queue from a failed consumer.
• DO_COMMIT — Performs a transaction commit on behalf of calling code, allowing queue inspection routines to release transactional context cleanly after read operations or helper updates.

Tables Accessed

All documented tables are reached through APPS synonyms:

• XDP_PENDING_ORDER_QTAB — pending sales order queue.
• XDP_ORDER_PROCESSOR_QTAB — order processor queue.
• XDP_WORKITEM_QTAB — work item queue.
• XDP_FA_QTAB — fulfillment/adapter queue.
• XDP_ADAPTER_JOB_QUEUE and XDP_DQER_REGISTRATION — adapter job scheduling and dequeuer registration.
• XDP_WF_CHANNEL_QTAB — workflow channel queue.
• XNP_IN_MSG_QTAB, XNP_OUT_MSG_QTAB, XNP_IN_EVT_QTAB, XNP_IN_TMR_QTAB — inbound/outbound messages, inbound events, and inbound timer queues.

Usage Notes

XDP_FQUEUE_TOOLS is classified as OTHER (no formal public API). It is not directly invoked by Oracle Forms; rather it is called by concurrent programs, queue monitor utilities, and custom diagnostics that display queue depth and last-entry dates. Because it is referenced by zero other packages, callers rely on the APPS synonym directly. Typical invocation sites include order management queue-monitoring reports, DBA troubleshooting scripts, and workflow/XML gateway diagnostics where operators need a count of entries and the newest entry_date. Custom code should be aware that the function branches only on the enumerated queue identifiers; an unrecognized queue name returns a null date or zero count, so callers must validate inputs and always reference the package via its APPS synonym to preserve the same semantics across 12.1.1 and 12.2.2.