Results for “pon_award_items_interface”

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

Overview

PON_AWARD_ITEMS_INTERFACE is a temporary staging table in the PON (Sourcing) schema of Oracle E-Business Suite. Its documented purpose is to transfer award data from an external spreadsheet into the negotiation award tables during the auction or negotiation award process. Buyers or sourcing administrators populate this interface with the lines and quantities they intend to award to specific suppliers, and a concurrent program subsequently validates and moves the records into the permanent award structures.

The table resides in the PON schema and holds eleven documented columns in ETRM 12.2.2. Its structure is keyed by a composite of AUCTION_LINE_NUMBER, BATCH_ID, and BID_NUMBER, which together define a unique row within a given loading batch. This composite key reflects the table's nature as a transient collection of award decisions attached to a specific negotiation, bid, and line combination.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning. It should be modeled as a satellite capturing descriptive award attributes (quantity, status, rejection reason, shipment) rather than as a hub or link. The composite business key of auction line, batch, and bid functions as the parent reference, with the remaining columns representing the measured or descriptive payload of the satellite.

Key Information Stored

The most significant columns include the following:

• BATCH_ID — Part of the composite primary key; identifies the specific interface load or submission run, enabling parallel or repeated loads without collision.
• AUCTION_LINE_NUMBER — Part of the composite primary key; the negotiation line to which the award applies. It also participates in the foreign key to PON_BID_ITEM_PRICES.
• BID_NUMBER — Part of the composite primary key; identifies the supplier bid from which the award line originates.
• AUCTION_HEADER_ID — Foreign key to PON_AUCTION_HEADERS_ALL; the negotiation header to which the award belongs.
• AWARD_QUANTITY — The quantity the buyer intends to award for the line; a core business measure.
• AWARD_STATUS — The current processing or award disposition of the interface line.
• AWARDREJECT_REASON — Free-text or coded reason a line was rejected during award processing.
• AWARD_SHIPMENT_NUMBER — Distinguishes shipment-level award detail where partial or split shipment awards apply.
• INTERFACE_LINE_ID — Surrogate identifier for the interface row, used for row-level tracking during validation and error reporting.
• WORKSHEET_NAME and WORKSHEET_SEQUENCE_NUMBER — Identify the source spreadsheet worksheet and its ordering, preserving lineage from the uploaded file.

The surrogate primary key is the composite (AUCTION_LINE_NUMBER, BATCH_ID, BID_NUMBER). No separate unique business-key index is documented beyond this composite constraint.

Common Use Cases and Queries

The table is primarily consumed by the award interface import process. Typical queries include retrieving award quantities for a specific negotiation and batch, and reconciling records loaded from a spreadsheet against the negotiation's bid lines.

• Retrieve award lines for a batch: SELECT * FROM PON_AWARD_ITEMS_INTERFACE WHERE BATCH_ID = :batch_id;
• Join to bid item prices to reconcile award quantities against quoted prices: SELECT i.AUCTION_LINE_NUMBER, i.AWARD_QUANTITY, p.PRICE FROM PON_AWARD_ITEMS_INTERFACE i, PON_BID_ITEM_PRICES p WHERE i.AUCTION_LINE_NUMBER = p.AUCTION_LINE_NUMBER AND i.BID_NUMBER = p.BID_NUMBER;
• Identify rejected lines for a batch: SELECT INTERFACE_LINE_ID, AUCTION_LINE_NUMBER, AWARDREJECT_REASON FROM PON_AWARD_ITEMS_INTERFACE WHERE AWARD_STATUS = 'REJECTED';
• Confirm all interface rows for a negotiation before launching the award program: SELECT COUNT(*) FROM PON_AWARD_ITEMS_INTERFACE WHERE AUCTION_HEADER_ID = :header_id AND BATCH_ID = :batch_id;

Related Objects

The most significant related objects, based on the documented foreign key and dependency structure, are:

• PON_BID_ITEM_PRICES — Referenced via AUCTION_LINE_NUMBER and BID_NUMBER; holds bid line pricing used to validate award quantities.
• PON_AUCTION_HEADERS_ALL — Referenced via AUCTION_HEADER_ID; the parent negotiation header.
• PON_AWARD_ITEMS — The permanent target table populated from this interface during award processing.
• The negotiation award concurrent program that reads this table, validates rows, and writes to the award tables.
• Spreadsheet integration templates used by buyers to produce the worksheet files referenced by WORKSHEET_NAME and WORKSHEET_SEQUENCE_NUMBER.