Search Results po_price_differentials




Overview
Explore in AI Chat

Overview

PO_PRICE_DIFFERENTIALS is a Purchasing module table in the PO schema that stores price differential definitions applied to rate-based purchasing lines in Oracle EBS 12.1.1 and 12.2.2. Rate-based lines are used for items such as freight, services, or complex pricing arrangements where the final negotiated price is derived by applying one or more multipliers against a base rate rather than entering a flat unit price directly. This table captures the differential rules — the multiplier values and their permitted minimum and maximum bounds — that govern how those rate-based prices are calculated.

The object is documented as VALID in the ETRM repository with 14 columns and a primary key named PO_PRICE_DIFFERENTIALS_PK1 on PRICE_DIFFERENTIAL_ID. From a Data Vault modeling perspective, the heuristic classification mined from its foreign-key structure is standalone, suggesting this table can be modeled as an independent hub or reference construct rather than a dependent link or satellite. Its two unique indexes indicate that both a surrogate identifier and a composite business key are enforced.

Key Information Stored

The table's surrogate primary key is PRICE_DIFFERENTIAL_ID, uniquely enforced by PO_PRICE_DIFFERENTIALS_PK1 and also by the unique index PO_PRICE_DIFFERENTIALS_U1. A second unique index, PO_PRICE_DIFFERENTIALS_U2, covers the composite business key of ENTITY_ID, ENTITY_TYPE, and PRICE_TYPE, which together identify the owning entity and the pricing context to which the differential applies.

  • PRICE_DIFFERENTIAL_ID — surrogate primary key, system-generated identifier.
  • PRICE_DIFFERENTIAL_NUM — user-facing differential number or sequence.
  • ENTITY_ID / ENTITY_TYPE — identify the owning entity (for example, the purchaser, supplier, or pricing entity) that the differential belongs to.
  • PRICE_TYPE — the pricing category against which the differential is applied; combined with ENTITY_ID and ENTITY_TYPE it forms the business key.
  • ENABLED_FLAG — indicates whether the differential is active and available for use.
  • MULTIPLIER — the core conversion factor applied to a base rate.
  • MIN_MULTIPLIER / MAX_MULTIPLIER — the permitted lower and upper bounds governing valid multiplier values.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns recording creation and modification history.

Common Use Cases and Queries

Typical reporting scenarios include validating that active differentials have sensible multiplier ranges, listing all differentials tied to a given entity, and auditing changes to pricing rules. EBS's own purchasing and pricing engines reference this table when computing rate-based line prices, so verification queries frequently precede period-close or pricing reviews.

A basic listing of enabled differentials for an entity:

  • SELECT PRICE_DIFFERENTIAL_ID, PRICE_DIFFERENTIAL_NUM, PRICE_TYPE, MULTIPLIER, MIN_MULTIPLIER, MAX_MULTIPLIER FROM PO.PO_PRICE_DIFFERENTIALS WHERE ENTITY_ID = :entity_id AND ENTITY_TYPE = :entity_type AND ENABLED_FLAG = 'Y';
  • Use PO_PRICE_DIFFERENTIALS_U2 (ENTITY_ID, ENTITY_TYPE, PRICE_TYPE) to look up a specific business-key combination.
  • Query MIN_MULTIPLIER and MAX_MULTIPLIER to detect outliers where MULTIPLIER falls outside documented bounds.
  • Use LAST_UPDATE_DATE and LAST_UPDATED_BY for change-audit reporting.

Because the table is small and reference-oriented, joins are typically performed on PRICE_DIFFERENTIAL_ID from consuming pricing tables rather than on large transactional sources.

Related Objects

Given the standalone Data Vault classification, the table has no mined foreign-key dependencies, so the relationships below are driven by shared columns and functional context rather than enforced FK constraints. The most significant associated objects include:

  • PO_HEADERS_ALL and PO_LINES_ALL — purchasing documents whose rate-based lines consume differential pricing.
  • PO_LINE_LOCATIONS_ALL — shipment-level records affected by differential multipliers.
  • PO_PRICE_DIFFERENTIALS_U2 — the composite unique index on ENTITY_ID, ENTITY_TYPE, and PRICE_TYPE, used for business-key lookups.
  • PO_PRICE_DIFFERENTIALS_PK1 / U1 — primary and unique index on PRICE_DIFFERENTIAL_ID.
  • PO_LOOKUP_CODES / PO_ENTITY types — reference data supplying valid ENTITY_TYPE and PRICE_TYPE values.
  • Purchasing and Pricing APIs — programmatic interfaces that validate and apply differentials during price calculation.