Results for “award_status_name”

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

Overview

PON_BID_ITEM_PRICES is a transactional table in the Oracle EBS Sourcing (PON) module that stores the line-level pricing responses submitted by suppliers in response to a negotiation, whether that negotiation is an auction, an RFQ, or a formal bid event. Each row captures one supplier's price and commercial commitment for a specific auction or bid line, forming the operational backbone of supplier response evaluation, scoring, and downstream award processing. The table resides in the PON schema and is documented as valid across EBS 12.1.1 and 12.2.2, carrying 138 columns in the 12.2.2 physical schema.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. It records descriptive, time-stamped, and attribute-heavy state about supplier responses rather than acting as a pure hub of business keys or a pure link of relationships. The surrogate primary key PON_BID_ITEM_PRICES_PK is composite, comprising AUCTION_LINE_NUMBER and BID_NUMBER, which together uniquely identify a supplier's response line within a negotiation.

Key Information Stored

The dominant business keys are BID_NUMBER (identifying the supplier's bid header) and LINE_NUMBER and AUCTION_LINE_NUMBER (identifying the line within the negotiation). A unique index, PON_BID_ITEM_PRICES_U1, on (BID_NUMBER, LINE_NUMBER), reinforces this as a business-key candidate distinct from the surrogate primary key. AUCTION_HEADER_ID links the response line to its parent negotiation.

Pricing and commercial attributes are central: PRICE, UNIT_PRICE, BID_CURRENCY_PRICE, BID_CURRENCY_UNIT_PRICE, MINIMUM_BID_PRICE, PROXY_BID_LIMIT_PRICE, PROXY_BID_FLAG, FIRST_BID_PRICE, and UNIT_OF_MEASURE carry the quoted values and any automated proxy-bidding thresholds. Quantity and delivery commitments appear in QUANTITY, PROMISED_DATE, AWARD_QUANTITY, and AWARD_PRICE, while AWARD_STATUS and AWARD_DATE track the award lifecycle.

Evaluation and ranking metadata include TOTAL_WEIGHTED_SCORE and RANK, which support supplier comparison across lines. Structural line context is captured through AUCTION_LINE_TYPE, AUCTION_LOT_LINE_NUMBER, LOT_LINE_NUMBER, and LINE_TYPE_ID. Payment and contract-oriented columns such as ADVANCE_AMOUNT, RECOUPMENT_RATE_PERCENT, PROGRESS_PYMT_RATE_PERCENT, RETAINAGE_RATE_PERCENT, and MAX_RETAINAGE_AMOUNT support complex commercial terms. Standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and concurrent-program columns (REQUEST_ID, PROGRAM_ID, BATCH_ID, INTERFACE_LINE_ID) are also present, the latter enabling interface and bulk-processing flows.

Common Use Cases and Queries

Typical reporting scenarios include isolating all responses for a negotiation, ranking suppliers by weighted score, and analyzing bid price trends across rounds. The following pattern retrieves ranked supplier responses for a given bid:

• SELECT b.BID_NUMBER, b.LINE_NUMBER, b.PRICE, b.UNIT_PRICE, b.TOTAL_WEIGHTED_SCORE, b.RANK, b.AWARD_STATUS FROM PON_BID_ITEM_PRICES b WHERE b.AUCTION_HEADER_ID = :header_id ORDER BY b.LINE_NUMBER, b.RANK;
• Award analysis joins AWARD_QUANTITY and AWARD_PRICE to compare awarded versus quoted values, supporting savings and negotiation-effectiveness reporting.
• Proxy-bid monitoring filters on PROXY_BID_FLAG and PROXY_BID_LIMIT_PRICE to audit automated bidding activity.
• Price-history investigations use OLD_PRICE, OLD_QUANTITY, and the OLD_* columns to reconstruct prior-round values and detect revisions.
• Load and interface reconciliation queries key on REQUEST_ID, BATCH_ID, or INTERFACE_LINE_ID to trace bulk uploads or conversions.

Related Objects

PON_BID_ITEM_PRICES sits within a tightly related Sourcing schema. Its documented foreign key relationships anchor it to the following significant objects:

• PON_BID_HEADERS — joined via PON_BID_ITEM_PRICES.BID_NUMBER = PON_BID_HEADERS.BID_NUMBER, providing the supplier bid header context.
• PON_AUCTION_ITEM_PRICES_ALL — joined via LINE_NUMBER and AUCTION_HEADER_ID, supplying the negotiation-side line definition and pricing template.
• PON_AUCTION_HEADERS_ALL — referenced through AUCTION_HEADER_ID, holding the parent negotiation header.
• PON_AWARD_ITEMS_INTERFACE — referencing this table through AUCTION_LINE_NUMBER and BID_NUMBER, the conduit for pushing awarded lines toward purchasing documents.

Together these relationships position PON_BID_ITEM_PRICES as the central fact-bearing satellite of supplier responses, bridging negotiation definitions, bid headers, and award interfaces within the EBS Sourcing and Procurement lifecycle.