Search Results pon_scoring_teams




Overview
Explore in AI Chat

Overview

PON_SCORING_TEAMS is a table in the PON (Sourcing) module of Oracle E-Business Suite, residing in the PON schema. It stores information about scoring teams that may be created optionally for a negotiation. A scoring team is a group of collaboration team members who are assigned the responsibility of evaluating various negotiation attribute groups. The table is valid in both Oracle EBS 12.1.1 and 12.2.2 and is central to the structured evaluation of supplier responses in auctions and other sourcing negotiations.

From a Data Vault modeling perspective, the heuristic classification of this table is hub-leaning. This suggests that PON_SCORING_TEAMS functions primarily as a hub entity, representing the scoring team as a distinct business concept, keyed by its own identifier and linked outward to the negotiation and to its member and section detail tables. Analysts designing a dimensional or Data Vault model from the EBS schema may treat TEAM_ID as the hub key, with AUCTION_HEADER_ID acting as a foreign reference to the negotiation hub.

Key Information Stored

The table contains 11 documented columns. The most significant include:

The surrogate primary key (TEAM_ID) should be distinguished from the composite business-key candidate (AUCTION_HEADER_ID, TEAM_ID), which conveys the negotiation context of each team.

Common Use Cases and Queries

Typical usage involves identifying the scoring teams configured for a given negotiation, determining which teams can see pricing, and tracing team membership and evaluated attribute sections.

  • List all scoring teams for an auction: SELECT team_id, team_name, price_visible_flag FROM pon_scoring_teams WHERE auction_header_id = :auction_header_id;
  • Retrieve evaluation instructions and audit ownership: SELECT team_name, instruction_text, created_by, creation_date FROM pon_scoring_teams WHERE team_id = :team_id;
  • Trace team members and section assignments by joining to PON_SCORING_TEAM_MEMBERS and PON_SCORING_TEAM_SECTIONS on TEAM_ID.
  • Reporting on scoring team participation across negotiations, joining to PON_AUCTION_HEADERS_ALL for negotiation context.

Related Objects

The following objects are most significant in relation to PON_SCORING_TEAMS, based on documented foreign key relationships:

  • PON_AUCTION_HEADERS_ALL — Referenced by PON_SCORING_TEAMS.AUCTION_HEADER_ID; provides the parent negotiation.
  • PON_SCORING_TEAMS (self-reference) — ORIG_TEAM_ID links a team to a source team.
  • PON_SCORING_TEAM_MEMBERS — References TEAM_ID; stores the collaboration members assigned to each scoring team.
  • PON_SCORING_TEAM_SECTIONS — References TEAM_ID; defines the attribute groups or sections a team evaluates.
  • PON_THREAD_ENTRIES — References SCORING_TEAM_ID; stores discussion thread entries associated with a scoring team.