Search Results exception_queue_name

Overview

The XDP_DQ_CONFIGURATION_VL view is a seeded, valid database object owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments. It belongs to the XDP – Provisioning product family and is described in the electronic technical reference manual as a "view for queue configuration tables." The view functions primarily as a reporting and integration surface for the configuration of the dequeuing (DQ) infrastructure used by the Provisioning module, presenting the queue definitions maintained in the base configuration and translation tables in a single, denormalized result set.

The suffix _VL denotes a "view with language" object, a standard EBS pattern that joins a base (non-translated) table to its corresponding translation table and restricts results to the session language via USERENV('LANG'). Consumers of this view therefore see the internal, language-independent configuration attributes alongside the display-oriented attributes appropriate to the current runtime language. Because the object is a view rather than a table, it is read-only for practical purposes; configuration changes must be applied to the underlying base tables.

Underlying Base Objects

The view is defined over two documented base objects, both exposed to APPS through synonyms:

• XDP_DQ_CONFIGURATION — the primary configuration table holding the operational queue attributes for each internal queue name.
• XDP_DQ_CONFIGURATION_TL — the translation table holding the language-specific display name and description for each queue.

The join condition is B.INTERNAL_Q_NAME = T.INTERNAL_Q_NAME combined with T.LANGUAGE = USERENV('LANG'), and the view exposes the base table's ROWID as ROW_ID. This structure is consistent with standard EBS MLS (Multi-Lingual Support) conventions, ensuring one row per configured queue in the active language.

Key Columns

The view exposes the following documented columns, each of which carries specific meaning for queue configuration:

• ROW_ID — the base table ROWID, useful for direct row identification.
• INTERNAL_Q_NAME — the internal identifier for the queue; the primary key joining both base tables.
• Q_ALIAS — the alias by which the queue is referenced.
• EXCEPTION_QUEUE_NAME — the name of the exception queue associated with the configuration, the attribute most frequently queried by implementers troubleshooting failed messages.
• QUEUE_TABLE_NAME and PAYLOAD_TYPE — the Advanced Queuing backing table and payload type.
• IS_AQ_FLAG — indicates whether the queue is an Advanced Queue.
• NUM_OF_DQER, DQ_PROC_NAME, MODULE_NAME — dequeue worker count, processing procedure, and owning module.
• MAX_RETRIES — retry threshold for dequeuing.
• STATE, DISPLAY_SEQUENCE — administrative state and presentation ordering.
• DISPLAY_NAME, DESCRIPTION — language-specific labels sourced from the TL table.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usages include reconciling queue configuration, locating the exception queue configured for a given internal queue, and embedding the view in custom concurrent programs or OAF pages where translated queue names must be shown.

To locate the exception queue for a specific configuration:

• SELECT internal_q_name, exception_queue_name, max_retries FROM xdp_dq_configuration_vl WHERE state = 'ACTIVE';

To review all configured queues with their translated display names:

• SELECT internal_q_name, display_name, q_alias, queue_table_name FROM xdp_dq_configuration_vl ORDER BY display_sequence;

To identify current-run language behaviour during troubleshooting, join considerations are unnecessary because the view already filters on USERENV('LANG'); simply execute the query under the target session language.