Search Results suppliers'




Deep Dive into PON_PF_SUPPLIER_VALUES Table in Oracle EBS 12.1.1/12.2.2

The PON_PF_SUPPLIER_VALUES table is a critical component of Oracle E-Business Suite (EBS) Procurement modules, specifically designed to store supplier-specific responses to negotiation or questionnaire attributes in the Purchasing (PO) and Sourcing modules. This table plays a pivotal role in supplier collaboration scenarios, particularly in Oracle iSupplier Portal and Sourcing (RFx) processes.

Table Structure and Key Columns

The table contains the following key columns:

  • AUCTION_HEADER_ID: Foreign key to PON_AUCTION_HEADERS_ALL, linking to the sourcing event
  • SUPPLIER_ID: References PO_VENDORS, identifying the responding supplier
  • ATTRIBUTE_NAME: Name of the attribute being responded to
  • ATTRIBUTE_VALUE: The actual response value provided by the supplier
  • ATTRIBUTE_VALUE_TYPE: Data type of the response (TEXT, NUMBER, DATE, etc.)
  • DISPLAY_TARGET_FLAG: Indicates if the response should be visible to buyers
  • LAST_UPDATE_DATE/LAST_UPDATED_BY: Standard Oracle audit columns

Functional Context

This table supports several key procurement processes:

  1. Sourcing Events (RFx/Auctions): Stores supplier responses to attribute questions defined in PON_PF_ATTRIBUTES
  2. Supplier Qualification: Maintains supplier-provided qualification data
  3. Supplier Self-Service: Enables suppliers to update their profile information via iSupplier Portal
  4. Negotiation Attribute Tracking: Captures supplier-specific terms during contract negotiations

Integration Points

The table integrates with several Oracle EBS components:

  • PON_AUCTION_HEADERS_ALL: Parent sourcing document
  • PON_PF_ATTRIBUTES: Attribute definitions
  • PO_VENDORS: Supplier master data
  • PON_BIDDING_PARTIES: Supplier participation records

Technical Considerations

Key technical aspects include:

  • Table is purged during sourcing document archival
  • Indexed on AUCTION_HEADER_ID+SUPPLIER_ID+ATTRIBUTE_NAME for performance
  • Uses Oracle Flexfields architecture for attribute definition
  • Subject to Oracle's Multi-Org security rules in EBS 12.2.2

Common Customization Scenarios

Typical extensions involving this table include:

  1. Creating custom reports on supplier response patterns
  2. Developing supplier scoring algorithms based on response data
  3. Building interfaces to external supplier management systems
  4. Extending the attribute framework for industry-specific requirements

Version-Specific Notes

Between 12.1.1 and 12.2.2:

  • 12.2.2 introduces enhanced security through VPD policies
  • Column datatypes remain consistent across versions
  • 12.2.2 includes additional indexes for cloud performance optimization

Understanding PON_PF_SUPPLIER_VALUES is essential for implementing advanced supplier collaboration features, custom reporting, and data integration in Oracle Procurement implementations.