WF Queue Backlog – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Workflow · all Workflow reports

Overview

Number of messages per Workflow Business Event System queue table, correlation id and state, with the age of the oldest message.

A large number of Ready messages with an old Oldest Message shows that the agent listener, notification mailer or Workflow Background Process serving the queue is down or cannot keep up. The correlation id contains the business event or notification message name, and for WF_DEFERRED_TABLE_M the item type processed by the Workflow Background Process.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Exclude Processed, Message Count From, Oldest Message Hours From, Queue Table

Oracle EBS Tables Used

wf_deferred, wf_deferred_table_m, wf_error, wf_java_deferred, wf_java_error, wf_notification_out, wf_notification_in, wf_inbound_table, wf_outbound_table

Report Categories

Enginatics

OKL Termination Quotes, WF Notifications, ONT Transaction Types and Line WF Processes, WF Business Events and Subscriptions

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output WF Queue Backlog 12-Oct-2026 061643.xlsx
Blitz Report™ XML Import WF_Queue_Backlog.xml
SQL Source WF Queue Backlog.sql
Full Report on Enginatics www.enginatics.com/reports/wf-queue-backlog/

Case Study & Technical Analysis: WF Queue Backlog

Executive Summary

WF Queue Backlog counts the messages held in each Oracle Workflow Business Event System queue table, grouped by correlation identifier and message state, and shows the age of the oldest message in each group. It is designed for EBS system administrators and middleware support teams who must confirm that business events, notifications and deferred background work are being processed. A growing backlog of ready messages is the first visible sign that a listener, the notification mailer or the Workflow Background Process has stopped or fallen behind.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. Each queue table is summarized in its own inline branch, grouped by correlation identifier and state.
  2. Each branch returns the queue name, the count of messages, and the minimum and maximum enqueue time.
  3. The nine branches are combined with UNION ALL into one inline result.
  4. The outer query converts the state code to its name and the enqueue times to client time, and computes the age of the oldest message from the current system date.
  5. Rows are ordered by message count in descending order.

Parameters & Filtering

Performance & Optimization

FAQ

Q: What does a high count of Ready messages with an old Oldest Message mean? A: It shows that the agent listener, the notification mailer or the Workflow Background Process serving that queue is down or cannot keep up with the load.

Q: What does the correlation identifier contain? A: It contains the business event or notification message name. For WF_DEFERRED_TABLE_M it is the item type processed by the Workflow Background Process.

Q: How do I see only the backlog that is old? A: Set Oldest Message Hours From to the number of hours you consider acceptable, and only groups whose oldest message is older than that are returned.

© Enginatics GmbH