Search Results xdp_adapter_job_queue_u2

Overview

XDP.XDP_ADAPTER_JOB_QUEUE is an internal queue table owned by the XDP schema within Oracle E-Business Suite. It exists to serialize access to adapter channels during provisioning operations. When the Fulfillment Action (FA) workflow attempts to execute a fulfillment procedure (FP) for a fulfillment element (FE), it must first allocate a free adapter for the target FE. If all adapters are busy, the workflow registers itself in this queue table and suspends. When an adapter becomes available, the queued workflow is notified and the adapter channel name is passed back to it as it resumes normal processing.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT_FREE of 10. Two normal unique indexes, XDP_ADAPTER_JOB_QUEUE_U1 on JOB_ID and XDP_ADAPTER_JOB_QUEUE_U2 on (WF_ITEM_TYPE, WF_ITEM_KEY), reside in APPS_TS_TX_IDX. The primary key is XDP_ADAPTER_JOB_QUEUE_PK, defined on JOB_ID. The documented physical schema comprises 18 columns. From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone — that is, the object functions as an independent queue/registry rather than participating in a classic hub, link, or satellite pattern, and any Data Vault treatment should be regarded as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The surrogate primary key is JOB_ID, a unique numeric identifier for a given NEM job, reinforced by the unique index XDP_ADAPTER_JOB_QUEUE_U1. The second unique index, XDP_ADAPTER_JOB_QUEUE_U2 on the composite of WF_ITEM_TYPE and WF_ITEM_KEY, identifies the workflow instance awaiting an adapter, making this pair the principal business-key candidate; the uniqueness constraint ensures a workflow is not registered twice.

• JOB_ID — surrogate primary key; unique numeric identifier of the job entry.
• FE_ID — reference to the fulfillment element (network element) for which provisioning is requested.
• QUEUED_ON — timestamp recorded when the job is placed in the queue.
• WF_ITEM_TYPE and WF_ITEM_KEY — the Oracle Workflow item type and item key of the suspended process; together they form the U2 business key.
• WF_ACTIVITY_NAME — the workflow activity name associated with the queued job.
• CHANNEL_USAGE_CODE — internal code describing the intended use of the adapter channel.
• ORDER_ID — the order identifier to which the adapter job belongs.
• WORKITEM_INSTANCE_ID — the work item instance that owns the adapter job.
• FA_INSTANCE_ID — the Fulfillment Action instance identifier for the adapter job.
• ERROR_REF_ID — error message identifier for the adapter request, populated when processing fails.
• SECURITY_GROUP_ID — the Multi-Org / security group that owns the row.
• Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• SYSTEM_HOLD — internal hold indicator for the queued entry.

Common Use Cases and Queries

The primary operational use case is monitoring queue depth and identifying stale or suspended fulfillment workflows awaiting adapter availability. A typical query lists current queue contents ordered by arrival time:

• SELECT job_id, fe_id, wf_item_type, wf_item_key, wf_activity_name, queued_on FROM xdp.xdp_adapter_job_queue ORDER BY queued_on;
• Correlating a specific workflow to its queued adapter job via the business key: WHERE wf_item_type = :p_type AND wf_item_key = :p_key.
• Aggregating queue load by fulfillment element or by order: SELECT fe_id, COUNT(*) FROM xdp.xdp_adapter_job_queue GROUP BY fe_id;
• Detecting failures by filtering on error_ref_id IS NOT NULL, and reviewing rows flagged by system_hold.

Because the table is internal, direct DML is not supported; it should be treated as read-only for diagnostic and reporting purposes, with workflow resumption driven by the fulfillment and adapter notification processes rather than manual intervention.

Related Objects

The table participates in several documented foreign-key relationships that anchor it to the fulfillment and provisioning data model:

• XDP.XDP_FES — joined via FE_ID to the referenced fulfillment element.
• XDP.XDP_FULFILL_WORKLIST — joined via WORKITEM_INSTANCE_ID to the work item instance.
• XDP.XDP_FA_RUNTIME_LIST — joined via FA_INSTANCE_ID to the Fulfillment Action runtime instance.
• XDP.XDP_DQ_EXCEPTIONS — joined via ERROR_REF_ID for error/exception detail.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID for Multi-Org security context.
• Oracle Workflow (WF_ITEM_TYPE / WF_ITEM_KEY) — the suspended process correlated through the U2 unique key.