Search Results download transworld for pc




The PON_TEAM_MEMBER_BID_SCORES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Oracle Sourcing module, specifically supporting the supplier bidding and evaluation processes. This table stores scoring details assigned by team members to supplier bids during the negotiation and evaluation phases of strategic sourcing events. Below is a detailed analysis of its purpose, structure, and functional significance.

Purpose and Context

The PON_TEAM_MEMBER_BID_SCORES table is designed to capture individual evaluations of supplier bids by members of an internal evaluation team. In Oracle Sourcing, negotiations (such as RFQs or auctions) often involve multiple stakeholders who assess bids based on predefined criteria (e.g., price, quality, delivery terms). This table enables a collaborative scoring mechanism, ensuring transparency and auditability in supplier selection.

Key Columns and Structure

The table typically includes the following columns, though specific implementations may vary:
  • AUCTION_HEADER_ID: Foreign key linking to PON_AUCTION_HEADERS_ALL, identifying the sourcing event.
  • BID_NUMBER: References PON_BIDS, associating scores with a specific supplier bid.
  • TEAM_MEMBER_ID: Links to PER_ALL_PEOPLE_F or similar HR tables, identifying the evaluator.
  • SCORE: Numeric value representing the assigned score (e.g., 1-100).
  • SCORING_CRITERIA_ID: Foreign key to PON_SCORING_CRITERIA, indicating the evaluated criterion.
  • CREATION_DATE and LAST_UPDATE_DATE: Audit columns for tracking changes.
  • COMMENTS: Optional field for evaluator notes.

Integration with Other Modules

The table integrates with:
  • Sourcing Negotiations: Scores feed into bid analysis reports and award decisions.
  • Supplier Performance: Historical scores may influence future supplier evaluations.
  • Workflow: Triggers notifications if scores deviate from thresholds.

Functional Workflow

  1. Bid Submission: Suppliers submit bids via Oracle Sourcing.
  2. Evaluation: Team members access bids through the UI, scoring them against predefined criteria.
  3. Aggregation: Scores are aggregated (e.g., averaged) in PON_BID_SCORES for final comparison.
  4. Awarding: Procurement teams use consolidated scores to select winning bids.

Technical Considerations

  • Indexing: Columns like AUCTION_HEADER_ID and BID_NUMBER are typically indexed for performance.
  • Security: Data is subject to Oracle's VPD (Virtual Private Database) policies, restricting access by responsibility.
  • Customizations: Organizations may extend the table to include additional scoring dimensions.

Reporting and Analytics

The table supports:
  • Real-time dashboards showing bid competitiveness.
  • Historical trend analysis of supplier performance.
  • Compliance reports for audit purposes.

Conclusion

The PON_TEAM_MEMBER_BID_SCORES table is a cornerstone of Oracle Sourcing's collaborative evaluation framework. By enabling granular, multi-stakeholder bid assessments, it ensures data-driven decision-making in procurement processes. Its design reflects Oracle EBS's emphasis on configurability, auditability, and integration with broader supply chain workflows.

  • Lookup Type: PON_DOWNLOAD_REQ_TYPES 12.2.2

    product: PON - Sourcing ,  meaning: PON: Download Requests Types ,  description: PON: Download Requests Types , 

  • Concurrent Program: PON_DOWLOAD_PDF 12.1.1

    execution_filename: DownloadNegotiationPdfCp ,  product: PON - Sourcing ,  user_name: Download negotiation for Super Large Negotiation ,  description: Download the PDF for a super large negotiation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PON_DOWLOAD_PDF 12.2.2

    execution_filename: DownloadNegotiationPdfCp ,  product: PON - Sourcing ,  user_name: Download negotiation for Super Large Negotiation ,  description: Download the PDF for a super large negotiation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PON_CLM_DOWNLOAD_PDF 12.2.2

    execution_filename: DownloadCLMNegoPdfCp ,  product: PON - Sourcing ,  user_name: Download CLM Negotiation PDF ,  description: Download the PDF for CLM Documents ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PON_LINES_DOWNLOAD 12.1.1

    execution_filename: ExportNegotiationCp ,  product: PON - Sourcing ,  user_name: Export lines for Super Large Negotiation ,  description: Download the new lines/amendment lines for super large negotiations ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PON_LINES_DOWNLOAD 12.2.2

    execution_filename: ExportNegotiationCp ,  product: PON - Sourcing ,  user_name: Export lines for Super Large Negotiation ,  description: Download the new lines/amendment lines for super large negotiations ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: PON_DOWNLOAD_REQ_TYPES 12.1.1

    product: PON - Sourcing ,  meaning: PON: Download Requests Types ,  description: PON: Download Requests Types , 

  • Concurrent Program: PON_DOWNLOAD_SHIPMENTS 12.2.2

    execution_filename: ExportShipmentCp ,  product: PON - Sourcing ,  user_name: Export Price Tiers for Super Large Negotiation ,  description: Export Price Tiers for Super Large Negotiation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: PON_NOTIF_SUBSCRIPTIONS 12.2.2

    product: PON - Sourcing ,  meaning: Notification Groups Definition ,  description: Notification Groups Definition , 

  • Lookup Type: PON_NOTIF_SUBSCRIPTIONS 12.1.1

    product: PON - Sourcing ,  meaning: Notification Groups Definition ,  description: Notification Groups Definition , 

  • Concurrent Program: PON_PUBLISH_BID_CP 12.1.1

    execution_filename: PON_RESPONSE_PVT.PUBLISH_CP ,  product: PON - Sourcing ,  user_name: Publish bid for Super Large Negotiation ,  description: Concurrent program to publish a bid for super large negotiations ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PON_PUBLISH_BID_CP 12.2.2

    execution_filename: PON_RESPONSE_PVT.PUBLISH_CP ,  product: PON - Sourcing ,  user_name: Publish bid for Super Large Negotiation ,  description: Concurrent program to publish a bid for super large negotiations ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PON_VALIDATE_DRAFT_BID_CP 12.2.2

    execution_filename: PON_RESPONSE_PVT.VALIDATE_CP ,  product: PON - Sourcing ,  user_name: Validate draft bid for Super Large Negotiation ,  description: Concurrent program to validate a draft bid for a super large negotiation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • 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 , 

  • Concurrent Program: PON_VALIDATE_DRAFT_BID_CP 12.1.1

    execution_filename: PON_RESPONSE_PVT.VALIDATE_CP ,  product: PON - Sourcing ,  user_name: Validate draft bid for Super Large Negotiation ,  description: Concurrent program to validate a draft bid for a super large negotiation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • 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 , 

  • Lookup Type: PON_ACTIVE_INACTIVE 12.2.2

    product: PON - Sourcing ,  meaning: PON: Active Inactive YN ,  description: Used for tables that store Y for Active and N for Inactive , 

  • Lookup Type: PON_ACTIVE_INACTIVE 12.1.1

    product: PON - Sourcing ,  meaning: PON: Active Inactive YN ,  description: Used for tables that store Y for Active and N for Inactive , 

  • Concurrent Program: PON_FBO_XML_GENERATION 12.2.2

    execution_filename: GenerateFboXmlCp ,  product: PON - Sourcing ,  user_name: Generate notices for FedBizOpps posting ,  description: Generate notices for FedBizOpps posting ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PON_IMPORT_LINES 12.1.1

    execution_filename: ImportNegotiationCp ,  product: PON - Sourcing ,  user_name: Import Super Large Spreadsheet for Negotiation Creation ,  description: Import Negotiation Lines ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: PON_IMPORT_LINES 12.2.2

    execution_filename: ImportNegotiationCp ,  product: PON - Sourcing ,  user_name: Import Super Large Spreadsheet for Negotiation Creation ,  description: Import Negotiation Lines ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Lookup Type: PON_UNSOL_LINK_SEARCH 12.2.2

    product: PON - Sourcing ,  meaning: PON : Unsolicited lines link type to the solicited lines ,  description: Search options for Unsolicited lines link type to the solicited lines , 

  • Lookup Type: PON_FEDERAL_PUBLICATION 12.2.2

    product: PON - Sourcing ,  meaning: PON: Federal Publication Exception ,  description: PON: Federal Publication Exception , 

  • Table: PON_LARGE_NEG_PF_VALUES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_LARGE_NEG_PF_VALUES,  object_name:PON_LARGE_NEG_PF_VALUES,  status:VALID,  product: PON - Sourcing ,  description: This table stores the buyer price factor values for a given supplier for a large negotiation ,  implementation_dba_data: PON.PON_LARGE_NEG_PF_VALUES , 

  • Table: PON_LARGE_NEG_PF_VALUES 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_LARGE_NEG_PF_VALUES,  object_name:PON_LARGE_NEG_PF_VALUES,  status:VALID,  product: PON - Sourcing ,  description: This table stores the buyer price factor values for a given supplier for a large negotiation ,  implementation_dba_data: PON.PON_LARGE_NEG_PF_VALUES , 

  • Table: PON_APPLICATION_LOGO 12.1.1

    product: PON - Sourcing ,  description: Stores details for obtaining the logo for an application. ,  implementation_dba_data: Not implemented in this database , 

  • Table: PON_APPLICATION_LOGO 12.2.2

    product: PON - Sourcing ,  description: Stores details for obtaining the logo for an application. ,  implementation_dba_data: Not implemented in this database , 

  • Lookup Type: PON_GROUP_TYPE 12.1.1

    product: PON - Sourcing ,  meaning: Group Types for Auction Lines ,  description: Group Types for Auction Lines , 

  • Lookup Type: PON_MAPPING_RESPONSE_TYPE 12.2.2

    product: PON - Sourcing ,  meaning: Response Type for Attributes Mapping ,  description: Response Type for Attributes Mapping , 

  • Lookup Type: PON_IP_ATTR_DEFAULT_OPTIONS 12.2.2

    product: PON - Sourcing ,  meaning: PON: Defaulting Options for Catalog Attributes ,  description: PON: Defaulting Options for Catalog Attributes , 

  • Lookup Type: PON_GROUP_TYPE 12.2.2

    product: PON - Sourcing ,  meaning: Group Types for Auction Lines ,  description: Group Types for Auction Lines , 

  • Lookup Type: PON_MOVE_TYPE 12.1.1

    product: PON - Sourcing ,  meaning: Move Types for Auction Lines ,  description: Move Types for Auction Lines , 

  • Lookup Type: PON_IP_ATTR_DEFAULT_OPTIONS 12.1.1

    product: PON - Sourcing ,  meaning: PON: Defaulting Options for Catalog Attributes ,  description: PON: Defaulting Options for Catalog Attributes , 

  • Lookup Type: PON_MOVE_TYPE 12.2.2

    product: PON - Sourcing ,  meaning: Move Types for Auction Lines ,  description: Move Types for Auction Lines , 

  • Concurrent Program: PON_IMPORT_SHIPMENTS 12.2.2

    execution_filename: ImportShipmentsCp ,  product: PON - Sourcing ,  user_name: Import Spreadsheet for Price Tiers Creation ,  description: Import Price Tiers ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Table: PON_TEAM_MEMBER_ATTR_SCORES 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_ATTR_SCORES,  object_name:PON_TEAM_MEMBER_ATTR_SCORES,  status:VALID,  product: PON - Sourcing ,  description: This table records scores for every scoring team member for a given attribute and a response. ,  implementation_dba_data: PON.PON_TEAM_MEMBER_ATTR_SCORES , 

  • Table: PON_TEAM_MEMBER_ATTR_SCORES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_ATTR_SCORES,  object_name:PON_TEAM_MEMBER_ATTR_SCORES,  status:VALID,  product: PON - Sourcing ,  description: This table records scores for every scoring team member for a given attribute and a response. ,  implementation_dba_data: PON.PON_TEAM_MEMBER_ATTR_SCORES , 

  • Lookup Type: PON_TERMS_COND_SETUP 12.2.2

    product: PON - Sourcing ,  meaning: PON: Terms and Conditions setup page ,  description: PON: Terms and Conditions setup page , 

  • Table: PON_SCORING_TEAM_MEMBERS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_SCORING_TEAM_MEMBERS,  object_name:PON_SCORING_TEAM_MEMBERS,  status:VALID,  product: PON - Sourcing ,  description: PON_SCORING_TEAM_MEMBERS is a logical intersection entity between PON_NEG_TEAM_MEMBERS and PON_SCORING_TEAMS. It lists the members for each scoring team for a given negotiation. Typically this will be a subset of those collaboration team me ,  implementation_dba_data: PON.PON_SCORING_TEAM_MEMBERS , 

  • Table: PON_SCORING_TEAM_MEMBERS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_SCORING_TEAM_MEMBERS,  object_name:PON_SCORING_TEAM_MEMBERS,  status:VALID,  product: PON - Sourcing ,  description: PON_SCORING_TEAM_MEMBERS is a logical intersection entity between PON_NEG_TEAM_MEMBERS and PON_SCORING_TEAMS. It lists the members for each scoring team for a given negotiation. Typically this will be a subset of those collaboration team me ,  implementation_dba_data: PON.PON_SCORING_TEAM_MEMBERS , 

  • Concurrent Program: PONRMNTF 12.2.2

    execution_filename: pon_reminder_notification_pkg.send_notification_wrapper ,  product: PON - Sourcing ,  user_name: Reminder Notifications For Suppliers who have not placed a bid/quote ,  description: This executable calls the procedure pon_reminder_notification_pkg.send_notification_wrapper to send notifications to suppliers who have not placed a bid/quote yet for a negotiation. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • View: PON_MI_AUCTIONSUMMARY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUCTIONSUMMARY_V,  object_name:PON_MI_AUCTIONSUMMARY_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used for the Awarded Bids Detail report. It contains data for both Standard Purchase Orders and Blanket Purchase Agreements. ,  implementation_dba_data: APPS.PON_MI_AUCTIONSUMMARY_V , 

  • View: PON_MI_AUCTIONSUMMARY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUCTIONSUMMARY_V,  object_name:PON_MI_AUCTIONSUMMARY_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used for the Awarded Bids Detail report. It contains data for both Standard Purchase Orders and Blanket Purchase Agreements. ,  implementation_dba_data: APPS.PON_MI_AUCTIONSUMMARY_V , 

  • Table: PON_BID_PRICE_ELEMENTS_INT 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PRICE_ELEMENTS_INT,  object_name:PON_BID_PRICE_ELEMENTS_INT,  status:VALID,  product: PON - Sourcing ,  description: Interface table for price element ,  implementation_dba_data: PON.PON_BID_PRICE_ELEMENTS_INT , 

  • Table: PON_BID_PRICE_ELEMENTS_INT 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PRICE_ELEMENTS_INT,  object_name:PON_BID_PRICE_ELEMENTS_INT,  status:VALID,  product: PON - Sourcing ,  description: Interface table for price element ,  implementation_dba_data: PON.PON_BID_PRICE_ELEMENTS_INT , 

  • Table: PON_WF_DEBUG 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_WF_DEBUG,  object_name:PON_WF_DEBUG,  status:VALID,  product: PON - Sourcing ,  description: Holds the debug statements for workflow processes ,  implementation_dba_data: PON.PON_WF_DEBUG , 

  • Table: PON_BID_SHIPMENTS_INT 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_SHIPMENTS_INT,  object_name:PON_BID_SHIPMENTS_INT,  status:VALID,  product: PON - Sourcing ,  description: Store tempory data for Price Breaks spreadsheet uploading. ,  implementation_dba_data: PON.PON_BID_SHIPMENTS_INT , 

  • Table: PON_FORMS_SECTIONS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_FORMS_SECTIONS,  object_name:PON_FORMS_SECTIONS,  status:VALID,  product: PON - Sourcing ,  description: Store the header details for a form, section or abstract. ,  implementation_dba_data: PON.PON_FORMS_SECTIONS , 

  • Table: PON_WF_DEBUG 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_WF_DEBUG,  object_name:PON_WF_DEBUG,  status:VALID,  product: PON - Sourcing ,  description: Holds the debug statements for workflow processes ,  implementation_dba_data: PON.PON_WF_DEBUG , 

  • Table: PON_PF_SUPPLIER_VALUES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_PF_SUPPLIER_VALUES,  object_name:PON_PF_SUPPLIER_VALUES,  status:VALID,  product: PON - Sourcing ,  description: This table stores auction costfactor values for invited suppliers. ,  implementation_dba_data: PON.PON_PF_SUPPLIER_VALUES ,