Search Results xdp_oe_order_line_dets




Overview
Explore in AI Chat

Overview

The table XDP_OE_ORDER_LINE_DETS is an Oracle E-Business Suite table owned by the XDP schema, which supports the Provisioning product module. It stores the order line parameter values for orders generated by the SFM (Service Fulfillment Manager) Order Entry interface. Within EBS 12.1.1 and 12.2.2, this table functions as a child detail table of the order line header information, capturing the individual name/value parameters that define each configurable or provisionable attribute of an order line. Each row represents a single parameter associated with a specific order line.

From a data-modeling perspective, the metadata's heuristic Data Vault classification suggests this object is satellite-leaning. This characterization is appropriate because the table holds descriptive, volatile attribute values (the individual parameters) that are functionally dependent on the parent order line key rather than serving as an independent hub or link. The parameter attributes are typically loaded and updated as order provisioning data changes over time.

Key Information Stored

The table contains 12 documented columns. The most significant are the composite key columns and the parameter payload columns:

The documented unique index XDP_OE_ORDER_LINE_DETS_U1 (also represented by the primary key constraint XDP_OE_ORDER_LINE_DETS_UK1) spans ORDER_NUMBER, ORDER_VERSION, LINE_NUMBER, and PARAMETER_NAME. This combination forms the business-key candidate uniquely identifying each parameter row. No separate surrogate key column is documented; the unique index itself acts as the primary identifier.

Common Use Cases and Queries

Typical use cases include reporting on provisioning parameters per order line, extracting configured values for downstream fulfillment systems, and auditing parameter changes across order versions. A common query pattern joins the detail table to its parent order line table:

  • Retrieve all parameters for a given order line: SELECT PARAMETER_NAME, PARAMETER_VALUE, PARAMETER_REF_VALUE FROM XDP.XDP_OE_ORDER_LINE_DETS WHERE ORDER_NUMBER = :order_number AND ORDER_VERSION = :order_version AND LINE_NUMBER = :line_number;
  • Pivot parameter names into columns for reporting: use conditional aggregation over PARAMETER_NAME to produce a wide-format view of each order line's configuration.
  • Join to the parent line table to correlate parameters with line-level attributes: SELECT l.*, d.PARAMETER_NAME, d.PARAMETER_VALUE FROM XDP.XDP_OE_ORDER_LINE_DETS d JOIN XDP.XDP_OE_ORDER_LINES l ON d.ORDER_NUMBER = l.ORDER_NUMBER AND d.ORDER_VERSION = l.ORDER_VERSION AND d.LINE_NUMBER = l.LINE_NUMBER;

Because orders can exist in multiple versions, queries should always include ORDER_VERSION in the predicate to avoid returning values from superseded configurations.

Related Objects

The following objects are the most significant dependencies and references for XDP_OE_ORDER_LINE_DETS:

  • XDP_OE_ORDER_LINES — The immediate parent table; joined on ORDER_NUMBER, ORDER_VERSION, and LINE_NUMBER.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for data security partitioning.
  • SFM Order Entry interface objects — The SFM Order Entry interface populates this table during order generation; related staging and interface tables in the XDP schema feed these parameter values.
  • XDP_OE_ORDER_HEADERS (implied parent hierarchy) — The order header level from which order lines and their parameters derive, useful when reporting order-to-parameter rollups.

Administrators should treat XDP_OE_ORDER_LINE_DETS as a detail satellite to the order line model, ensuring referential integrity with XDP_OE_ORDER_LINES is maintained whenever order data is purged or archived.