Search Results pon_auc_price_differ_int




Overview
Explore in AI Chat

Overview

PON_AUC_PRICE_DIFFER_INT is a temporary (interface) table in the PON — Sourcing module of Oracle E-Business Suite, owned by the PON schema. Its documented purpose is to hold price differential details that are imported from or exported to Microsoft Excel during auction and negotiation maintenance. In EBS 12.1.1 and 12.2.2 the table functions as a staging area: users maintain price differential values offline in a spreadsheet, upload them through the Sourcing application, and the concurrent/interface logic reads the staged rows, validates them, and applies them to the live auction line data. Rows are transient by design and are typically purged after the import or export process completes.

From a heuristic Data Vault modeling perspective, the metadata’s mined FK structure classifies this object as standalone, meaning it has no child dependents and behaves as a source-system staging table rather than a persistent hub, link, or satellite. The only mined foreign key points to PON_AUCTION_HEADERS_ALL via AUCTION_HEADER_ID, which suggests the interface rows are anchored to a single auction header for the duration of the Excel round trip.

Key Information Stored

The documented schema exposes 16 columns. The most significant are:

  • INTERFACE_LINE_ID — Surrogate identifier for each staged price differential line; the primary key candidate for this interface table.
  • AUCTION_HEADER_ID — Foreign key to PON_AUCTION_HEADERS_ALL; the auction to which the differential applies. Primary business-key candidate when combined with line and sequence.
  • AUCTION_LINE_NUMBER and AUCTION_SHIPMENT_NUMBER — Identify the specific line and shipment within the auction whose price differential is being imported/exported.
  • SEQUENCE_NUMBER — Ordering/grouping of differential entries, typically used when multiple differentials exist per line.
  • PRICE_TYPE, PRICE_TYPE_NAME, PRICE_TYPE_DESC — Code, name, and description of the price type (for example, a discount, surcharge, or freight differential) qualifying the line price.
  • MULTIPLIER — Numeric factor applied to the base price to derive the differential value.
  • INTERFACE_HEADER_ID — Groups the interface rows under one import/export batch header.
  • BATCH_ID#1 — Batch identifier used by the interface/concurrent program.
  • Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include validating an Excel upload before it is applied, troubleshooting a failed import, and exporting current differentials for a given auction. A representative query joins back to the auction header:

  • SELECT i.auction_header_id, i.auction_line_number, i.sequence_number, i.price_type, i.multiplier FROM pon.pon_auc_price_differ_int i WHERE i.auction_header_id = :p_auction_header_id ORDER BY i.auction_line_number, i.sequence_number;
  • SELECT i.* FROM pon.pon_auc_price_differ_int i, pon.pon_auction_headers_all h WHERE i.auction_header_id = h.auction_header_id AND h.auction_header_id = :p_id;
  • DELETE FROM pon.pon_auc_price_differ_int WHERE interface_header_id = :p_batch; — used to clear stale interface rows after a failed run.

Related Objects

  • PON_AUCTION_HEADERS_ALL — Parent auction header; joined on AUCTION_HEADER_ID.
  • PON_AUCTION_LINES_ALL / PON_AUCTION_LINE_SHIPMENTS — Live line and shipment records populated from the interface via AUCTION_LINE_NUMBER and AUCTION_SHIPMENT_NUMBER.
  • PON_AUCTION_PRICE_DIFFERENTIALS — Persistent differential storage behind the interface table.
  • PON_AUCTION_HEADERS_INTERFACE and other PON interface tables — Concurrent with the same import/export cycle.
  • Sourcing auction import/export concurrent programs and the Auction Workbench UI — Consume and populate the staged rows.