Search Results xdp_order_bundles




Overview
Explore in AI Chat

Overview

The XDP_ORDER_BUNDLES table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as a junction table that defines the relationship between orders and service bundles. In the context of order-to-service fulfillment, a bundle represents a predefined collection of services or products that can be ordered as a single unit. This table's primary role is to record which specific bundles are associated with a given customer order, enabling the provisioning system to process and fulfill complex, multi-service orders efficiently. It is integral to the order decomposition and orchestration workflows in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to manage the fundamental link between an order and its constituent bundles. The documented primary key consists of two columns, ensuring a unique record for each bundle on an order. The ORDER_ID column stores the unique identifier of the parent order, linking back to the XDP_ORDER_HEADERS table. The BUNDLE_ID column stores the unique identifier for the specific bundle associated with that order. While the provided metadata does not list additional descriptive columns, this core relationship is essential for tracking the bundle-level context of an order throughout the provisioning lifecycle.

Common Use Cases and Queries

A primary use case is retrieving all bundles linked to a specific order for fulfillment processing or order inquiry. For instance, a provisioning workflow engine would query this table to determine which service bundles must be activated for a newly submitted order. Common reporting needs include analyzing order composition by bundle type. Sample SQL patterns include joining to the order headers table for order details and filtering by order identifier.

  • SELECT * FROM xdp_order_bundles WHERE order_id = <order_number>;
  • SELECT h.order_number, b.bundle_id FROM xdp_order_headers h, xdp_order_bundles b WHERE h.order_id = b.order_id;

Related Objects

The XDP_ORDER_BUNDLES table maintains documented foreign key relationships with other critical provisioning tables, positioning it centrally in the order data model.

  • XDP_ORDER_HEADERS: The table has a foreign key (XDP_ORDER_BUNDLES.ORDER_ID) referencing XDP_ORDER_HEADERS. This establishes that every bundle record must belong to a valid master order.
  • XDP_ORDER_LINE_ITEMS: The XDP_ORDER_LINE_ITEMS table references XDP_ORDER_BUNDLES via its foreign key columns (ORDER_ID, BUNDLE_ID). This relationship indicates that individual line items within an order can be further associated with a specific bundle from this table, allowing for detailed decomposition of bundle components.