Search Results pon_team_member_bid_scores




Overview
Explore in AI Chat

Overview

The PON_TEAM_MEMBER_BID_SCORES table is a core data repository within the Oracle E-Business Suite Sourcing (PON) module, specifically for negotiations that utilize team-based evaluation. Its primary role is to persist the individual scoring assessments performed by each designated team member on supplier responses (bids) during a sourcing event. This table is essential for enabling collaborative scoring workflows, where multiple evaluators assess the same bid, allowing for the aggregation of scores and a more comprehensive evaluation process. The table records not only the score itself but also the status of the evaluation and the date it was performed, providing a complete audit trail for each team member's contribution to the bid assessment.

Key Information Stored

While the provided metadata does not list specific column names beyond the primary and foreign keys, the structure and description indicate the table stores critical evaluation data. The composite primary key, consisting of BID_NUMBER and USER_ID, uniquely identifies a scoring record for a specific bid by a specific team member. The table links to the sourcing negotiation header via AUCTION_HEADER_ID and to the specific supplier bid via BID_NUMBER. Based on its described purpose, the table's important data elements include the evaluator's score for the bid, the date the score was submitted (SCORE_DATE), and a status field (e.g., SCORE_STATUS) indicating whether the evaluation is draft, submitted, or approved. It serves as the transactional foundation for calculating an overall bid score from multiple evaluators.

Common Use Cases and Queries

A primary use case is generating reports on the progress and results of team scoring for a negotiation. Sourcing analysts often need to identify which bids have been fully evaluated and which are pending reviews from specific team members. Common SQL queries involve joining this table with supplier and user information to create evaluation status dashboards or to calculate final aggregated scores for award decisions.

  • Evaluation Status Report: SELECT pah.auction_header_id, pbh.bid_number, fu.user_name, ptmbs.score_date, ptmbs.score_status FROM pon_team_member_bid_scores ptmbs JOIN pon_auction_headers_all pah ON ptmbs.auction_header_id = pah.auction_header_id JOIN pon_bid_headers pbh ON ptmbs.bid_number = pbh.bid_number JOIN fnd_user fu ON ptmbs.user_id = fu.user_id WHERE pah.auction_header_id = :p_auction_id ORDER BY pbh.bid_number, fu.user_name;
  • Aggregate Score Calculation: Queries often use aggregate functions like AVG or SUM on the score column, grouped by BID_NUMBER, to compute the final team score for each bid, which is then used for ranking and analysis.

Related Objects

The PON_TEAM_MEMBER_BID_SCORES table is centrally connected to other key Sourcing entities through documented foreign key relationships. These relationships are fundamental for any data extraction or integration involving team scores.

  • PON_AUCTION_HEADERS_ALL: Joined via AUCTION_HEADER_ID. This links the team scores to the parent negotiation (sourcing event).
  • PON_BID_HEADERS: Joined via BID_NUMBER. This links the scores to the specific supplier response being evaluated.
  • FND_USER: Joined via USER_ID. This links the scoring record to the Oracle EBS user account of the evaluating team member, providing access to the person's name and other details.
  • Table: PON_TEAM_MEMBER_BID_SCORES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_BID_SCORES,  object_name:PON_TEAM_MEMBER_BID_SCORES,  status:VALID,  product: PON - Sourcing ,  description: For negotiations enabled for team scoring, this table stores the evaluation for the responses on this negotiation for each team member. The table also records the date the response was scored and current score statusFor negotiations enabled ,  implementation_dba_data: PON.PON_TEAM_MEMBER_BID_SCORES , 

  • Table: PON_TEAM_MEMBER_BID_SCORES 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_BID_SCORES,  object_name:PON_TEAM_MEMBER_BID_SCORES,  status:VALID,  product: PON - Sourcing ,  description: For negotiations enabled for team scoring, this table stores the evaluation for the responses on this negotiation for each team member. The table also records the date the response was scored and current score statusFor negotiations enabled ,  implementation_dba_data: PON.PON_TEAM_MEMBER_BID_SCORES , 

  • Table: PON_BID_HEADERS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_HEADERS,  object_name:PON_BID_HEADERS,  status:VALID,  product: PON - Sourcing ,  description: Contains header level data for a response to a negotiation ,  implementation_dba_data: PON.PON_BID_HEADERS , 

  • Table: PON_BID_HEADERS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_HEADERS,  object_name:PON_BID_HEADERS,  status:VALID,  product: PON - Sourcing ,  description: Contains header level data for a response to a negotiation ,  implementation_dba_data: PON.PON_BID_HEADERS , 

  • Table: PON_AUCTION_HEADERS_ALL 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_HEADERS_ALL,  object_name:PON_AUCTION_HEADERS_ALL,  status:VALID,  product: PON - Sourcing ,  description: Stores the negotiations header level details. ,  implementation_dba_data: PON.PON_AUCTION_HEADERS_ALL , 

  • Table: PON_AUCTION_HEADERS_ALL 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_HEADERS_ALL,  object_name:PON_AUCTION_HEADERS_ALL,  status:VALID,  product: PON - Sourcing ,  description: Stores the negotiations header level details. ,  implementation_dba_data: PON.PON_AUCTION_HEADERS_ALL ,