Search Results pon_bid_rebates

Overview

The PON_BID_REBATES table is a core data object within the Oracle E-Business Suite (EBS) Sourcing (PON) module. It serves as the primary repository for storing rebate information associated with bids submitted during a sourcing negotiation, such as a reverse auction. A rebate is a financial incentive, typically a percentage or fixed amount returned to the buyer based on achieving specific purchase volume thresholds or other performance criteria. This table's existence is critical for enabling complex pricing strategies beyond simple unit costs, allowing buyers to model and suppliers to offer tiered discount structures directly within the bidding process. Its role is to persistently capture these rebate terms as part of the bid's commercial details.

Key Information Stored

While the provided metadata specifies the primary key, the table's core function indicates it must store columns to define the rebate structure. Based on standard Sourcing data models, key columns typically include:

BID_NUMBER: The foreign key linking the rebate line to the parent bid header in PON_BID_HEADERS.
SEQUENCE_NUMBER: The primary key (PON_BID_REBATES_PK) for uniquely identifying each rebate line within a bid.
REBATE_TYPE: A code or descriptor for the rebate (e.g., 'VOLUME', 'PERFORMANCE').
THRESHOLD_AMOUNT or THRESHOLD_QUANTITY: The target that must be met to trigger the rebate.
REBATE_VALUE and REBATE_PERCENTAGE: The value of the rebate, often stored as both a fixed amount and a percentage.
CURRENCY_CODE: The currency for any monetary rebate amounts.
Audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY.

Common Use Cases and Queries

This table is central to reporting and analysis on bid pricing structures. A common use case is comparing rebate offers across suppliers for the same sourcing event to determine the most advantageous total cost of ownership. Procurement analysts may query this table to aggregate all financial incentives attached to a bid. A typical SQL pattern involves joining to the bid headers to get supplier and auction context:

SELECT h.TRADING_PARTNER_NAME, r.* FROM PON.PON_BID_HEADERS h, PON.PON_BID_REBATES r WHERE h.BID_NUMBER = r.BID_NUMBER AND h.AUCTION_HEADER_ID = :p_auction_id ORDER BY h.BID_NUMBER, r.SEQUENCE_NUMBER;

Another critical use case occurs during the award process, where the Sourcing engine evaluates the net effective price by factoring in applicable rebates from this table. Data may also be interfaced to downstream systems like Purchasing (PO) for enforcement during procurement execution.

Related Objects

The PON_BID_REBATES table has a direct, documented foreign key relationship with the PON_BID_HEADERS table, which is the master record for a supplier's bid submission. This relationship is fundamental, as every rebate must belong to a specific bid. The join is performed on the BID_NUMBER column. Other related objects not specified in the metadata but integral to the Sourcing data model typically include PON_AUCTION_HEADERS (for the parent negotiation) and PON_BID_ITEM_PRICES. While rebates are often defined at the bid header level, they may also be associated with specific line items, which could involve relationships with other tables like PON_BID_REBATE_ITEMS in more complex implementations.

Table: PON_BID_REBATES 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_REBATES, object_name:PON_BID_REBATES, status:VALID, product: PON - Sourcing , description: This table is used to store rebates for a particular bid , implementation_dba_data: PON.PON_BID_REBATES ,
Table: PON_BID_REBATES 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_REBATES, object_name:PON_BID_REBATES, status:VALID, product: PON - Sourcing , description: This table is used to store rebates for a particular bid , implementation_dba_data: PON.PON_BID_REBATES ,
Table: PON_BID_HEADERS 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_HEADERS, object_name:PON_BID_HEADERS, status:VALID, product: PON - Sourcing , description: Contains header level data for a response to a negotiation , implementation_dba_data: PON.PON_BID_HEADERS ,
Table: PON_BID_HEADERS 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_HEADERS, object_name:PON_BID_HEADERS, status:VALID, product: PON - Sourcing , description: Contains header level data for a response to a negotiation , implementation_dba_data: PON.PON_BID_HEADERS ,