Search Results dpp_txn_lines_int_all_u1

Overview

DPP.DPP_TXN_LINES_INT_ALL is an Oracle E-Business Suite interface table belonging to the DPP (Price Protection) schema. It stores Price Protection Transaction line-level details received from suppliers as part of the inbound Price Protection workflow. In EBS 12.1.1 and 12.2.2, this table functions as a staging area: supplier-provided price protection claims are loaded here before validation and transfer into the base Price Protection transaction tables. It resides in the APPS_TS_INTERFACE tablespace with a PCT Free of 10, and is classified as VALID in the ETRM repository. FND Design Data identifies it as DPP.DPP_TXN_LINES_INT_ALL.

The metadata's heuristic Data Vault classification for this object is standalone. In Data Vault modeling terms, this suggests treating DPP_TXN_LINES_INT_ALL as a link-style staging object that associates a transaction header with individual item-level price protection lines, rather than a pure hub or a descriptive satellite. Because interface tables are transient by nature, this classification should be viewed only as a modeling suggestion.

Key Information Stored

The table's surrogate primary key is TRANSACTION_INT_LINE_ID, which is also enforced by the unique index DPP_TXN_LINES_INT_ALL_U1. This column uniquely identifies each interface transaction line and is the primary business-key candidate documented in the schema. The parent identifier TRANSACTION_INT_HEADER_ID links each line to its corresponding interface transaction header.

The most significant columns include:

• TRANSACTION_INT_LINE_ID – Unique identifier for the interface transaction line (PK; U1 index).
• TRANSACTION_INT_HEADER_ID – Foreign key to the interface transaction header; groups lines under one claim.
• SUPPLIER_PART_NUM – Supplier Part Number as provided by the vendor.
• INVENTORY_ITEM_ID and ITEM_NUMBER – Inventory item identifiers used to resolve the internal item.
• CHANGE_TYPE – Nature of the price change: Increase Amount, Increase Percentage, New Price, Decrease Amount, or Decrease Percentage.
• CHANGE_VALUE and PRICE_CHANGE – Magnitude of the change and the resulting price difference.
• PRIOR_PRICE and SUPPLIER_NEW_PRICE – The original purchase price and the supplier's proposed new price.
• COVERED_INVENTORY – Inventory quantity calculated by the ERP application.
• APPROVED_INVENTORY – Inventory quantity the supplier approved for coverage under the claim.
• CLAIM_AMOUNT – Monetary value claimed for the line.
• UOM and ORG_ID – Unit of measure and the operating unit context.
• INTERFACE_STATUS and ERROR_CODE – Processing state and validation error diagnostics.

Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), concurrent program columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), and the ATTRIBUTE_CATEGORY plus ATTRIBUTE1–ATTRIBUTE30 flexfield columns complete the 57 documented columns.

Common Use Cases and Queries

Typical usage centers on loading, validating, and monitoring supplier price protection claims. A frequent query retrieves all lines for a given header:

• SELECT TRANSACTION_INT_LINE_ID, SUPPLIER_PART_NUM, ITEM_NUMBER, CHANGE_TYPE, CHANGE_VALUE, CLAIM_AMOUNT, INTERFACE_STATUS FROM DPP.DPP_TXN_LINES_INT_ALL WHERE TRANSACTION_INT_HEADER_ID = :header_id;
• Identifying failed records: SELECT * FROM DPP.DPP_TXN_LINES_INT_ALL WHERE INTERFACE_STATUS = 'ERROR' AND ERROR_CODE IS NOT NULL;
• Aggregating claim value per operating unit: SELECT ORG_ID, SUM(CLAIM_AMOUNT) FROM DPP.DPP_TXN_LINES_INT_ALL WHERE INTERFACE_STATUS = 'PROCESSED' GROUP BY ORG_ID;

Reporting scenarios include reconciliation of supplier-approved inventory against ERP-computed covered inventory, price variance analysis across UOMs, and auditing of change types by supplier part number.

Related Objects

The principal related object is DPP.DPP_TXN_HEADERS_INT_ALL, joined via TRANSACTION_INT_HEADER_ID, which supplies the header-level context for each line. The unique index DPP_TXN_LINES_INT_ALL_U1 depends on TRANSACTION_INT_LINE_ID, and the primary key DPP_TXN_LINES_INT_ALL_PK provides row-level integrity. Downstream, the Price Protection concurrent programs read from this staging table and write validated records into the base Price Protection transaction tables, from which claim and settlement reporting is derived. Inventory item validation relies on standard EBS item master tables referenced indirectly through INVENTORY_ITEM_ID and ITEM_NUMBER.