Search Results xdp_line_relationships




Overview
Explore in AI Chat

Overview

The XDP_LINE_RELATIONSHIPS table is a core data structure within the Oracle E-Business Suite Provisioning (XDP) module. Its primary function is to model and manage hierarchical relationships between order line items, specifically to identify when a line item is a component of a package line. This table is essential for the accurate processing and fulfillment of complex service orders that involve bundled products or services. By maintaining these associations, the Provisioning engine can correctly orchestrate the activation, configuration, and provisioning of all related components as a cohesive unit, ensuring data integrity and process consistency across the order-to-fulfillment lifecycle in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is intentionally simple, designed to efficiently store relationship pairs. Its primary key is a composite of two columns, which together enforce the uniqueness of each relationship record. The critical columns are:

  • LINE_ITEM_ID: This column stores the unique identifier for the primary or parent line item, typically representing the package line itself. It is a foreign key referencing the XDP_ORDER_LINE_ITEMS table.
  • RELATED_LINE_ITEM_ID: This column stores the unique identifier for the related or child line item, representing a component that belongs to the package. It is also a foreign key referencing the XDP_ORDER_LINE_ITEMS table.

The relationship is directional, with the combination of these two IDs defining a specific "is-part-of" link within the order structure.

Common Use Cases and Queries

A primary use case is during order decomposition and provisioning, where the system must retrieve all components of a package for simultaneous processing. For instance, provisioning a "Business Internet Bundle" may require activating a broadband line, an email account, and a static IP address, each represented as separate but related line items. Common SQL queries include finding all components of a given package line or identifying the parent package for a specific component line. A sample query to retrieve all component lines for a specific package would be:

  • SELECT rel.related_line_item_id, oli.line_item_number FROM xdp_line_relationships rel JOIN xdp_order_line_items oli ON rel.related_line_item_id = oli.line_item_id WHERE rel.line_item_id = <PACKAGE_LINE_ITEM_ID>;

This data is also critical for reporting on package uptake, component-level fulfillment status, and analyzing the composition of sold services.

Related Objects

The XDP_LINE_RELATIONSHIPS table has a tightly coupled relationship with the central order line items table. As documented in the metadata, it references the XDP_ORDER_LINE_ITEMS table through two distinct foreign key constraints:

  • XDP_ORDER_LINE_ITEMS: The LINE_ITEM_ID column in XDP_LINE_RELATIONSHIPS references a record in this table, identifying the package line.
  • XDP_ORDER_LINE_ITEMS: The RELATED_LINE_ITEM_ID column in XDP_LINE_RELATIONSHIPS references a different record in the same XDP_ORDER_LINE_ITEMS table, identifying the component line.

This design means that both ends of the relationship must be valid, existing line items. The table is central to the provisioning data model and is likely referenced by various internal XDP APIs and workflows responsible for order management and service activation.