Results for “xdp_order_lineitem_dets”

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

Overview

The XDP_ORDER_LINEITEM_DETS table resides in the XDP schema and belongs to the Provisioning (XDP) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the granular parameter detail rows attached to an order line item, functioning as the descriptive extension of the order line item entity. Where XDP_ORDER_LINE_ITEMS records the line-level provisioning request, XDP_ORDER_LINEITEM_DETS captures the individual name/value parameters that further qualify that line — for example service attributes, configuration options, or reference values consumed by downstream provisioning logic.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table carries a composite primary key defined by XDP_ORDER_LINEITEM_DETS_PK over LINE_ITEM_ID and LINE_PARAMETER_NAME, and its foreign key to XDP_ORDER_LINE_ITEMS.LINE_ITEM_ID anchors it to a parent business entity. This pattern is characteristic of a satellite attached to a line-item hub or link, where each row describes an attribute of the parent rather than establishing a new independent entity. This classification is offered as a modeling suggestion derived from the referential structure, not as a documented designation.

Key Information Stored

The documented physical schema contains 10 columns. The most operationally significant are:

• LINE_ITEM_ID — The foreign key referencing XDP_ORDER_LINE_ITEMS; identifies the parent order line to which the parameter detail belongs. It forms the leading component of the composite primary key.
• LINE_PARAMETER_NAME — The name of the parameter being described; the second component of the composite primary key. Together with LINE_ITEM_ID it uniquely identifies each detail row.
• PARAMETER_VALUE — The value assigned to the named parameter for that line item, carrying the substantive provisioning attribute.
• PARAMETER_REFERENCE_VALUE — A secondary or reference-oriented value associated with the parameter, typically used to hold a lookup code, external reference, or normalized form of the parameter.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing Multi-Org / data security partitioning of the row.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified the row and when.

The surrogate primary key is XDP_ORDER_LINEITEM_DETS_PK on (LINE_ITEM_ID, LINE_PARAMETER_NAME). A unique index, XDP_ORDER_LINEITEM_DETS_U1, is documented over the same column pair, confirming that this combination is also the business-key candidate: a given parameter name may appear only once per line item.

Common Use Cases and Queries

The table is primarily consumed when provisioning processes need to expand an order line into its constituent parameters, or when reporting on the configuration of a submitted order line. A typical join retrieves the parent line together with its parameters:

• Retrieve all parameters for a specific line: SELECT line_parameter_name, parameter_value FROM xdp.xdp_order_lineitem_dets WHERE line_item_id = :p_line_item_id;
• Locate lines carrying a specific parameter value: SELECT d.line_item_id, d.parameter_value FROM xdp.xdp_order_lineitem_dets d WHERE d.line_parameter_name = :p_name AND d.parameter_value = :p_value;
• Join to the parent line for contextual reporting: SELECT l.line_item_id, d.line_parameter_name, d.parameter_value FROM xdp.xdp_order_line_items l, xdp.xdp_order_lineitem_dets d WHERE l.line_item_id = d.line_item_id;
• Security-scoped extraction for a given operating unit or security group: filter on SECURITY_GROUP_ID to respect Multi-Org access.

Because the primary key is composite, queries should always supply or join on both key columns to ensure index-driven access. Reporting use cases include parameter audits, provisioning diagnostics, and reconciliation of configuration values against reference data held in PARAMETER_REFERENCE_VALUE.

Related Objects

• XDP_ORDER_LINE_ITEMS — Parent table; joined via XDP_ORDER_LINEITEM_DETS.LINE_ITEM_ID = XDP_ORDER_LINE_ITEMS.LINE_ITEM_ID. Every detail row must reference a valid line item.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID, supporting Multi-Org security filtering.
• XDP_ORDER_LINEITEM_DETS_PK — Primary key constraint enforcing uniqueness of the (LINE_ITEM_ID, LINE_PARAMETER_NAME) pair.
• XDP_ORDER_LINEITEM_DETS_U1 — Unique index over the same business-key columns, supporting both integrity and efficient lookups.
• Provisioning APIs and concurrent programs in the XDP module that read order line parameters to drive service fulfillment.

Together these objects form the line-item provisioning model, with XDP_ORDER_LINEITEM_DETS supplying the parameter-level detail required for downstream activation.