Search Results pon_attribute_scores_uk

Overview

The PON_ATTRIBUTE_SCORES table is a core data object within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It functions as the repository for scoring criteria defined for attributes within a sourcing negotiation, such as a reverse auction or RFx. When buyers configure weighted scoring for non-price attributes (e.g., quality, delivery time, warranty) to evaluate supplier responses objectively, the system persists those scoring rules in this table. Its role is critical for the automated calculation of total scores for supplier bids, enabling a quantitative and consistent evaluation process beyond just the bid price.

Key Information Stored

The table stores the relationships and parameters that link scoring rules to specific attributes within an auction. As defined by its primary key (PON_ATTRIBUTE_SCORES_UK), the table's structure is anchored to several key identifiers. The ATTRIBUTE_LIST_ID is a fundamental column, tying the scoring criteria to a specific list of attributes. The AUCTION_HEADER_ID associates the rules with a particular sourcing event, while LINE_NUMBER and ATTRIBUTE_SEQUENCE_NUMBER pinpoint the specific auction line and attribute within that line, respectively. The SEQUENCE_NUMBER allows for multiple scoring intervals or rules for a single attribute. Typical data stored includes score values assigned to specific attribute response ranges (e.g., a score of 10 for a delivery time of 7 days, 5 for 14 days), enabling linear or step-based scoring models.

Common Use Cases and Queries

Primary use cases involve reporting on scoring configurations and debugging bid evaluation results. A common query retrieves all scoring rules for a specific auction to verify the evaluation setup. For example:

• SELECT * FROM pon_attribute_scores WHERE auction_header_id = :p_auction_id ORDER BY line_number, attribute_sequence_number, sequence_number;

Another frequent scenario is tracing the score contribution of a specific attribute across all bids, which requires joining with bid response tables like PON_BID_ATTRIBUTE_SCORES. Queries also often filter by ATTRIBUTE_LIST_ID to understand how a master attribute list is applied with scoring across different auctions. Administrators may run scripts to identify auctions where critical attributes have no associated scoring rules, potentially indicating a configuration gap.

Related Objects

This table is central to the Sourcing scoring engine and has strong relationships with other PON tables. It is directly linked to PON_ATTRIBUTES_INTERFACE and PON_AUCTION_ATTRIBUTES, which define the attributes themselves. The actual scores calculated for supplier bids based on these rules are stored in PON_BID_ATTRIBUTE_SCORES. The table is a child of the auction header (PON_AUCTION_HEADERS_ALL) via AUCTION_HEADER_ID. For comprehensive reporting, views such as PON_SCORING_CRITERIA_V often aggregate data from this table with descriptive information from related attribute and auction tables.