Search Results pon_supplier_access




Overview
Explore in AI Chat

Overview

PON_SUPPLIER_ACCESS is a transactional table in the PON (Sourcing) schema of Oracle E-Business Suite, validated across releases 12.1.1 and 12.2.2. It records the lock status that a buyer applies to an individual supplier within a sourcing negotiation or auction. As a negotiation proceeds, the buyer may lock a supplier out of the event from the "Manage Supplier Activities" screen; at that moment the supplier is flagged as locked, and the corresponding row in this table captures the lock event. Conversely, the table supports the release of that lock when the buyer reinstates supplier access.

Because each row associates one supplier trading partner with one auction header at a specific lock date, the table functions as an intersection or association entity between negotiations and suppliers. The heuristic Data Vault classification mined from the foreign-key structure is link, making it a reasonable modeling suggestion to treat PON_SUPPLIER_ACCESS as a link table connecting the PON_AUCTION_HEADERS_ALL hub and the HZ_PARTIES hub.

Key Information Stored

The documented physical schema contains 13 columns. The most significant are summarized below.

  • AUCTION_HEADER_ID_ORIG_AMEND — Identifier for the negotiation header, including the original or amended version context; part of the composite primary key.
  • SUPPLIER_TRADING_PARTNER_ID — The supplier trading partner (party) being locked or unlocked; part of the composite primary key and a foreign key to HZ_PARTIES.
  • LOCK_DATE — The date and time the lock was applied; part of the composite primary key.
  • AUCTION_HEADER_ID — The negotiation header identifier, also a foreign key to PON_AUCTION_HEADERS_ALL.
  • BUYER_TP_CONTACT_ID — The buyer-side trading partner contact associated with the lock action; a foreign key to HZ_PARTIES.
  • LOCK_STATUS — The status indicator for the lock (for example, locked or unlocked).
  • LOCK_REASON — Free-text or coded reason explaining why the supplier was locked out.
  • ACTIVE_FLAG — Indicates whether the lock record is currently active.
  • CREATION_DATE, CREATED_BY — Standard audit columns capturing when and by whom the record was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification.

The surrogate primary key is PON_SUPPLIER_ACCESS_PK1, defined over (AUCTION_HEADER_ID_ORIG_AMEND, SUPPLIER_TRADING_PARTNER_ID, LOCK_DATE). A unique index, PON_SUPPLIER_ACCESS_U1, is defined over the same column set and serves as the documented business-key candidate, ensuring that a supplier can be locked only once per negotiation per lock date.

Common Use Cases and Queries

Typical scenarios include auditing which suppliers were locked out of a negotiation, reconstructing the sequence of lock and unlock events, and reporting on active locks at a point in time. A representative query joins the table to the auction header to resolve the negotiation name:

  • List currently active locks: SELECT auction_header_id, supplier_trading_partner_id, lock_date, lock_reason FROM pon_supplier_access WHERE active_flag = 'Y'.
  • Full lock history for a negotiation: SELECT * FROM pon_supplier_access WHERE auction_header_id = :auction_header_id ORDER BY lock_date.
  • Join to header: SELECT h.auction_header_id, h.*, s.supplier_trading_partner_id, s.lock_status FROM pon_auction_headers_all h, pon_supplier_access s WHERE h.auction_header_id = s.auction_header_id.
  • Resolve supplier identity: join SUPPLIER_TRADING_PARTNER_ID to HZ_PARTIES to obtain the party name for reporting.

These patterns support procurement audit reports, dispute investigation, and trend analysis of supplier lock-outs across sourcing events.

Related Objects

The following objects are the most significant referenced by or referencing PON_SUPPLIER_ACCESS, based on the documented foreign-key relationships.

  • PON_AUCTION_HEADERS_ALL — joined via AUCTION_HEADER_ID_ORIG_AMEND and AUCTION_HEADER_ID; the parent negotiation header.
  • HZ_PARTIES — joined via SUPPLIER_TRADING_PARTNER_ID; the supplier trading partner.
  • HZ_PARTIES — joined via BUYER_TP_CONTACT_ID; the buyer-side contact.
  • PON_AUCTION_HEADERS_ALL (via AUCTION_HEADER_ID) — alternate header reference for amended events.
  • Sourcing negotiation supplier-access screens and concurrent programs in the PON module that read and write lock status.