Results for “actual_provisioning_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XDP_FULFILL_WORKLIST is a core transactional table in the Oracle EBS Provisioning (XDP) module. It identifies the list of services that must be fulfilled for a given order line, acting as the operational worklist that drives fulfillment orchestration across the provisioning engine. Each row corresponds to a discrete fulfillment workitem instance tied to an order and order line, and it carries the status, state, and lifecycle timestamps that the provisioning framework uses to track progression from creation through completion, hold, cancellation, or resume. The table is owned by the XDP schema and appears as VALID in ETRM 12.2.2, which documents a physical schema of 52 columns.

In Data Vault modeling terms, the FK/PK structure around this table suggests a hub classification. Its WORKITEM_INSTANCE_ID is the subject of numerous inbound foreign keys from satellite-like and link-like tables, positioning it as the central business key anchor for the fulfillment domain. This classification is a heuristic derived from the foreign key topology and should be treated as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The table's surrogate primary key is XDP_FULFILL_WORKLIST_PK on WORKITEM_INSTANCE_ID. A documented unique index, XDP_FULFILL_WORKLIST_U1 on (WORKITEM_INSTANCE_ID, WORKITEM_ID), represents the principal business-key candidate. A second unique constraint, XDP_FULFILL_WORKLIST_UK1, also covers WORKITEM_INSTANCE_ID and WORKITEM_ID. The most operationally significant columns include:

• WORKITEM_INSTANCE_ID — primary key and the identifier propagated to nearly all dependent tables.
• WORKITEM_ID — foreign key to XDP_WORKITEMS, identifying the workitem definition.
• ORDER_ID and LINE_ITEM_ID — foreign keys to XDP_ORDER_LINE_ITEMS, linking the workitem to its originating order and line.
• LINE_NUMBER — the line sequence on the order.
• STATUS_CODE and STATE — the current disposition of the fulfillment workitem.
• PROVISIONING_DATE and ACTUAL_PROVISIONING_DATE — planned versus actual provisioning timing.
• COMPLETION_DATE — when the workitem finished.
• WI_SEQUENCE and PRIORITY — ordering and scheduling controls.
• DUE_DATE and CUSTOMER_REQUIRED_DATE — service-level deadlines.
• ERROR_REF_ID — foreign key to XDP_DQ_EXCEPTIONS, capturing failure references.
• WF_ITEM_TYPE and WF_ITEM_KEY — linkage into Oracle Workflow.
• MSGID, WI_RUNTIME_MESSAGE_ID — runtime message correlation.
• Hold/cancel/resume lifecycle fields: CANCEL_PROVISIONING_DATE, HOLD_PROVISIONING_DATE, RESUME_PROVISIONING_DATE, and the associated CANCELED_BY, HELD_BY, RESUMED_BY columns.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, plus twenty ATTRIBUTE1–ATTRIBUTE20 descriptor columns.

Common Use Cases and Queries

Typical scenarios include monitoring open fulfillment workitems, reporting on order-to-provisioning latency, and diagnosing stuck or failed workitems. A basic status query joins the worklist to its order line items:

• SELECT w.WORKITEM_INSTANCE_ID, w.ORDER_ID, w.LINE_ITEM_ID, w.STATUS_CODE, w.STATE, w.PROVISIONING_DATE FROM XDP.XDP_FULFILL_WORKLIST w WHERE w.STATUS_CODE = :status;
• SELECT w.WORKITEM_INSTANCE_ID, w.ERROR_REF_ID FROM XDP.XDP_FULFILL_WORKLIST w WHERE w.ERROR_REF_ID IS NOT NULL;
• SELECT w.WORKITEM_INSTANCE_ID, w.COMPLETION_DATE - w.PROVISIONING_DATE AS cycle_days FROM XDP.XDP_FULFILL_WORKLIST w WHERE w.COMPLETION_DATE IS NOT NULL;

These patterns support operational dashboards, SLA breach analysis using DUE_DATE and CUSTOMER_REQUIRED_DATE, and exception triage by correlating ERROR_REF_ID with XDP_DQ_EXCEPTIONS.

Related Objects

XDP_FULFILL_WORKLIST is heavily referenced. The most significant related tables, with their join columns, are:

• XDP_ORDER_LINE_ITEMS — parent of ORDER_ID and LINE_ITEM_ID.
• XDP_WORKITEMS — parent of WORKITEM_ID.
• XDP_DQ_EXCEPTIONS — parent of ERROR_REF_ID.
• XDP_WORKLIST_DETAILS — references WORKITEM_INSTANCE_ID.
• XDP_WI_RELATIONSHIPS — references WORKITEM_INSTANCE_ID and RELATED_WI_INSTANCE_ID.
• XDP_FA_RUNTIME_LIST and XDP_FMC_AUDIT_TRAILS — reference WORKITEM_INSTANCE_ID.
• XNP_CALLBACK_EVENTS, XNP_MSGS, XNP_SV_ORDER_MAPPINGS, and XNP_TIMER_REGISTRY — reference WI_INSTANCE_ID or WORKITEM_INSTANCE_ID.
• XDP_ADAPTER_JOB_QUEUE — references WORKITEM_INSTANCE_ID.

Together these tables form the fulfillment runtime, audit, callback, and timing fabric that surrounds the worklist hub.