Search Results po_price_diff_draft




Overview
Explore in AI Chat

Overview

The PO_PRICE_DIFF_DRAFT table is a core transactional object within the Oracle E-Business Suite Purchasing (PO) module, specifically for versions 12.1.1 and 12.2.2. It functions as a draft or staging table for price differentials associated with rate-based purchase order lines. Its primary role is to temporarily hold uncommitted price differential data during the requisition or purchase order creation and modification process before the data is finalized and moved to its corresponding base table. This draft architecture is essential for supporting complex, multi-step procurement workflows, allowing users to save incomplete work without affecting committed purchasing data.

Key Information Stored

The table stores draft records for price differential adjustments, which are typically used in contracts or purchase agreements with variable pricing based on predefined conditions or tiers. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical structure. The PRICE_DIFFERENTIAL_ID column uniquely identifies a specific price differential rule or adjustment. The DRAFT_ID column is a foreign key that links the draft differential data to a specific draft document session in the PO_DRAFTS table. This relationship ensures all uncommitted changes for a document are grouped and managed together.

Common Use Cases and Queries

The primary use case involves the internal processing of draft purchase documents. When a buyer creates or modifies a rate-based line and applies a price differential, the application writes this information to PO_PRICE_DIFF_DRAFT. Common operational queries are typically embedded within the application's forms and APIs. For reporting and troubleshooting, one might query draft differentials for a specific document draft. A sample pattern to identify all draft price differentials for a particular draft session would be:

  • SELECT * FROM po.po_price_diff_draft ppdd WHERE ppdd.draft_id = <DRAFT_ID_VALUE>;

Data in this table is transient; it is purged or archived once the associated draft is either submitted (and data moves to base tables) or deleted.

Related Objects

PO_PRICE_DIFF_DRAFT has a direct and documented dependency relationship with the PO_DRAFTS table, which serves as the master control table for all draft purchasing documents. The relationship is enforced by a foreign key constraint where PO_PRICE_DIFF_DRAFT.DRAFT_ID references a corresponding record in PO_DRAFTS. This table is also intrinsically related to the base transaction table for price differentials (likely named PO_PRICE_DIFFERENCES or similar), to which data is ultimately posted. Furthermore, it interacts with APIs and packages within the PO module responsible for managing the draft-to-final document lifecycle, such as those involved in the requisition import and purchase order approval processes.