Search Results proxy_bid_allowed_flag




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_AUCTION_TEMPLATES is a core table in the Oracle Sourcing module (product code PON) of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores the template definitions from which sourcing negotiations — RFQs, RFIs, and reverse auctions — are created. A template captures the reusable configuration of a negotiation: auction type and duration, currency and rate behavior, terms and shipping data, bid visibility and ranking rules, auto-extend behavior, and the structured lists of attributes, price elements, currency rates, bidding parties, and negotiation team members that accompany each event. Because negotiation creation reads heavily from this table, it functions as the master configuration source for the entire sourcing lifecycle.

The documented ETRM metadata classifies this object, heuristically, as satellite-leaning within a Data Vault model. That is a modeling suggestion rather than a physical property: the table carries a surrogate primary key and a dense set of descriptive, mutable attributes (status, flags, terms), which is characteristic of a satellite surrounding a negotiation business key rather than a pure hub or link.

Key Information Stored

The table documents 96 columns. The most operationally significant include:

Common Use Cases and Queries

Typical reporting and integration scenarios include listing active templates by scope, retrieving the full configuration before creating a negotiation, and auditing which templates allow auto-extension or proxy bids. For example, to list reusable active templates with their default currency and auction type:

  • SELECT template_id, name, auction_type, currency_code, status FROM pon.pon_auction_templates WHERE status = 'ACTIVE' ORDER BY name;
  • SELECT t.template_id, t.name, p.party_name FROM pon.pon_auction_templates t, hz_parties p WHERE t.trading_partner_id = p.party_id;
  • To confirm which templates carry attribute or price element structures, filter on ATTRIBUTES_EXIST = 'Y' or HAS_PRICE_ELEMENTS_FLAG = 'Y'.

These queries support template governance reporting, negotiation setup validation, and data migration scripts that map legacy templates into PON.

Related Objects

PON_AUCTION_TEMPLATES is the parent of several child tables keyed by LIST_ID, and it references external master data through its foreign keys: