Search Results dpp_inventory_details_adj_all




Overview
Explore in AI Chat

Overview

DPP_INVENTORY_DETAILS_ADJ_ALL is a transactional table in the DPP (Oracle Price Protection) schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores inventory receipt adjustment information for all products referenced on a price protection transaction. Price Protection is the EBS module that manages vendor rebates and price adjustments on purchased inventory, and this table captures the receipt-level detail that drives the adjustment calculation, including quantities received, units of measure, and the interval between receipt and adjustment processing.

The table is registered in ETRM as VALID with 46 documented columns under the DPP owner. Its structure is typical of a multi-organization (_ALL) transactional entity, carrying ORG_ID for operating unit scope and the full WHO column set (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) plus OBJECT_VERSION_NUMBER for optimistic locking. The presence of thirty ATTRIBUTE flex columns reflects the standard EBS extensibility pattern, allowing implementers to persist additional descriptive data without schema modifications.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone. Because the table does not exhibit the hub-and-link pattern of shared business keys across a network of dependent tables, it is best modeled as an independent entity or incorporated into a broader satellite rather than decomposed into hub, link, and satellite components.

Key Information Stored

The primary key is DPP_INVENTORY_DETAILS_ADJ_PK, defined on the surrogate column INV_DETAILS_ADJ_ID. A unique index, DPP_INVENTORY_DETAILS_ADJ_U1, also covers INV_DETAILS_ADJ_ID, confirming it as the single-column business-key candidate for the row identifier. The most significant columns include:

  • INV_DETAILS_ADJ_ID — Surrogate primary key uniquely identifying each adjustment detail row.
  • INVENTORY_DETAILS_ID — Foreign key to DPP_INVENTORY_DETAILS_ALL, linking the adjustment to its parent inventory detail record.
  • DATE_RECEIVED — Date the inventory was received, used to determine eligibility for price protection.
  • DAYS_OUT — Elapsed interval, typically between receipt and adjustment processing, driving aging calculations.
  • QUANTITY — Quantity of product received that is subject to adjustment.
  • UOM — Unit of measure for the recorded quantity.
  • INCLUDE_FLAG — Indicator controlling whether the row participates in the adjustment calculation.
  • COMMENTS — Free-text annotation for the adjustment line.
  • ORG_ID — Operating unit that owns the transaction, enabling multi-org data partitioning.
  • OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent updates through the OAF framework.
  • ATTRIBUTE1–ATTRIBUTE30 — Descriptive flexfield segments for customer-specific extensions.

Common Use Cases and Queries

Typical reporting scenarios include reconciling receipt quantities against price protection claims, reviewing aging of unprocessed adjustments, and auditing which lines were excluded from a claim. A representative query joining detail to adjustment rows is:

  • SELECT a.INV_DETAILS_ADJ_ID, a.DATE_RECEIVED, a.DAYS_OUT, a.QUANTITY, a.UOM FROM DPP.DPP_INVENTORY_DETAILS_ADJ_ALL a WHERE a.INCLUDE_FLAG = 'Y' AND a.ORG_ID = :org_id;
  • SELECT a.INV_DETAILS_ADJ_ID, d.INVENTORY_DETAILS_ID FROM DPP.DPP_INVENTORY_DETAILS_ADJ_ALL a JOIN DPP.DPP_INVENTORY_DETAILS_ALL d ON d.INVENTORY_DETAILS_ID = a.INVENTORY_DETAILS_ID;

Common filters include ORG_ID for operating unit scoping, DATE_RECEIVED for period reporting, INCLUDE_FLAG for claim eligibility, and DAYS_OUT for aging analysis. Because the table is transactional, reporting should generally restrict by date range and organization to avoid full-table scans.

Related Objects

The dominant relationship is the foreign key from INVENTORY_DETAILS_ID to DPP_INVENTORY_DETAILS_ALL, the parent inventory detail entity. Significant related objects include:

  • DPP_INVENTORY_DETAILS_ALL — Parent table; joined on INVENTORY_DETAILS_ID.
  • DPP_INVENTORY_DETAILS_ADJ_PK — Primary key constraint on INV_DETAILS_ADJ_ID.
  • DPP_INVENTORY_DETAILS_ADJ_U1 — Unique index supporting the business-key candidate.
  • DPP Adjustment and Claim tables — Price protection claim processing entities that consume adjusted receipt quantities.
  • INV Receiving tables — Source of DATE_RECEIVED and QUANTITY values propagated into this table.

No PL/SQL API is documented for direct DML; modifications should flow through the Oracle Price Protection concurrent programs and OAF pages that maintain the adjustment records.