Search Results pon_supplier_providers_pk

Overview

The PON_SUPPLIER_PROVIDERS table is a core data object within the Oracle E-Business Suite Sourcing (PON) module, present in both releases 12.1.1 and 12.2.2. It functions as the master repository for supplier provider entities. In the context of Oracle Sourcing, a provider is an organization or entity that can supply goods or services. This table is fundamental for establishing and maintaining the foundational supplier data required for conducting sourcing events, such as negotiations and auctions. Its integrity is critical for the procurement lifecycle, linking supplier information to transactional data across the suite.

Key Information Stored

As per the provided ETRM documentation, the primary purpose of the table is to store details of supplier providers. The most critical column is PROVIDER_ID, which serves as the unique identifier for each provider record and is the designated primary key for the table (PON_SUPPLIER_PROVIDERS_PK). While the full column list is not detailed in the excerpt, standard tables of this nature in Oracle EBS typically store associated attributes such as provider name, contact details, address information, tax identifiers, and status flags. The PROVIDER_ID column is the essential foreign key link to other sourcing and purchasing tables.

Common Use Cases and Queries

This table is central to queries that validate supplier participation, generate supplier master lists for reporting, and support data integrity checks. A common use case involves retrieving a list of all active providers eligible for a sourcing event. A fundamental query pattern leverages the primary key to join with related transactional tables, such as those storing auction or negotiation headers. For example, to find basic provider details for a given ID, a query would be: SELECT * FROM pon_supplier_providers WHERE provider_id = :p_provider_id;. Reporting use cases often involve aggregating provider counts or listing providers associated with specific sourcing projects, requiring joins to tables like PON_AUCTION_HEADERS_ALL.

Related Objects

The primary key relationship defined by PROVIDER_ID establishes this table as a parent to numerous other objects within the Sourcing module. Child tables will reference PON_SUPPLIER_PROVIDERS.PROVIDER_ID via foreign key constraints. Common related objects include, but are not limited to, negotiation headers (PON_AUCTION_HEADERS_ALL likely references PROVIDER_ID for the buying company or supplier), supplier response tables, and supplier scorecard data. Any table storing a sourcing event, bid, or award that is tied to a specific provider will join on this key column. The exact foreign key constraint names are not provided, but the documented primary key confirms its role as a central hub for relational integrity.