Results for “fob_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_AUC_HEADERS_INTERFACE is the negotiation header staging table within the Oracle Sourcing (PON) module. It serves as the landing zone for negotiation (auction) header data imported from external systems, legacy applications, or third-party procurement platforms before that data is validated and transferred into the operational Sourcing tables. In Oracle EBS 12.1.1 and 12.2.2, this interface table is populated by external load programs, corrected through concurrent request error reporting, and ultimately consumed by the Sourcing import process to create live negotiation objects.

From a Data Vault modeling perspective, the ETRM heuristic classifies this object as satellite-leaning. This reflects its role as a dependent, transaction-accumulating structure that carries descriptive attribute payload keyed by an interface identifier, rather than acting as an independent business hub or an associative link. Modelers constructing a warehouse layer should treat PON_AUC_HEADERS_INTERFACE as a source for satellite-style attributes rather than a standalone dimension.

Key Information Stored

The table is owned by the PON schema and contains 36 documented columns. The surrogate primary key is INTERFACE_AUCTION_HEADER_ID, enforced by PON_AUC_HEADERS_INTERFACE_PK and mirrored by unique index PON_AUC_HEADERS_INTERFACE_U1. This single column is also the de facto business-key candidate, as each inbound negotiation header row receives a distinct interface identifier used to tie together its child interface rows.

The most significant descriptive columns include:

• NEG_TYPE and CONTRACT_TYPE — classify the negotiation being imported (for example, RFQ versus auction, and standard versus blanket agreement).
• SHIP_TO_LOCATION_ID and BILL_TO_LOCATION_ID — foreign keys to HR_LOCATIONS_ALL defining the default ship-to and bill-to addresses.
• CURRENCY_CODE, RATE_TYPE, RATE_DATE, and RATE — currency and exchange-rate attributes keyed to FND_CURRENCIES and GL_DAILY_CONVERSION_TYPES.
• SUPPLIER_ID and SUPPLIER_SITE_ID — the supplier and supplier site associated with the negotiation, with SUPPLIER_ID referencing PO_VENDORS.
• ORG_ID — the operating unit that owns the imported negotiation, essential for multi-org reporting.
• USER_ID — the FND_USER who submitted or will own the negotiation.
• PROCESS_STATUS — the import control flag indicating whether the row is pending, succeeded, or failed.
• SOURCE_DOC_NUMBER, SOURCE_DOC_ID, SOURCE_DOC_MSG, SOURCE_DOC_LINE_MSG, and SOURCE_DOC_MSG_APP — the source-system traceability and error-diagnostic columns used for reconciliation and troubleshooting.
• PO_AGREED_AMOUNT, PO_MIN_REL_AMOUNT, and PO_STYLE_ID — commercial terms governing the resulting purchase agreement.

Common Use Cases and Queries

The most frequent operational use is monitoring the interface loader: identifying rows still awaiting processing or flagged in error. A representative query selects the header identifier, supplier, process status, and error messages:

• SELECT interface_auction_header_id, neg_type, supplier_id, org_id, process_status FROM pon_auc_headers_interface WHERE process_status = 'PENDING';
• SELECT h.interface_auction_header_id, h.source_doc_number, h.source_doc_msg FROM pon_auc_headers_interface h WHERE h.process_status = 'ERROR';

Reporting use cases include reconciling the count of inbound source documents against successfully created negotiations, analyzing supplier participation trends by org, and auditing exchange-rate and payment-term defaults applied during import. Before re-running a failed import, technicians commonly purge or reset rows using the interface identifier, and they join to child tables to confirm complete header-to-line hierarchies were staged consistently.

Related Objects

PON_AUC_HEADERS_INTERFACE participates in a hub-and-satellite interface hierarchy anchored on INTERFACE_AUCTION_HEADER_ID. The principal dependent tables are:

• PON_AUC_ITEMS_INTERFACE — line-level negotiation data joined via INTERFACE_AUCTION_HEADER_ID.
• PON_AUC_SHIPMENTS_INTERFACE — shipment/fulfillment details for the imported negotiation.
• PON_PRICE_DIFFER_INTERFACE — price differential records tied to the header.
• PON_ATTRIBUTES_INTERFACE and PON_ATTACHMENTS_INTERFACE — attribute and attachment staging rows linked by the same identifier.

Referenced parent tables include HR_LOCATIONS_ALL (SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID), FND_CURRENCIES (CURRENCY_CODE), GL_DAILY_CONVERSION_TYPES (RATE_TYPE), FND_USER (USER_ID), and PO_VENDORS (SUPPLIER_ID). These foreign keys enforce referential integrity during the Sourcing import cycle and support validation of staged negotiation headers before they are promoted to live Sourcing data.