Search Results inbound_outbound




Overview
Explore in AI Chat

Overview

APPLSYS.WF_QUEUES is the Oracle Workflow Generic Queue Register. It is a reference and control table maintained in the APPLSYS schema and exposed to the APPS schema through the FND design data definition FND.WF_QUEUES. The table registers the communication protocols and directional queue channels used by the Oracle Workflow notification and event subsystems, and it maintains a running count of the queues instantiated for each protocol and direction combination. Status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it resides in the APPS_TS_ARCHIVE tablespace with a PCTFREE of 10.

The table is deliberately narrow. The composite primary key WF_QUEUES_PK is formed from two columns, PROTOCOL and INBOUND_OUTBOUND, and an identical unique index WF_QUEUES_U1 exists on the same pair in APPS_TS_ARCHIVE. Because both PROTOCOL and INBOUND_OUTBOUND participate in the primary key and the unique index, they are the business-key candidates; there is no separate surrogate identifier. From a Data Vault modeling perspective, this table is heuristically classified as a standalone object, meaning it behaves as a simple reference or lookup table rather than as a hub, link, or satellite in a dimensional or Data Vault model. No foreign-key relationships are documented for the table itself; the SECURITY_GROUP_ID column is described in the metadata as reserved for the hosting environment and is shown in the relationship data as referencing FND_SECURITY_GROUPS.

Key Information Stored

  • PROTOCOL (VARCHAR2(10), mandatory) — the protocol identifier; a component of the primary key and unique index.
  • INBOUND_OUTBOUND (VARCHAR2(10), mandatory) — the queue direction specifier distinguishing inbound from outbound channels; the second component of the primary key and unique index.
  • DESCRIPTION (VARCHAR2(240)) — a human-readable description of the queue registration.
  • QUEUE_COUNT (NUMBER) — the number of queues configured for the given protocol and direction combination.
  • DISABLE_FLAG (VARCHAR2) — indicates whether the queue registration is enabled or disabled.
  • SECURITY_GROUP_ID (VARCHAR2(32)) — identifier reserved for the hosting environment; associated with FND_SECURITY_GROUPS.

Only six columns are documented for this object, so the list above is exhaustive rather than a selective subset. The distinction between keys is nonetheless material: unlike many Oracle EBS tables, WF_QUEUES carries no generated surrogate key, and referential integrity is expressed entirely through the composite business key.

Common Use Cases and Queries

The table is most often consulted when diagnosing Workflow mailer, notification, or agent behavior, and when confirming which direction channels are active for a given protocol. A typical retrieval projects the full business key plus its descriptive attributes:

  • Inventory all registered protocol and direction combinations: SELECT PROTOCOL, INBOUND_OUTBOUND, DESCRIPTION, QUEUE_COUNT, DISABLE_FLAG FROM APPLSYS.WF_QUEUES;
  • Find disabled channels before an upgrade or configuration change: filter on DISABLE_FLAG and inspect DESCRIPTION.
  • Reconcile expected versus configured queue volumes by selecting PROTOCOL, INBOUND_OUTBOUND, and QUEUE_COUNT.
  • Look up a specific channel using both key columns: WHERE PROTOCOL = :p AND INBOUND_OUTBOUND = :d.
  • Report by hosting environment for multi-tenant or shared-service configurations using SECURITY_GROUP_ID.

Related Objects

  • APPS.WF_QUEUES — the APPS-schema synonym/view that references APPLSYS.WF_QUEUES and is the object most commonly queried by developers and support staff.
  • APPLSYS.FND_SECURITY_GROUPS — referenced by WF_QUEUES.SECURITY_GROUP_ID; join on the security group identifier when resolving queue rows to a hosting environment.
  • WF_QUEUES_PK — the composite primary key constraint over PROTOCOL and INBOUND_OUTBOUND, defining row uniqueness.
  • WF_QUEUES_U1 — the unique index over PROTOCOL and INBOUND_OUTBOUND in APPS_TS_ARCHIVE, mirroring the primary key.
  • FND.WF_QUEUES — the FND design data definition that governs the object's deployment across product installation.
  • WF_QUEUE_REG / Workflow notification APIs — the Workflow notification subsystem routines that consume the protocol and direction registrations held in this table.

Because the object is classified as standalone, no dependent child tables are documented, and the metadata explicitly records that APPLSYS.WF_QUEUES does not reference any database object.