Search Results pon_auc_items_interface




Overview
Explore in AI Chat

Overview

The PON_AUC_ITEMS_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. It functions as a staging table designed to temporarily hold item-level data imported from external systems or processes before this data is validated and processed into the core negotiation tables. Its primary role is to facilitate the bulk import of line item information for sourcing documents, such as Requests for Quotation (RFQs) and Reverse Auctions, enabling integration with third-party systems, data migration, and high-volume data entry operations. The table is part of a larger interface architecture that ensures data integrity by separating the import staging from the transactional base tables.

Key Information Stored

The table stores a comprehensive set of attributes for each negotiation line item awaiting import. Its structure is defined by a composite primary key consisting of INTERFACE_AUCTION_HEADER_ID and INTERFACE_LINE_NUMBER, which uniquely identifies each item record and links it to its parent header in the PON_AUC_HEADERS_INTERFACE table. Key columns include LINE_TYPE_ID, which references PO_LINE_TYPES_B to define the item's type (e.g., Goods, Services), and CATEGORY_ID, which references MTL_CATEGORIES_B to classify the item within the inventory catalog. Other significant data points typically stored are item description, quantity, unit of measure, need-by date, and any price differential or shipment-related details that will be processed into child interface tables.

Common Use Cases and Queries

The primary use case is the batch import of negotiation line items via a custom program or the standard Sourcing Open Interface. A typical operational query involves identifying items pending import for a specific negotiation header to monitor the interface process. For example:

  • SELECT interface_line_number, item_description, quantity FROM pon_auc_items_interface WHERE interface_auction_header_id = <header_id> AND batch_id = <batch_id> ORDER BY interface_line_number;

Another common scenario is troubleshooting failed imports by joining with the headers interface table to find items with processing errors:

  • SELECT pahi.auction_header_id, paii.interface_line_number, paii.error_message FROM pon_auc_headers_interface pahi, pon_auc_items_interface paii WHERE pahi.interface_auction_header_id = paii.interface_auction_header_id AND paii.process_status = 'ERROR';

Related Objects

The PON_AUC_ITEMS_INTERFACE table has defined relationships with several other key interface and base tables, as documented in the ETRM metadata. Its primary foreign key dependency is on the PON_AUC_HEADERS_INTERFACE table via the INTERFACE_AUCTION_HEADER_ID column, ensuring every item is associated with a valid negotiation header in the interface. It also references base tables for validation: PO_LINE_TYPES_B (via LINE_TYPE_ID) and MTL_CATEGORIES_B (via CATEGORY_ID). Furthermore, it serves as a parent table to child interface tables that hold more granular data: PON_AUC_SHIPMENTS_INTERFACE (for shipment schedules) and PON_PRICE_DIFFER_INTERFACE (for price differentials), with both child tables using the composite key (INTERFACE_AUCTION_HEADER_ID, INTERFACE_LINE_NUMBER) for the relationship.