Search Results wf_queues




Overview
Explore in AI Chat

Overview

WF_QUEUES is a configuration table residing in the APPLSYS schema within the Oracle E-Business Suite FND — Application Object Library product. It stores the definition of Workflow Generic Queues, which serve as the inbound and outbound communication channels used by the Oracle Workflow engine to dispatch and receive notification and event messages across supported transport protocols. Each row represents a discrete queue endpoint identified by a protocol type and a directional indicator.

Under the heuristic Data Vault classification derived from its foreign key structure, WF_QUEUES is modeled as a standalone object, indicating it functions neither as a conventional hub nor as a dependent satellite in the mined relationship graph. This classification suggests the table is best treated as a reference or lookup construct with limited dependency depth, rather than as a central integration point in the workflow data model.

Key Information Stored

The table contains six documented columns. Its composite primary key, WF_QUEUES_PK, is composed of PROTOCOL and INBOUND_OUTBOUND. A redundant unique index, WF_QUEUES_U1, covers the same two columns, confirming this pair as the natural business key candidate of the table.

  • PROTOCOL — Identifies the transport protocol associated with the queue, forming the first component of the composite primary key.
  • INBOUND_OUTBOUND — Indicates the message direction handled by the queue, forming the second component of the primary key and distinguishing inbound from outbound channels.
  • DESCRIPTION — Human-readable text describing the purpose or characteristics of the queue entry.
  • QUEUE_COUNT — A numeric counter, typically reflecting the volume or count of items associated with the queue.
  • DISABLE_FLAG — Controls whether the queue definition is active or deactivated, allowing administrators to suppress processing without deleting the configuration.
  • SECURITY_GROUP_ID — A foreign key referencing FND_SECURITY_GROUPS, scoping the queue definition to a specific security group or organization context.

No surrogate system-generated identifier is documented; the composite key of PROTOCOL and INBOUND_OUTBOUND serves directly as the row identifier.

Common Use Cases and Queries

Administrators and developers consult WF_QUEUES when diagnosing workflow notification delivery, verifying that inbound and outbound channels are enabled for a given protocol, or auditing the security group assignment of queue definitions. A common diagnostic query lists all active queues with their descriptions:

SELECT protocol, inbound_outbound, description, queue_count FROM applsys.wf_queues WHERE disable_flag IS NULL OR disable_flag = 'N';

A second pattern isolates disabled queues that may be causing stalled notification delivery:

SELECT protocol, inbound_outbound, description FROM applsys.wf_queues WHERE disable_flag = 'Y';

Reporting scenarios include auditing queue volume through QUEUE_COUNT and verifying that every protocol direction combination required by an integration is properly registered. Because the table is small and highly static, it is well suited to cache-based lookups during workflow runtime.

Related Objects

The documented foreign key relationship ties WF_QUEUES to the security group model, while its key columns participate in broader workflow messaging.

  • FND_SECURITY_GROUPS — Referenced by WF_QUEUES.SECURITY_GROUP_ID, scoping each queue to a security group.
  • WF_QUEUES_PK — The composite primary key constraint over PROTOCOL and INBOUND_OUTBOUND.
  • WF_QUEUES_U1 — The unique index duplicating the business key candidates.
  • WF_NOTIFICATIONS — Holds notification records dispatched through the channels defined here.
  • WF_MESSAGES — Message definitions transported across the queue endpoints.
  • WF_AGENTS — Workflow agents that reference queue-based delivery targets.
  • WF_DEFERRED — The deferred processing queue that consumes workflow events.

These references position WF_QUEUES as a supporting configuration object within the FND/Oracle Workflow notification infrastructure in both 12.1.1 and 12.2.2.