Search Results pon_auction_headers_all
The PON_AUCTION_HEADERS_ALL
table is a critical component within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically designed to support the Oracle Sourcing module. This table serves as the primary repository for storing header-level information related to auctions, including reverse auctions, forward auctions, and RFx (Request for Information, Request for Proposal, Request for Quotation) documents. It captures essential metadata and transactional data that governs the entire lifecycle of sourcing events, from creation to award.
Key Attributes and Structure
ThePON_AUCTION_HEADERS_ALL
table is a multi-organization-enabled table, indicated by the _ALL
suffix, meaning it stores data across multiple operating units. Key columns include:
- AUCTION_HEADER_ID: Primary key uniquely identifying each auction.
- DOCUMENT_NUMBER: User-friendly identifier for the auction.
- AUCTION_TITLE: Descriptive title of the sourcing event.
- AUCTION_STATUS: Tracks the auction's lifecycle (e.g., DRAFT, PUBLISHED, CLOSED, AWARDED).
- BID_START_DATE and BID_END_DATE: Define the active bidding period.
- ORG_ID: Operating unit identifier for multi-org functionality.
- SUPPLIER_SCOPE: Determines if the auction is open to all suppliers or restricted.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.
Functional Significance
The table acts as the anchor for sourcing events, linking to subsidiary tables such asPON_AUCTION_ITEMS_ALL
(line items), PON_BID_HEADERS
(supplier bids), and PON_ATTACHMENTS
(supporting documents). It supports features like:
- Multi-Round Auctions: Tracks rounds via status and date fields.
- Approval Workflows: Integrates with Oracle Workflow for approvals.
- Supplier Collaboration: Manages visibility rules based on
SUPPLIER_SCOPE
. - Integration with Procurement: Links to
PO_HEADERS_ALL
upon award.
Technical Considerations
In EBS 12.1.1 and 12.2.2, the table is heavily indexed to optimize performance for queries involving status, dates, and document numbers. Partitioning strategies may be employed for large-scale implementations. The table also integrates with Oracle's security model (VPD, or Virtual Private Database) to enforce data access controls. Customizations often extend this table with descriptive flexfields (DFFs) to capture organization-specific attributes.Upgrade and Migration Impact
Between 12.1.1 and 12.2.2, structural changes toPON_AUCTION_HEADERS_ALL
are minimal, but enhancements in 12.2.2 include improved JSON/XML support for REST APIs and deeper integration with Oracle Supplier Model. Data migration requires careful handling of ORG_ID
mappings in multi-org environments.
Common Use Cases
- Generating auction reports via
AUCTION_STATUS
filters. - Triggering notifications based on
BID_END_DATE
. - Auditing changes via standard who columns.
- Integrating with third-party sourcing tools via APIs.
PON_AUCTION_HEADERS_ALL
is a foundational table in Oracle Sourcing, enabling complex procurement strategies while maintaining compliance, auditability, and scalability across global enterprises.
-
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 ,
-
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_SUPPLIER_ACTIVITIES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACTIVITIES, object_name:PON_SUPPLIER_ACTIVITIES, status:VALID, product: PON - Sourcing , description: This table will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bidding flow. The latest activity will be indicated as such by the last_action_flag. , implementation_dba_data: PON.PON_SUPPLIER_ACTIVITIES ,
-
Table: PON_SUPPLIER_ACTIVITIES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACTIVITIES, object_name:PON_SUPPLIER_ACTIVITIES, status:VALID, product: PON - Sourcing , description: This table will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bidding flow. The latest activity will be indicated as such by the last_action_flag. , implementation_dba_data: PON.PON_SUPPLIER_ACTIVITIES ,
-
Table: PON_SUPPLIER_ACCESS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACCESS, object_name:PON_SUPPLIER_ACCESS, status:VALID, product: PON - Sourcing , description: This table will record the lock status for a supplier. As the negotiation proceeds the user might lock a supplier out of the negotiation from the 'Manage Supplier Activities' screen. At that point in time we will flag the supplier as 'Lo , implementation_dba_data: PON.PON_SUPPLIER_ACCESS ,
-
Table: PON_SUPPLIER_ACCESS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACCESS, object_name:PON_SUPPLIER_ACCESS, status:VALID, product: PON - Sourcing , description: This table will record the lock status for a supplier. As the negotiation proceeds the user might lock a supplier out of the negotiation from the 'Manage Supplier Activities' screen. At that point in time we will flag the supplier as 'Lo , implementation_dba_data: PON.PON_SUPPLIER_ACCESS ,
-
View: PON_MI_AUC_OFFERTOBUY_V
12.1.1
product: PON - Sourcing , description: This view is used by the Buyer's Activity Summary report. It contains data for all Committed Offers. , implementation_dba_data: Not implemented in this database ,
-
View: PON_MI_AUC_OFFERTOBUY_V
12.2.2
product: PON - Sourcing , description: This view is used by the Buyer's Activity Summary report. It contains data for all Committed Offers. , implementation_dba_data: Not implemented in this database ,
-
Table: PON_EMD_TRANSACTIONS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_EMD_TRANSACTIONS, object_name:PON_EMD_TRANSACTIONS, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_EMD_TRANSACTIONS ,
-
Table: PON_OPTIMIZE_SCENARIOS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_SCENARIOS, object_name:PON_OPTIMIZE_SCENARIOS, status:VALID, product: PON - Sourcing , description: This table stores information about the award optimization scenarios , implementation_dba_data: PON.PON_OPTIMIZE_SCENARIOS ,
-
Table: PON_PARTY_LINE_EXCLUSIONS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PARTY_LINE_EXCLUSIONS, object_name:PON_PARTY_LINE_EXCLUSIONS, status:VALID, product: PON - Sourcing , description: Table stores negotiation line restrictions for a particular supplier/line combination , implementation_dba_data: PON.PON_PARTY_LINE_EXCLUSIONS ,
-
Table: PON_PRICE_DIFFERENTIALS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PRICE_DIFFERENTIALS, object_name:PON_PRICE_DIFFERENTIALS, status:VALID, product: PON - Sourcing , description: Negotiation price differentials table , implementation_dba_data: PON.PON_PRICE_DIFFERENTIALS ,
-
Table: PON_BID_PRICE_DIFFERENTIALS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PRICE_DIFFERENTIALS, object_name:PON_BID_PRICE_DIFFERENTIALS, status:VALID, product: PON - Sourcing , description: Response price differentials table , implementation_dba_data: PON.PON_BID_PRICE_DIFFERENTIALS ,
-
Table: PON_AUCTION_EVENTS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_EVENTS, object_name:PON_AUCTION_EVENTS, status:VALID, product: PON - Sourcing , description: Stores the event details of a group of negotiations. , implementation_dba_data: PON.PON_AUCTION_EVENTS ,
-
Table: PON_BIDDING_PARTIES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BIDDING_PARTIES, object_name:PON_BIDDING_PARTIES, status:VALID, product: PON - Sourcing , description: Stores the parties participating in a negotiation. , implementation_dba_data: PON.PON_BIDDING_PARTIES ,
-
Table: PON_AUCTION_CURRENCY_RATES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_CURRENCY_RATES, object_name:PON_AUCTION_CURRENCY_RATES, status:VALID, product: PON - Sourcing , description: Stores the currency conversion rate between the negotiation currency and the response currency , implementation_dba_data: PON.PON_AUCTION_CURRENCY_RATES ,
-
Table: PON_PARTY_LINE_EXCLUSIONS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PARTY_LINE_EXCLUSIONS, object_name:PON_PARTY_LINE_EXCLUSIONS, status:VALID, product: PON - Sourcing , description: Table stores negotiation line restrictions for a particular supplier/line combination , implementation_dba_data: PON.PON_PARTY_LINE_EXCLUSIONS ,
-
Table: PON_NEG_TEAM_MEMBERS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_NEG_TEAM_MEMBERS, object_name:PON_NEG_TEAM_MEMBERS, status:VALID, product: PON - Sourcing , description: Stores Collaboration Team member details included in a negotiation or template. , implementation_dba_data: PON.PON_NEG_TEAM_MEMBERS ,
-
Table: PON_OPTIMIZE_CONSTRAINTS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_CONSTRAINTS, object_name:PON_OPTIMIZE_CONSTRAINTS, status:VALID, product: PON - Sourcing , description: This table stores information about the user created constraints , implementation_dba_data: PON.PON_OPTIMIZE_CONSTRAINTS ,
-
Table: PON_BID_PRICE_DIFFERENTIALS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PRICE_DIFFERENTIALS, object_name:PON_BID_PRICE_DIFFERENTIALS, status:VALID, product: PON - Sourcing , description: Response price differentials table , implementation_dba_data: PON.PON_BID_PRICE_DIFFERENTIALS ,
-
Table: PON_BIDDING_PARTIES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BIDDING_PARTIES, object_name:PON_BIDDING_PARTIES, status:VALID, product: PON - Sourcing , description: Stores the parties participating in a negotiation. , implementation_dba_data: PON.PON_BIDDING_PARTIES ,
-
Table: PON_AUCTION_EVENTS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_EVENTS, object_name:PON_AUCTION_EVENTS, status:VALID, product: PON - Sourcing , description: Stores the event details of a group of negotiations. , implementation_dba_data: PON.PON_AUCTION_EVENTS ,
-
Table: PON_PRICE_DIFFERENTIALS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PRICE_DIFFERENTIALS, object_name:PON_PRICE_DIFFERENTIALS, status:VALID, product: PON - Sourcing , description: Negotiation price differentials table , implementation_dba_data: PON.PON_PRICE_DIFFERENTIALS ,
-
Table: PON_AUC_DOCTYPES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_DOCTYPES, object_name:PON_AUC_DOCTYPES, status:VALID, product: PON - Sourcing , description: Stores the negotiation document type , implementation_dba_data: PON.PON_AUC_DOCTYPES ,
-
Table: PON_AUCTION_CURRENCY_RATES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_CURRENCY_RATES, object_name:PON_AUCTION_CURRENCY_RATES, status:VALID, product: PON - Sourcing , description: Stores the currency conversion rate between the negotiation currency and the response currency , implementation_dba_data: PON.PON_AUCTION_CURRENCY_RATES ,
-
Table: PON_AUC_PAYMENTS_INTERFACE
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_PAYMENTS_INTERFACE, object_name:PON_AUC_PAYMENTS_INTERFACE, status:VALID, product: PON - Sourcing , description: Interface table to store imported information of the payments that are defined on a negotiation for complex services. , implementation_dba_data: PON.PON_AUC_PAYMENTS_INTERFACE ,
-
Table: PON_AUCTION_SHIPMENTS_ALL
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_SHIPMENTS_ALL, object_name:PON_AUCTION_SHIPMENTS_ALL, status:VALID, product: PON - Sourcing , description: Stores the negotiation shipment details , implementation_dba_data: PON.PON_AUCTION_SHIPMENTS_ALL ,
-
Table: PON_OPTIMIZE_CONSTRAINTS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_CONSTRAINTS, object_name:PON_OPTIMIZE_CONSTRAINTS, status:VALID, product: PON - Sourcing , description: This table stores information about the user created constraints , implementation_dba_data: PON.PON_OPTIMIZE_CONSTRAINTS ,
-
Table: PON_AUC_DOCTYPES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_DOCTYPES, object_name:PON_AUC_DOCTYPES, status:VALID, product: PON - Sourcing , description: Stores the negotiation document type , implementation_dba_data: PON.PON_AUC_DOCTYPES ,
-
Table: PON_NEG_TEAM_MEMBERS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_NEG_TEAM_MEMBERS, object_name:PON_NEG_TEAM_MEMBERS, status:VALID, product: PON - Sourcing , description: Stores Collaboration Team member details included in a negotiation or template. , implementation_dba_data: PON.PON_NEG_TEAM_MEMBERS ,
-
Table: PON_AUC_PAYMENTS_INTERFACE
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_PAYMENTS_INTERFACE, object_name:PON_AUC_PAYMENTS_INTERFACE, status:VALID, product: PON - Sourcing , description: Interface table to store imported information of the payments that are defined on a negotiation for complex services. , implementation_dba_data: PON.PON_AUC_PAYMENTS_INTERFACE ,
-
Table: PON_AUCTION_SHIPMENTS_ALL
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_SHIPMENTS_ALL, object_name:PON_AUCTION_SHIPMENTS_ALL, status:VALID, product: PON - Sourcing , description: Stores the negotiation shipment details , implementation_dba_data: PON.PON_AUCTION_SHIPMENTS_ALL ,
-
Table: PON_ITEM_PRICES_INTERFACE
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_ITEM_PRICES_INTERFACE, object_name:PON_ITEM_PRICES_INTERFACE, status:VALID, product: PON - Sourcing , description: Temporary table contains the item price details that have been imported or exported to to excel. , implementation_dba_data: PON.PON_ITEM_PRICES_INTERFACE ,
-
Table: PON_ITEM_PRICES_INTERFACE
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_ITEM_PRICES_INTERFACE, object_name:PON_ITEM_PRICES_INTERFACE, status:VALID, product: PON - Sourcing , description: Temporary table contains the item price details that have been imported or exported to to excel. , implementation_dba_data: PON.PON_ITEM_PRICES_INTERFACE ,
-
Table: PON_TEAM_MEMBER_ATTR_SCORES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_TEAM_MEMBER_ATTR_SCORES, object_name:PON_TEAM_MEMBER_ATTR_SCORES, status:VALID, product: PON - Sourcing , description: This table records scores for every scoring team member for a given attribute and a response. , implementation_dba_data: PON.PON_TEAM_MEMBER_ATTR_SCORES ,
-
Table: PON_OPTIMIZE_SCENARIOS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_SCENARIOS, object_name:PON_OPTIMIZE_SCENARIOS, status:VALID, product: PON - Sourcing , description: This table stores information about the award optimization scenarios , implementation_dba_data: PON.PON_OPTIMIZE_SCENARIOS ,
-
Table: PON_TEAM_MEMBER_ATTR_SCORES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_TEAM_MEMBER_ATTR_SCORES, object_name:PON_TEAM_MEMBER_ATTR_SCORES, status:VALID, product: PON - Sourcing , description: This table records scores for every scoring team member for a given attribute and a response. , implementation_dba_data: PON.PON_TEAM_MEMBER_ATTR_SCORES ,
-
Table: PON_BID_PAYMENTS_INTERFACE
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PAYMENTS_INTERFACE, object_name:PON_BID_PAYMENTS_INTERFACE, status:VALID, product: PON - Sourcing , description: Interface table to store imported information of the payments that are defined on a response to a negotiation for complex services. , implementation_dba_data: PON.PON_BID_PAYMENTS_INTERFACE ,
-
Table: PON_BID_PAYMENTS_INTERFACE
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PAYMENTS_INTERFACE, object_name:PON_BID_PAYMENTS_INTERFACE, status:VALID, product: PON - Sourcing , description: Interface table to store imported information of the payments that are defined on a response to a negotiation for complex services. , implementation_dba_data: PON.PON_BID_PAYMENTS_INTERFACE ,
-
View: PON_AUC_NOTIF_DELIV_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PON.PON_AUC_NOTIF_DELIV_V, object_name:PON_AUC_NOTIF_DELIV_V, status:VALID, product: PON - Sourcing , description: This is the view used by contract team about active bids and the associated auction information. , implementation_dba_data: APPS.PON_AUC_NOTIF_DELIV_V ,
-
Table: PON_BID_SHIPMENTS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_SHIPMENTS, object_name:PON_BID_SHIPMENTS, status:VALID, product: PON - Sourcing , description: Contains the response details for an shipment in a negotiation , implementation_dba_data: PON.PON_BID_SHIPMENTS ,
-
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_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_BID_SHIPMENTS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_SHIPMENTS, object_name:PON_BID_SHIPMENTS, status:VALID, product: PON - Sourcing , description: Contains the response details for an shipment in a negotiation , implementation_dba_data: PON.PON_BID_SHIPMENTS ,
-
Table: PON_SCORING_TEAM_MEMBERS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SCORING_TEAM_MEMBERS, object_name:PON_SCORING_TEAM_MEMBERS, status:VALID, product: PON - Sourcing , description: PON_SCORING_TEAM_MEMBERS is a logical intersection entity between PON_NEG_TEAM_MEMBERS and PON_SCORING_TEAMS. It lists the members for each scoring team for a given negotiation. Typically this will be a subset of those collaboration team me , implementation_dba_data: PON.PON_SCORING_TEAM_MEMBERS ,
-
View: PON_AUC_NOTIF_DELIV_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PON.PON_AUC_NOTIF_DELIV_V, object_name:PON_AUC_NOTIF_DELIV_V, status:VALID, product: PON - Sourcing , description: This is the view used by contract team about active bids and the associated auction information. , implementation_dba_data: APPS.PON_AUC_NOTIF_DELIV_V ,
-
Table: PON_BID_PAYMENTS_SHIPMENTS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_PAYMENTS_SHIPMENTS, object_name:PON_BID_PAYMENTS_SHIPMENTS, status:VALID, product: PON - Sourcing , description: This contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SHIPMENTS table which defines payments on a negotiation. , implementation_dba_data: PON.PON_BID_PAYMENTS_SHIPMENTS ,
-
View: PON_SUPPLIER_MANAGE_DELIV_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PON.PON_SUPPLIER_MANAGE_DELIV_V, object_name:PON_SUPPLIER_MANAGE_DELIV_V, status:VALID, product: PON - Sourcing , description: This is the view of active bids and their suppliers' user id. , implementation_dba_data: APPS.PON_SUPPLIER_MANAGE_DELIV_V ,
-
View: PON_SUPPLIER_MANAGE_DELIV_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PON.PON_SUPPLIER_MANAGE_DELIV_V, object_name:PON_SUPPLIER_MANAGE_DELIV_V, status:VALID, product: PON - Sourcing , description: This is the view of active bids and their suppliers' user id. , implementation_dba_data: APPS.PON_SUPPLIER_MANAGE_DELIV_V ,
-
Table: PON_SCORING_TEAM_MEMBERS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SCORING_TEAM_MEMBERS, object_name:PON_SCORING_TEAM_MEMBERS, status:VALID, product: PON - Sourcing , description: PON_SCORING_TEAM_MEMBERS is a logical intersection entity between PON_NEG_TEAM_MEMBERS and PON_SCORING_TEAMS. It lists the members for each scoring team for a given negotiation. Typically this will be a subset of those collaboration team me , implementation_dba_data: PON.PON_SCORING_TEAM_MEMBERS ,