Search Results xdp_dq_configuration_pk

Overview

The XDP_DQ_CONFIGURATION table is a Provisioning module configuration object within the Oracle E-Business Suite, owned by the XDP schema. It stores the setup metadata that governs how application queues are registered, dispatched, and processed by the concurrent DQ (dequeue) processor infrastructure. Each row defines a named internal queue, its Advanced Queuing (AQ) backing store, the associated processing routine, retry policy, and security grouping. In EBS 12.1.1 and 12.2.2 the table is the authoritative source used at runtime to resolve queue definitions referenced by the provisioning engine.

From a Data Vault modeling perspective, the mined foreign-key structure classifies XDP_DQ_CONFIGURATION as hub-leaning. This is a heuristic suggestion: the table carries a stable business key on the internal queue name and serves primarily as a unique, non-duplicating registry of queue identities, with descriptive attributes carried alongside in candidate satellite form.

Key Information Stored

Nineteen columns are documented for the 12.2.2 physical schema. The most significant are:

• INTERNAL_Q_NAME — the internal queue identifier and the surrogate primary key (XDP_DQ_CONFIGURATION_PK). Also the leading column of the business-key unique index XDP_DQ_CONFIGURATION_U1 (INTERNAL_Q_NAME, ZD_EDITION_NAME).
• Q_ALIAS — the human-readable alias for the queue; forms the second unique key (XDP_DQ_CONFIGURATION_UK1).
• QUEUE_TABLE_NAME — the underlying AQ queue table that physically holds the messages.
• PAYLOAD_TYPE — the data type of the message payload enqueued on the queue.
• NUM_OF_DQER — the number of dequeue workers (DQERs) allocated to process the queue.
• DQ_PROC_NAME — the PL/SQL procedure invoked to process dequeued messages.
• MODULE_NAME — the owning application module or product context.
• IS_AQ_FLAG — indicates whether the queue is backed by Oracle Advanced Queuing.
• STATE — the active/inactive status controlling whether the queue is processed.
• DISPLAY_SEQUENCE — ordering value used when presenting queues in the UI.
• EXCEPTION_QUEUE_NAME — the target queue for messages that fail processing.
• MAX_RETRIES — the retry threshold before a message is diverted to the exception queue.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security partitioning.
• ZD_EDITION_NAME — the editioning column introduced in 12.2 Online Patching, part of the U1 business key.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO audit columns.

Common Use Cases and Queries

Typical scenarios include auditing which queues are enabled, verifying worker allocation, and diagnosing stalled provisioning message flow through the exception queue. A representative query lists active queues with their processor and retry settings:

• SELECT q_alias, queue_table_name, dq_proc_name, num_of_dqer, state FROM xdp.xdp_dq_configuration WHERE state = 'Y' ORDER BY display_sequence;
• Determining the exception routing for a given queue: SELECT internal_q_name, exception_queue_name, max_retries FROM xdp.xdp_dq_configuration;
• Joining to the translated table for display names — XDP_DQ_CONFIGURATION c JOIN XDP_DQ_CONFIGURATION_TL t ON c.internal_q_name = t.internal_q_name.
• Filtering by security group to isolate a specific operating unit's queue configuration.

Related Objects

The following objects reference or are referenced by XDP_DQ_CONFIGURATION through documented keys:

• XDP_DQ_CONFIGURATION_TL — the translation (multi-language) table; joined on INTERNAL_Q_NAME. It carries the foreign key XDP_DQ_CONFIGURATION_TL.INTERNAL_Q_NAME back to this table.
• FND_SECURITY_GROUPS — referenced via the SECURITY_GROUP_ID foreign key.
• XDP_DQ_CONFIGURATION_PK / _UK1 / _U1 — the primary and unique indexes enforcing queue identity.
• Oracle Advanced Queuing dictionary views (e.g., ALL_QUEUE_TABLES, USER_QUEUES) — commonly joined against QUEUE_TABLE_NAME to correlate configuration with physical queue state.
• FND_CONCURRENT_PROGRAMS / concurrent manager infrastructure — consumes DQ_PROC_NAME when scheduling processors.