Search Results pon_bid_item_references_pk

Overview

The PON_BID_ITEM_REFERENCES table is a core transactional data object within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It serves as a critical junction table that manages the relationships between solicited lines and unsolicited lines within a sourcing negotiation. Its primary role is to record and track the associations created by suppliers when they link their proposed unsolicited items to specific lines in the buyer's original solicitation. This functionality is essential for maintaining bid integrity, enabling line-item comparisons, and facilitating the analysis of supplier responses during the negotiation and award phases.

Key Information Stored

The table's structure is defined by a composite primary key and columns that identify the parties and items involved in the linkage. The primary key uniquely identifies each link through a combination of the auction header ID, the line number, the link type, the entity that performed the link, the bid number, and the auction line number. Key columns include AUCTION_HEADER_ID and AUCTION_LINE_NUMBER, which identify the sourcing negotiation and the specific solicitation line. The BID_NUMBER identifies the supplier's bid response. The LINK_DONE_BY column specifies whether the supplier or buyer created the association, while LINK_TYPE categorizes the nature of the relationship. This design ensures a precise and auditable record of how unsolicited proposals are mapped to the original requirements.

Common Use Cases and Queries

A primary use case is generating reports for bid analysis, allowing buyers to see all unsolicited items proposed by a supplier and which requested items they are intended to fulfill or substitute. Another scenario involves validating bid completeness by ensuring all solicited lines have a corresponding bid response, either as a direct bid or a linked unsolicited line. A common query pattern retrieves all unsolicited line links for a specific auction and bid to review a supplier's complete proposal. For example:

• SELECT * FROM pon_bid_item_REFERENCES WHERE auction_header_id = :p_auction_id AND bid_number = :p_bid_number;

Data from this table is also integral to the Sourcing awards process, where the system evaluates both direct and linked proposals to determine the best overall award scenario.

Related Objects

The PON_BID_ITEM_REFERENCES table maintains a direct foreign key relationship with the PON_AUCTION_ITEM_PRICES_ALL table, which holds the pricing details for all lines within a sourcing negotiation. The relationship is established on the key identifiers of the solicitation line: the AUCTION_HEADER_ID and the AUCTION_LINE_NUMBER. This ensures referential integrity, meaning a link in PON_BID_ITEM_REFERENCES must always point to a valid, existing line in the parent auction. Consequently, joins between these tables are fundamental for enriching link data with detailed item descriptions, categories, and quoted prices from the auction lines. The table's primary key constraint, PON_BID_ITEM_REFERENCES_PK, enforces the uniqueness of each supplier-created link.