Search Results pon_bid_price_elements_int

Overview

PON_BID_PRICE_ELEMENTS_INT is the interface (staging) table used by Oracle Sourcing (PON) to import price element data associated with supplier bids in an auction or negotiation. Within Oracle EBS 12.1.1 and 12.2.2, this table serves as the inbound landing area for external bid price element information that must be validated and then transferred into the base Sourcing transactional tables via the concurrent interface program. It is owned by the PON schema and is classified as VALID in the ETRM repository. The table is a classic ETRM interface object: it holds raw rows keyed to a batch, carries audit columns, and references parent auction headers and price element definitions rather than owning them.

From a heuristic Data Vault modeling perspective, the FK structure (standalone classification) suggests this table behaves primarily as a satellite attached to an auction header hub, with references to a price element type reference table. It does not act as a hub or link in its own right; it accumulates descriptive and numeric attributes about bid price elements pending processing.

Key Information Stored

The table contains 15 documented columns. The most significant are:

BATCH_ID – Groups a set of interface rows loaded as a single logical batch for processing and reconciliation.
INTERFACE_LINE_ID – The surrogate identifier for each interface row; the primary candidate key for uniquely identifying a staged record.
AUCTION_HEADER_ID – Foreign key to PON_AUCTION_HEADERS_ALL, tying the price element to a specific auction or negotiation.
PRICE_ELEMENT_TYPE_ID – Foreign key to PON_PRICE_ELEMENT_TYPES, defining the category (e.g., cost, tax, freight) of the price element.
BID_NUMBER and LINE_NUMBER – Business identifiers locating the bid and the specific line within the auction.
BID_CURRENCY_VALUE and BID_AUCTION_VALUE – The monetary amounts expressed in the bid currency and the auction currency respectively, enabling multi-currency comparisons.
PRICE_ELEMENT_NAME – Descriptive label for the price element as supplied by the source.
WORKSHEET_NAME and WORKSHEET_SEQUENCE_NUMBER – Identify the worksheet context and ordering for the element.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY – Standard audit columns tracking insert and modification.

Business-key candidates include the combination of AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, and PRICE_ELEMENT_TYPE_ID, while INTERFACE_LINE_ID serves as the surrogate key.

Common Use Cases and Queries

Typical scenarios include pre-import validation, batch reconciliation, and error diagnosis before the interface program transfers rows into the base Sourcing tables. A representative query retrieves staged elements for a batch:

SELECT INTERFACE_LINE_ID, BID_NUMBER, LINE_NUMBER, PRICE_ELEMENT_NAME, BID_CURRENCY_VALUE FROM PON_BID_PRICE_ELEMENTS_INT WHERE BATCH_ID = :batch_id;
Joining to PON_AUCTION_HEADERS_ALL on AUCTION_HEADER_ID to confirm the target auction.
Joining to PON_PRICE_ELEMENT_TYPES on PRICE_ELEMENT_TYPE_ID to resolve element descriptions.

Reporting use cases include summarizing bid amounts by price element type and analyzing currency-versus-auction value variances to detect conversion discrepancies.

Related Objects

PON_AUCTION_HEADERS_ALL – Referenced via AUCTION_HEADER_ID; parent auction definition.
PON_PRICE_ELEMENT_TYPES – Referenced via PRICE_ELEMENT_TYPE_ID; element category lookup.
Base bid price element tables populated by the interface program.
Concurrent interface/import programs that consume BATCH_ID groupings.

Together these objects form the inbound path for supplier bid cost breakdowns in Oracle Sourcing.

Table: PON_BID_PRICE_ELEMENTS_INT 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PRICE_ELEMENTS_INT, object_name:PON_BID_PRICE_ELEMENTS_INT, status:VALID, product: PON - Sourcing , description: Interface table for price element , implementation_dba_data: PON.PON_BID_PRICE_ELEMENTS_INT ,
Table: PON_BID_PRICE_ELEMENTS_INT 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PRICE_ELEMENTS_INT, object_name:PON_BID_PRICE_ELEMENTS_INT, status:VALID, product: PON - Sourcing , description: Interface table for price element , implementation_dba_data: PON.PON_BID_PRICE_ELEMENTS_INT ,
SYNONYM: APPS.PON_BID_PRICE_ELEMENTS_INT 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PRICE_ELEMENTS_INT, status:VALID,
VIEW: PON.PON_BID_PRICE_ELEMENTS_INT# 12.2.2
owner:PON, object_type:VIEW, object_name:PON_BID_PRICE_ELEMENTS_INT#, status:VALID,
SYNONYM: APPS.PON_BID_PRICE_ELEMENTS_INT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PRICE_ELEMENTS_INT, status:VALID,
VIEW: PON.PON_BID_PRICE_ELEMENTS_INT# 12.2.2
TABLE: PON.PON_BID_PRICE_ELEMENTS_INT 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PRICE_ELEMENTS_INT, object_name:PON_BID_PRICE_ELEMENTS_INT, status:VALID,
TABLE: PON.PON_BID_PRICE_ELEMENTS_INT 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PRICE_ELEMENTS_INT, object_name:PON_BID_PRICE_ELEMENTS_INT, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
PACKAGE BODY: APPS.PON_RESPONSE_IMPORT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_RESPONSE_IMPORT_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PON_RESPONSE_IMPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_RESPONSE_IMPORT_PKG, status:VALID,
12.2.2 FND Design Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG SQL Statements 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.PON_RESPONSE_IMPORT_PKG 12.1.1
PACKAGE BODY: APPS.PON_RESPONSE_IMPORT_PKG 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_ELEMENTS_INT 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_ELEMENTS_INT 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_ELEMENTS 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_ELEMENTS 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_PRICE_ELEMENTS 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_PRICE_ELEMENTS 12.2.2
eTRM - PON Tables and Views 12.1.1
description: Holds the debug statements for workflow processes ,
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_PRICE_ELEMENT_TYPES_TL 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_PRICE_ELEMENT_TYPES_TL 12.2.2
eTRM - PON Tables and Views 12.2.2
description: Holds the debug statements for workflow processes ,
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ITEM_PRICES_INTERFACE 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ITEM_PRICES_INTERFACE 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ITEM_PRICES 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_DIFFER_INT 12.1.1
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_PRICE_DIFFER_INT 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ITEM_PRICES 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ATTR_VALUES_INTERFACE 12.2.2
APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ATTR_VALUES_INTERFACE 12.1.1
eTRM - PON Tables and Views 12.1.1
description: Holds the debug statements for workflow processes ,
eTRM - PON Tables and Views 12.2.2
description: Holds the debug statements for workflow processes ,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1