Results for “pon_bid_price_elements”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_BID_PRICE_ELEMENTS is a transactional table in the Oracle E-Business Suite Sourcing (PON) module. It stores the price element bid details that suppliers submit in response to an auction or a Request for Quotation (RFQ). Each row captures how a bidder priced a specific line for a given price element—such as materials, labor, overhead, or freight—within a sourcing event. The table therefore serves as the granular price-component layer beneath the pricing header and line information held in the sibling bid tables.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is characterized as standalone. In modeling terms, this suggests the table behaves primarily as a satellite capturing descriptive and measurable bid attributes keyed by business identifiers, rather than as a hub or link. The presence of a single documented foreign key to PON_AUCTION_HEADERS_ALL supports a narrow, event-centric dependency rather than a broad integration hub.

Key Information Stored

The table is owned by the PON schema and contains 21 documented columns in the 12.2.2 physical schema. The primary key is PON_BID_PRICE_ELEMENTS_PK1, defined over the composite business key (BID_NUMBER, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID). A unique index, PON_BID_PRICE_ELEMENTS_U1, mirrors this same column set, confirming it as the business-key candidate that guarantees one price element entry per bid line.

• BID_NUMBER – the bid identifier; part of the composite primary key and unique index.
• LINE_NUMBER – the auction or RFQ line for which the price element applies; part of the composite key.
• PRICE_ELEMENT_TYPE_ID – identifies the type of price element (e.g., material, labor); part of the composite key.
• AUCTION_HEADER_ID – foreign key linking the row to PON_AUCTION_HEADERS_ALL, tying the price element to its parent sourcing event.
• PRICING_BASIS – indicates the basis on which the price element is priced.
• AUCTION_CURRENCY_VALUE – the value expressed in the auction's currency.
• BID_CURRENCY_VALUE – the value expressed in the bidder's currency.
• OLD_BID_CURRENCY_VALUE – the prior bid currency value, retained for comparison and audit of revisions.
• NEGATIVE_COST_FACTOR_FLAG – flag indicating whether the cost factor is negative.
• PF_TYPE – the price-factor type associated with the element.
• SEQUENCE_NUMBER – ordering attribute for the element within its line.
• INTERFACE_LINE_ID – reference used when rows are populated through interface processing.
• BATCH_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – concurrent program and batch control columns supporting bulk loads and interface runs.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY – standard audit columns.

Common Use Cases and Queries

Primary use cases include bid analysis, price-element comparison across suppliers, and reporting on how individual cost components contributed to a total bid. A representative query joins the table to its parent header on the auction identifier:

• Reporting the price elements for a specific bid: SELECT bid_number, line_number, price_element_type_id, bid_currency_value FROM pon_bid_price_elements WHERE bid_number = :bid;
• Aggregating element values by event: join AUCTION_HEADER_ID to PON_AUCTION_HEADERS_ALL and group by line to reconcile element totals against the bid line value.
• Auditing revisions: compare OLD_BID_CURRENCY_VALUE with BID_CURRENCY_VALUE to detect changed pricing across bid revisions.
• Currency analysis: use AUCTION_CURRENCY_VALUE versus BID_CURRENCY_VALUE to review converted amounts.

Related Objects

The most significant related object is the parent header table referenced by the documented foreign key. Additional related tables include the bid line and header tables in the PON schema with which this object is commonly joined for complete bid reporting.

• PON_AUCTION_HEADERS_ALL – parent table joined on AUCTION_HEADER_ID.
• PON_BID_HEADERS – bid-level header information joined on BID_NUMBER.
• PON_BID_LINES – line-level bid detail joined on BID_NUMBER and LINE_NUMBER.
• PON_PRICE_ELEMENTS / PON_PRICE_ELEMENT_TYPES – definitions resolved via PRICE_ELEMENT_TYPE_ID.
• PON_AUCTION_HEADERS – the operational header view used in auction sourcing flows.