Search Results dpp_txn_lines_int_all

Overview

DPP_TXN_LINES_INT_ALL is the line-level interface table within the Oracle Price Protection (DPP) module of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. Its stated purpose is to store Price Protection Transaction line-level details received from suppliers. Suppliers typically transmit price change notifications in bulk files or through partner integrations; those transmissions are staged here before Oracle Price Protection validation and processing routines consume them to create or adjust price protection claims, transaction lines, and associated accounting.

The table resides in the DPP schema and is documented as VALID. It is classified heuristically as standalone under Data Vault modeling principles; in practice this suggests it behaves as a staging or satellite-style structure that captures descriptive attributes of each incoming supplier line, keyed to a parent interface header rather than being a pure hub or link. The DPP_TXN_HEADERS_INT_ALL parent relationship confirms a header-line interface pattern.

Key Information Stored

The documented physical schema contains 57 columns, with the primary key constraint DPP_TXN_LINES_INT_ALL_PK defined on TRANSACTION_INT_LINE_ID, which is also exposed via the unique index DPP_TXN_LINES_INT_ALL_U1. TRANSACTION_INT_LINE_ID is therefore the surrogate primary key for the line record, while TRANSACTION_INT_HEADER_ID is the foreign key to the parent header interface table.

• TRANSACTION_INT_HEADER_ID — foreign key linking the line to its parent record in DPP_TXN_HEADERS_INT_ALL.
• TRANSACTION_INT_LINE_ID — surrogate primary key uniquely identifying the interface line.
• SUPPLIER_PART_NUM, INVENTORY_ITEM_ID, ITEM_NUMBER — supplier part reference, internal inventory item identifier, and item number used to resolve the affected item.
• CHANGE_TYPE, CHANGE_VALUE — the nature of the supplier-initiated change and its value.
• PRIOR_PRICE, SUPPLIER_NEW_PRICE, PRICE_CHANGE — the pre-change price, the supplier's proposed new price, and the resulting delta.
• COVERED_INVENTORY, APPROVED_INVENTORY, UOM — quantities covered and approved, with unit of measure.
• CLAIM_AMOUNT — the monetary claim amount associated with the line.
• ORG_ID — the operating unit, essential for multi-org security and reporting.
• INTERFACE_STATUS, ERROR_CODE — processing state and error diagnostics for the import run.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program context that created the record.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the standard EBS descriptive flexfield columns supplied for extensibility.

Common Use Cases and Queries

Typical usage centers on monitoring supplier feeds, diagnosing interface failures, and reconciling claims. Analysts frequently query unprocessed or errored lines by status and operating unit:

• SELECT TRANSACTION_INT_LINE_ID, TRANSACTION_INT_HEADER_ID, ITEM_NUMBER, SUPPLIER_NEW_PRICE, CLAIM_AMOUNT, INTERFACE_STATUS, ERROR_CODE FROM DPP_TXN_LINES_INT_ALL WHERE INTERFACE_STATUS = 'ERROR' AND ORG_ID = :org_id;
• Joining to the header table to present a full supplier submission: SELECT h.TRANSACTION_INT_HEADER_ID, l.ITEM_NUMBER, l.PRIOR_PRICE, l.SUPPLIER_NEW_PRICE, l.PRICE_CHANGE FROM DPP_TXN_HEADERS_INT_ALL h, DPP_TXN_LINES_INT_ALL l WHERE h.TRANSACTION_INT_HEADER_ID = l.TRANSACTION_INT_HEADER_ID;
• Aggregating claim value by supplier or item for reporting: SELECT ITEM_NUMBER, SUM(CLAIM_AMOUNT) FROM DPP_TXN_LINES_INT_ALL WHERE INTERFACE_STATUS = 'PROCESSED' GROUP BY ITEM_NUMBER;
• Tracing a concurrent run: filter on REQUEST_ID to isolate all lines loaded by a specific Price Protection import or validation program.

Related Objects

Based on the documented foreign key and schema relationships, the most significant related objects are:

• DPP_TXN_HEADERS_INT_ALL — parent header interface table; joined on TRANSACTION_INT_HEADER_ID.
• DPP_TXN_LINES_INT_ALL_PK — primary key constraint on TRANSACTION_INT_LINE_ID.
• DPP_TXN_LINES_INT_ALL_U1 — unique index on TRANSACTION_INT_LINE_ID.
• DPP module transaction and claim tables, populated by the import process from these staged lines.
• Order Management and Purchasing item/price reference tables used to resolve INVENTORY_ITEM_ID and ITEM_NUMBER.

Access to this table should be restricted to integration and DBA personnel, as records represent pre-validated supplier data and are transient in nature once processed into the Price Protection transaction model.