Search Results pon_backing_requisitions




Overview
Explore in AI Chat

Overview

The PON_BACKING_REQUISITIONS table is a core data structure within the Oracle E-Business Suite (EBS) Sourcing (PON) module. It functions as a critical junction table that maintains the relationship between sourcing documents, specifically negotiation item lines, and the internal procurement requisitions they fulfill. Its primary role is to track which requisition lines are being sourced through a given auction or negotiation line item, enabling traceability from the sourcing event back to the original demand. This linkage is fundamental for processes like requisition import during negotiation creation and for ensuring procurement compliance.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships. The essential columns are AUCTION_HEADER_ID, which identifies the parent negotiation document; LINE_NUMBER, specifying the particular line within that negotiation; and REQUISITION_LINE_ID, which points to the specific requisition line being sourced. This three-part key ensures a unique record for each requisition line tied to a negotiation line. Other significant columns include REQUISITION_HEADER_ID, providing a direct link to the requisition header for broader context. The table does not typically store extensive transactional data itself but serves as a referential map between these key entities.

Common Use Cases and Queries

A primary use case is reporting and auditing the sourcing coverage for requisitions. Analysts can query this table to determine if and how a requisition line is being processed through Sourcing. Common SQL patterns involve joining to related transaction tables. For example, to list all backing requisitions for a specific negotiation, one might use:

  • SELECT pbr.auction_header_id, pbr.line_number, pbr.requisition_line_id, prla.item_description FROM pon_backing_requisitions pbr, po_requisition_lines_all prla WHERE pbr.requisition_line_id = prla.requisition_line_id AND pbr.auction_header_id = :p_auction_id;

Conversely, to find the sourcing document for a given requisition line, the query would join to PON_AUCTION_ITEM_PRICES_ALL. This table is also central during the technical troubleshooting of failed requisition imports or mismatches between requisition and negotiation line quantities.

Related Objects

PON_BACKING_REQUISITIONS maintains integral relationships with several key EBS tables. Its primary foreign keys link to PON_AUCTION_ITEM_PRICES_ALL (via AUCTION_HEADER_ID and LINE_NUMBER), which stores the pricing details of the negotiation line. It also has foreign key relationships to PO_REQUISITION_LINES_ALL and PO_REQUISITION_HEADERS_ALL in the Purchasing (PO) module, connecting to the source demand. While not explicitly listed in the provided metadata, this table is often referenced in sourcing reports and may be used by APIs or concurrent programs responsible for generating awards and creating purchase orders from negotiated lines.