Search Results pon_auction_summary_s

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

Overview

PON_BUYER_SUMMARY_PKG is a PL/SQL package body in the Oracle E-Business Suite Procurement module (APPS schema) that supports buyer-facing summary reporting for sourcing and auction events. Its primary role is to compute and persist summary metrics for a buyer associated with a given auction, aggregating information drawn from auction headers, auction item prices, and submitted bid data. The package is documented in the ETRM reference at version 12.1.1 and 12.2.2 with an API classification of OTHER, indicating it is an internal supporting utility rather than a published open interface. The user search token "PBI-7196" typically corresponds to an internal bug or enhancement reference tied to this object's behavior during sourcing award processing.

Key Procedures and Functions

The package exposes two documented program units:

• CALCULATE_SUMMARY — The core procedure. Based on the visible source excerpt, it accepts an auction header identifier and returns a generated batch identifier (drawn from the PON_AUCTION_SUMMARY_S sequence). It declares cursors to iterate awardable group types (LOT, LINE, GROUP_LINE) over PON_AUCTION_ITEM_PRICES_ALL, and a second cursor that joins bid headers, bid item prices, auction headers, trading partners, and vendor records to evaluate active, shortlisted bids. The procedure ranks bids using a price-only or weighted-score-to-price ratio and drives the assembly of buyer-level summary rows. Parameter lists beyond the auction identifier and batch output identifier should not be assumed.
• BID_COUNT_INFO — A supplementary routine that provides bid count information used in the buyer summary context, drawing on the same bidding party and bid header data. Its precise parameter signature is not reproduced in the available metadata.

Tables Accessed

The package reads and writes these documented objects via APPS synonyms:

• PON_AUCTION_HEADERS_ALL — source of auction type and bid ranking rules that govern ranking logic.
• PON_AUCTION_ITEM_PRICES_ALL — auction line and lot level pricing, quantity, and group type data.
• PON_BID_HEADERS and PON_BID_ITEM_PRICES — active, shortlisted supplier bid and price lines used for ranking and counting.
• PON_BIDDING_PARTIES — trading partner participation records.
• HZ_PARTIES and PON_AUCTION_SUMMARY / PON_AUCTION_SUMMARY_S — supplier organization validation and the target summary table plus its sequence.
• DUAL — used to obtain the next batch identifier.

Usage Notes

PON_BUYER_SUMMARY_PKG is invoked internally during sourcing auction evaluation and award workflows. It is not referenced by other documented packages, confirming it operates as a leaf-level utility rather than a shared framework component. Typical invocation occurs from Oracle Sourcing buyer summary pages, auction award processing logic, or concurrent programs that build buyer summary snapshots. Because the package writes to PON_AUCTION_SUMMARY using a sequence-generated batch identifier, it should not be called concurrently for the same auction header without appropriate locking. Customizations should treat CALCULATE_SUMMARY and BID_COUNT_INFO as internal APIs subject to change between EBS releases, and any enhancement addressing defect reference PBI-7196 should be validated against the 12.1.1 and 12.2.2 code lines separately, since the package is flagged with an older 120.1 header revision.