Search Results xdp_order_line_items

Overview

The XDP_ORDER_LINE_ITEMS table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module. It serves as the central repository for individual line items within a service order or fulfillment request. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the order decomposition and orchestration processes managed by the XDP engine. It stores the granular details of each product or service being provisioned, enabling the system to track, manage, and fulfill complex order structures through automated workflows and service activation tasks.

Key Information Stored

The table's structure is designed to link line items to their parent orders and associated fulfillment entities. Its primary key is the unique LINE_ITEM_ID. A unique key constraint on the combination of ORDER_ID and LINE_NUMBER ensures item sequence integrity within an order. Critical foreign key columns establish essential relationships: ORDER_ID links to XDP_ORDER_HEADERS, BUNDLE_ID to XDP_ORDER_BUNDLES, and WORKITEM_ID to XDP_WORKITEMS for process tracking. Integration with other EBS modules is facilitated through columns like INVENTORY_ITEM_ID and ORGANIZATION_ID (linking to Inventory via MTL_SYSTEM_ITEMS_B), SITE_USE_ID (linking to Trading Community Architecture via HZ_CUST_SITE_USES_ALL), and IB_SOURCE_ID (linking to Installed Base via CSI_ITEM_INSTANCES and CSI_T_TXN_LINE_DETAILs).

Common Use Cases and Queries

This table is central to provisioning reporting, order status tracking, and troubleshooting fulfillment workflows. Common operational queries involve joining to header and workitem tables to analyze the progress of specific order lines. For instance, a report to list all pending line items for a given order would typically join XDP_ORDER_LINE_ITEMS with XDP_ORDER_HEADERS and XDP_WORKITEMS. Another frequent use case is tracing the configuration or installed base details of a provisioned item by joining on the IB_SOURCE_ID to CSI tables. Support personnel often query this table to identify line items stuck in a particular workflow state by examining the associated WORKITEM_ID and its status in related XDP tables.

Related Objects

Based on the provided foreign key metadata, XDP_ORDER_LINE_ITEMS has extensive relationships within the XDP schema and integrates with core EBS modules. Key documented relationships include:

• Parent Tables: XDP_ORDER_HEADERS (on ORDER_ID), XDP_ORDER_BUNDLES (on ORDER_ID, BUNDLE_ID).
• Process Tracking: XDP_WORKITEMS (on WORKITEM_ID).
• Fulfillment Workflow: XDP_FULFILL_WORKLIST (linked on LINE_ITEM_ID, and also on ORDER_ID, LINE_NUMBER).
• Line Item Details & Relationships: XDP_ORDER_LINEITEM_DETS (on LINE_ITEM_ID), XDP_LINE_RELATIONSHIPS (on LINE_ITEM_ID and RELATED_LINE_ITEM_ID).
• Cross-Module Integration: MTL_SYSTEM_ITEMS_B (on INVENTORY_ITEM_ID, ORGANIZATION_ID), HZ_CUST_SITE_USES_ALL (on SITE_USE_ID), CSI_ITEM_INSTANCES and CSI_T_TXN_LINE_DETAILS (on IB_SOURCE_ID).