Search Results max_entry_date

Overview

XDP_FQUEUE_TOOLS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as an "OTHER" API. Its name and referenced objects indicate that it serves as a utility layer for the flow queue infrastructure used by Oracle's outbound messaging and workflow integration components — most notably the XDP (Outbound Messaging / XML Gateway) and XNP (Notification / Workflow event) schemas. The package provides helper logic for inspecting and manipulating the transient queue tables that stage outbound messages, orders, work items, timers, and channel data before they are dispatched by asynchronous processors. It is a low-level, internal support package rather than a public application programming interface, and it is not intended to be called by customer code. In Oracle EBS 12.1.1 and 12.2.2 the package is delivered in VALID status and depends only on SYS.STANDARD, confirming it is a self-contained PL/SQL unit with no external schema dependencies.

Key Procedures and Functions

The ETRM metadata documents four callable units within XDP_FQUEUE_TOOLS. Their purposes, consistent with the naming conventions of the queue subsystem, are as follows:

• NO_ENTRIES — A function that evaluates whether a given flow queue contains no pending entries, returning a boolean-style indicator. It is used by processors to short-circuit processing when a queue is empty.
• MAX_ENTRY_DATE — A function returning the most recent entry date (timestamp) present in a queue, allowing callers to determine queue latency or the freshness of the newest staged item.
• PROCESSORS_RUNNING — A function that reports whether any queue processor jobs are currently active, enabling safe coordination of concurrent workers and preventing duplicate dispatch.
• DO_COMMIT — A procedure that performs an explicit commit of the current transaction, used by queue processing logic to persist queue updates at safe boundaries before the next batch of work is dequeued.

No parameter lists are exposed in the ETRM documentation; callers should reference the shipped package specification in the database for exact signatures.

Tables Accessed

Through APPS synonyms, XDP_FQUEUE_TOOLS reads and writes the following queue staging tables:

• XDP_ADAPTER_JOB_QUEUE, XDP_DQER_REGISTRATION, XDP_FA_QTAB, XDP_ORDER_PROCESSOR_QTAB, XDP_PENDING_ORDER_QTAB, XDP_WF_CHANNEL_QTAB, XDP_WORKITEM_QTAB — the XDP outbound messaging, adapter, order processor, and workflow channel queues.
• XNP_IN_EVT_QTAB, XNP_IN_MSG_QTAB, XNP_IN_TMR_QTAB, XNP_OUT_MSG_QTAB — the XNP inbound event, inbound message, inbound timer, and outbound message queues.

These tables hold transient work items awaiting dequeue by concurrent processors. The package inspects them for emptiness, timestamps, and processor state, and commits queued changes.

Usage Notes

XDP_FQUEUE_TOOLS is an internal component invoked by the EBS outbound messaging and notification queue processors, not by standard forms or user-facing concurrent programs. In 12.1.1 and 12.2.2 it is referenced by zero other packages in the ETRM dependency graph, indicating it is called only from the queue processing logic itself. Because its functions query processor state and queue contents in real time, it is typically executed within the same transaction as the dequeue loop. Custom code should not invoke this package directly; any diagnostic need for queue depth or processor status should be satisfied through supported monitoring interfaces or read-only SQL against the underlying QTAB tables.