Search Results per_unit

Overview

The table PON.PON_FPK_DELETED_PRICE_ELEMENTS is a transactional data object within the Oracle E-Business Suite Purchasing (PON) schema. It stores information about unit price elements that have been deleted from a sourcing auction, specifically within the context of the Flexible Price Key (FPK) pricing model. In Oracle EBS 12.1.1 and 12.2.2, this table serves as an audit and staging repository for price element records that are no longer active on an auction header but remain retained for historical, reconciliation, or repricing purposes.

From a data modeling perspective, the metadata describes this table as standalone, with a heuristic Data Vault classification of a satellite. This classification reflects the table's role as a descriptive, keyed store of attributes that tie back to a parent auction header and price element type, rather than acting as an independent hub of business entities. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, consistent with typical transaction data storage conventions in Oracle EBS.

Key Information Stored

The table contains six documented columns. The most significant include:

• AUCTION_HEADER_ID (NUMBER) — The auction header identifier. This is a foreign key to PON_AUCTION_HEADERS_ALL and is the leading column of the non-unique index PON_FPK_DELETED_PES_U1, making it the primary access path for this table.
• LINE_NUMBER (NUMBER) — The auction line number associated with the deleted price element, allowing the record to be tied to a specific line item within the auction.
• PRICE_ELEMENT_TYPE_ID (NUMBER) — The price element type identifier. Per the documented metadata, a value of -10 designates a unit price element. This column is a foreign key to PON_PRICE_ELEMENT_TYPES.
• PRICING_BASIS (VARCHAR2, 30) — Describes the pricing basis; the documented convention is "PER_UNIT" for unit price elements. This is the column directly associated with the user search term "per_unit."
• VALUE (NUMBER) — The target value of the deleted price element.
• DISPLAY_TARGET_FLAG (VARCHAR2) — Indicates whether the target value was displayed to the supplier.

No surrogate primary key column is documented. The unique identifier is effectively composed of the business keys AUCTION_HEADER_ID, LINE_NUMBER, and PRICE_ELEMENT_TYPE_ID, though only a non-unique index is documented on AUCTION_HEADER_ID.

Common Use Cases and Queries

This table is typically queried to recover or audit unit price elements deleted during auction maintenance. A common reporting pattern isolates unit price deletions by filtering on PRICING_BASIS = 'PER_UNIT' together with the documented type identifier:

• Auditing deleted unit prices for a specific auction: SELECT LINE_NUMBER, VALUE, DISPLAY_TARGET_FLAG FROM PON.PON_FPK_DELETED_PRICE_ELEMENTS WHERE AUCTION_HEADER_ID = :auction_id AND PRICE_ELEMENT_TYPE_ID = -10;
• Confirming unit price basis: SELECT * FROM PON.PON_FPK_DELETED_PRICE_ELEMENTS WHERE PRICING_BASIS = 'PER_UNIT';
• Historical analysis of target values by line for reconciliation against active price elements.

Related Objects

The ETRM metadata documents the following key relationships:

• PON.PON_AUCTION_HEADERS_ALL — Referenced via AUCTION_HEADER_ID; the parent auction definition.
• PON.PON_PRICE_ELEMENT_TYPES — Referenced via PRICE_ELEMENT_TYPE_ID; provides the type definitions including the unit price type (-10).
• APPS.PON_FPK_DELETED_PRICE_ELEMENTS — The APPS synonym that references this table, which is the object applications typically query.

Together, these relationships position the table as a dependent satellite of the auction header entity, holding deleted unit price detail with a clear PER_UNIT pricing basis semantic.