Search Results dpp_customer_claims_all




Overview
Explore in AI Chat

Overview

DPP_CUSTOMER_CLAIMS_ALL is a transactional table in the Oracle Price Protection (DPP) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The table stores customer inventory and claim information associated with a Price Protection Transaction. Price Protection supports scenarios in which a supplier reduces the price of goods after they have already been sold into a customer's inventory; the module calculates the resulting price drop exposure, reports the customer's on-hand inventory, and generates the corresponding customer and supplier claims, typically settled through debit memos.

The table resides in the DPP schema and is classified as VALID. Physically it contains 58 columns, a primary key constraint named DPP_CUSTOMER_CLAIMS_ALL_PK defined on CUSTOMER_INV_LINE_ID, and two unique indexes: DPP_CUSTOMER_CLAIMS_ALL_U1 on CUSTOMER_INV_LINE_ID and DPP_CUSTOMER_CLAIMS_ALL_U2 on TRANSACTION_HEADER_ID and LINE_NUMBER. Based on the mined foreign-key structure, the table is heuristically classified as a standalone object within a Data Vault model. This classification should be treated as a modeling suggestion rather than a definitive architectural statement, since the table carries its own transaction header reference and customer reference without participating in a broader hub-and-link topology.

Key Information Stored

Each row represents a single customer inventory claim line tied to a price protection transaction. The most significant columns are:

Common Use Cases and Queries

Typical reporting scenarios include reconciling supplier versus customer claim amounts for a transaction, auditing the delta between reported and calculated inventory before settlement, and producing customer-facing price protection statements. A representative query:

  • SELECT line_number, cust_account_id, inventory_item_id, cust_claim_amt, supp_claim_amt FROM dpp.dpp_customer_claims_all WHERE transaction_header_id = :txn_id ORDER BY line_number;
  • Aggregate exposure by item: SELECT inventory_item_id, SUM(cust_claim_amt) FROM dpp.dpp_customer_claims_all WHERE org_id = :org_id GROUP BY inventory_item_id;
  • Detect unreleased claims: SELECT customer_inv_line_id FROM dpp.dpp_customer_claims_all WHERE customer_claim_created = 'N' OR supplier_claim_created = 'N';

Because the table holds multiple operating unit rows, ORG_ID filtering or MOAC policy is required in any production query.

Related Objects

  • HZ_CUST_ACCOUNTS — Referenced by CUST_ACCOUNT_ID; joins the claim to customer master data.
  • DPP_CUSTOMER_CLAIMS_LOG — References DPP_CUSTOMER_CLAIMS_ALL via CUSTOMER_INV_LINE_ID; maintains an audit trail of changes to each claim line.
  • Parent price protection transaction header tables referenced through TRANSACTION_HEADER_ID.
  • Inventory item master (INVENTORY_ITEM_ID) for item validation and descriptive reporting.
  • Debit memo and receivables interfaces that consume DEBIT_MEMO_NUMBER for settlement.