Search Results pon_auction_currency_rates




Overview
Explore in AI Chat

Overview

The PON_AUCTION_CURRENCY_RATES table is a core data object within the Oracle E-Business Suite Sourcing (PON) module. Its primary function is to manage and store the currency conversion rates used during a negotiation event, specifically the rate between the negotiation's base currency and the currency in which a supplier (bidder) chooses to submit their response. This table is essential for enabling multi-currency sourcing events, ensuring that bids submitted in different currencies can be accurately compared and evaluated based on a consistent financial baseline. It operates as a child table, directly supporting the main auction header and template entities.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies a currency rate record for a specific sourcing event. The critical columns are:

While the provided metadata specifies the key structure, typical complementary columns would include RATE (the conversion rate itself), RATE_TYPE (e.g., 'User' or 'Corporate'), and possibly rate expiration dates, aligning with its described purpose of storing conversion rates.

Common Use Cases and Queries

This table is central to financial analysis and reporting within Sourcing. A primary use case is the real-time conversion of all submitted bid amounts into the negotiation currency for the "Best Bid" and auction line scoring calculations. For reporting, it is queried to audit the rates applied during a closed negotiation or to analyze cost differentials based on currency fluctuations. A common SQL pattern involves joining to the auction headers to retrieve rate details for a specific event:

SELECT ah.auction_header_id, ah.document_number, cr.bid_currency_code, cr.rate
FROM pon_auction_currency_rates cr,
pon_auction_headers_all ah
WHERE cr.auction_header_id = ah.auction_header_id
AND ah.document_number = 'RFQ12345';

Data from this table is also critical for integrations with financial systems, ensuring procurement costs are recorded in the correct ledger currency.

Related Objects

The PON_AUCTION_CURRENCY_RATES table maintains defined foreign key relationships with two primary sourcing tables, as documented in the metadata:

  • PON_AUCTION_HEADERS_ALL: The master table for all negotiation headers. The relationship is via PON_AUCTION_CURRENCY_RATES.AUCTION_HEADER_ID. Every rate record must be associated with a valid auction.
  • PON_AUCTION_TEMPLATES: The table storing sourcing templates. The relationship is via PON_AUCTION_CURRENCY_RATES.LIST_ID, indicating that rate lists can be defined at the template level and inherited by individual negotiations.

This table is also a likely reference point for views and APIs responsible for displaying bid currency options and performing bid amount conversions within the Sourcing user interface.