Search Results pon_auction_templates




Overview
Explore in AI Chat

Overview

The PON_AUCTION_TEMPLATES table is a core data object within the Oracle E-Business Suite Sourcing (PON) module. It functions as the central repository for storing reusable negotiation templates. These templates provide a standardized framework from which buyers can rapidly create and launch new sourcing negotiations, such as RFQs or reverse auctions, ensuring consistency in terms, rules, and structure. By capturing a comprehensive set of negotiation parameters, the table is fundamental to streamlining the sourcing process and enforcing organizational procurement policies.

Key Information Stored

The table stores the master definition of a sourcing template. Its primary key, TEMPLATE_ID, uniquely identifies each template record. Critical columns define the template's operational and commercial context. These include TRADING_PARTNER_ID and TRADING_PARTNER_CONTACT_ID (foreign keys to HZ_PARTIES) for specifying a default supplier, and CATEGORY_ID (foreign key to MTL_CATEGORIES_B) for a default item category. Financial controls are set via CURRENCY_CODE, RATE_TYPE, and DOCTYPE_ID. The table also stores various LIST_ID columns, which serve as foreign keys to associated child tables containing detailed template data, such as attributes (PON_AUCTION_ATTRIBUTES), price elements (PON_PRICE_ELEMENTS), and invited bidders (PON_BIDDING_PARTIES).

Common Use Cases and Queries

A primary use case is generating reports on template usage and configuration for procurement analysis. Common queries involve joining with related tables to extract a complete template profile. For instance, to list all templates with their associated currency and default category, one might use:

  • SELECT pat.TEMPLATE_NAME, pat.TEMPLATE_ID, fc.NAME CURRENCY, mcb.CONCATENATED_SEGMENTS CATEGORY FROM PON.PON_AUCTION_TEMPLATES pat, FND_CURRENCIES fc, MTL_CATEGORIES_B mcb WHERE pat.CURRENCY_CODE = fc.CURRENCY_CODE AND pat.CATEGORY_ID = mcb.CATEGORY_ID;

Another critical scenario is troubleshooting template-based negotiation creation, where queries validate the integrity of template data by checking for orphaned records or missing mandatory references before a new negotiation is launched.

Related Objects

PON_AUCTION_TEMPLATES has extensive relationships with other Sourcing tables. It is referenced as a foreign key by numerous child tables that store template details, including PON_AUCTION_ATTRIBUTES (line attributes), PON_PRICE_ELEMENTS (cost factors), PON_BIDDING_PARTIES (supplier lists), PON_NEG_TEAM_MEMBERS (internal team), and PON_AUCTION_CURRENCY_RATES (exchange rates). It also references foundational application tables for validation: HZ_PARTIES (trading partners), MTL_CATEGORIES_B (categories), FND_CURRENCIES, GL_DAILY_CONVERSION_TYPES, FND_LANGUAGES, and PON_AUC_DOCTYPES (document types). This network of relationships underscores its role as a master configuration entity.