Search Results pon_auc_headers_interface




Overview
Explore in AI Chat

Overview

The PON_AUC_HEADERS_INTERFACE table is a critical data interface within the Oracle E-Business Suite (EBS) Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. As an interface table, its primary role is to serve as a staging area for importing or creating negotiation header data from external systems or legacy applications before it is validated and processed into the core transactional tables. This design pattern is standard in Oracle EBS for ensuring data integrity and facilitating complex data migrations or integrations. The table holds the foundational metadata for a negotiation, such as its title, dates, currency, and participating suppliers, which must be successfully loaded before related line items and shipments can be processed.

Key Information Stored

The table's structure is defined to capture the essential attributes of a sourcing negotiation header. Its primary key is INTERFACE_AUCTION_HEADER_ID, which uniquely identifies each staged negotiation record. Key columns, as indicated by the foreign key relationships, include SUPPLIER_ID (linking to PO_VENDORS), CURRENCY_CODE (linking to FND_CURRENCIES), and USER_ID (linking to FND_USER). Other significant columns typically found in such an interface include negotiation title, description, start and close dates, status, and location identifiers for shipping and billing (SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID). The RATE_TYPE column links to GL_DAILY_CONVERSION_TYPES, supporting currency conversion requirements for global sourcing events.

Common Use Cases and Queries

The primary use case is the bulk import of negotiation data via a concurrent program, such as the "Import Negotiations" process, which reads from this interface table, validates the data against EBS standards, and transfers it to the base table PON_AUCTION_HEADERS_ALL. Common operational queries involve monitoring the import process. For example, to identify records that failed processing, one might query for rows where the PROCESS_STATUS flag indicates an error. A typical diagnostic query would be:

For reporting on staged data prior to import, analysts may join this table with referenced entities like FND_USER or PO_VENDORS to present user and supplier names.

Related Objects

PON_AUC_HEADERS_INTERFACE is the central interface table with several dependent child interfaces, ensuring a hierarchical data load. As per the provided metadata, the key related objects are:

  • Child Interface Tables: PON_AUC_ITEMS_INTERFACE, PON_AUC_SHIPMENTS_INTERFACE, and PON_PRICE_DIFFER_INTERFACE. These tables store line items, shipment schedules, and price differentials, respectively, and are linked via the FOREIGN KEY on INTERFACE_AUCTION_HEADER_ID.
  • Referenced Lookup Tables: The table enforces data integrity through foreign keys to HR_LOCATIONS_ALL (for locations), FND_CURRENCIES, GL_DAILY_CONVERSION_TYPES, FND_USER, and PO_VENDORS.
  • Target Base Table: The successful processing of records in this interface typically results in the creation of a corresponding record in the transactional table PON_AUCTION_HEADERS_ALL.