Search Results pon_award_allocations




Overview
Explore in AI Chat

Overview

The PON_AWARD_ALLOCATIONS table is a core data object within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It serves as the transactional bridge between the sourcing award process and the procurement fulfillment cycle. Its primary role is to record the precise allocation of awarded supplier bid quantities from a negotiation line back to the original internal requisition lines that initiated the sourcing event. This table is fundamental for ensuring that awarded amounts are properly tracked against procurement requirements, enabling accurate purchase order creation and requisition consumption.

Key Information Stored

The table stores the critical linkage between an awarded bid line and its backing requisition lines. Its primary key is a composite of ORIG_REQ_LINE_ID, BID_LINE_NUMBER, and BID_NUMBER, which uniquely identifies an allocation record. Key columns include BID_NUMBER and BID_LINE_NUMBER, which identify the specific awarded line from a supplier's response. The ORIG_REQ_HEADER_ID and ORIG_REQ_LINE_ID columns store references to the original requisition that was sourced. The SPLIT_REQ_LINE_ID is significant for scenarios where the awarded quantity is allocated across multiple new requisition lines created from a split of the original requirement. Other essential columns track the allocated quantity (ALLOCATED_QUANTITY), price, and the associated negotiation (AUCTION_HEADER_ID).

Common Use Cases and Queries

A primary use case is tracing the fulfillment status of requisitions through the sourcing award. Procurement analysts frequently query this table to report on award allocations or to troubleshoot discrepancies between requisitioned and awarded amounts. The user's search for "bid_line_number" indicates a common need to find all requisition allocations for a specific awarded bid line. A typical query pattern would be:

  • SELECT orig_req_line_id, allocated_quantity FROM pon_award_allocations WHERE bid_number = :p_bid_num AND bid_line_number = :p_bid_line_num;

Another critical reporting use case involves joining with PO_REQUISITION_LINES_ALL to compare original requisition details with their awarded allocations, providing visibility into sourcing coverage.

Related Objects

PON_AWARD_ALLOCATIONS is centrally connected to several key transactional tables via foreign key relationships, as documented in the ETRM metadata. These relationships are essential for accurate joins in reporting and integration:

  • PON_BID_HEADERS: Joined via BID_NUMBER to access supplier bid header information.
  • PON_AUCTION_HEADERS_ALL: Joined via AUCTION_HEADER_ID to access the parent negotiation/sourcing event.
  • PO_REQUISITION_LINES_ALL: Joined via ORIG_REQ_LINE_ID (original line) and SPLIT_REQ_LINE_ID (post-split line) to access requisition line details.
  • PO_REQUISITION_HEADERS_ALL: Joined via ORIG_REQ_HEADER_ID to access requisition header information.
  • Table: PON_AWARD_ALLOCATIONS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AWARD_ALLOCATIONS,  object_name:PON_AWARD_ALLOCATIONS,  status:VALID,  product: PON - Sourcing ,  description: Contains the allocation of each awarded response to the backing requisitions for a particular negotiation line. ,  implementation_dba_data: PON.PON_AWARD_ALLOCATIONS , 

  • Table: PON_AWARD_ALLOCATIONS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AWARD_ALLOCATIONS,  object_name:PON_AWARD_ALLOCATIONS,  status:VALID,  product: PON - Sourcing ,  description: Contains the allocation of each awarded response to the backing requisitions for a particular negotiation line. ,  implementation_dba_data: PON.PON_AWARD_ALLOCATIONS , 

  • 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 , 

  • 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_AUCTION_HEADERS_ALL 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_HEADERS_ALL,  object_name:PON_AUCTION_HEADERS_ALL,  status:VALID,  product: PON - Sourcing ,  description: Stores the negotiations header level details. ,  implementation_dba_data: PON.PON_AUCTION_HEADERS_ALL , 

  • Table: PON_AUCTION_HEADERS_ALL 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_HEADERS_ALL,  object_name:PON_AUCTION_HEADERS_ALL,  status:VALID,  product: PON - Sourcing ,  description: Stores the negotiations header level details. ,  implementation_dba_data: PON.PON_AUCTION_HEADERS_ALL ,