Search Results pon_auc_shipments_interface




Overview
Explore in AI Chat

Overview

The PON_AUC_SHIPMENTS_INTERFACE table is a critical data interface object within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It functions as a staging table designed to temporarily hold shipment-related information for negotiations (auctions) that are being imported into the system via a programmatic or batch process. Its primary role is to facilitate the data validation and loading of complex negotiation shipment details from external sources before they are transferred into the base transactional tables, ensuring data integrity and consistency in the sourcing lifecycle.

Key Information Stored

The table stores shipment details associated with specific lines of a negotiation being imported. Its structure is defined by a composite primary key consisting of INTERFACE_AUCTION_HEADER_ID, INTERFACE_SHIP_NUMBER, and INTERFACE_LINE_NUMBER, which uniquely identifies each shipment record within the context of an imported negotiation header and line. Key data points typically held in this interface table include shipment quantities, promised dates, and delivery details. A significant foreign key relationship is established with the HR_LOCATIONS_ALL table via the SHIP_TO_LOCATION_ID column, linking the imported shipment to a valid ship-to location defined within Oracle HRMS.

Common Use Cases and Queries

The primary use case is the bulk import of negotiation data, often from legacy systems or through integration with third-party applications. Data is inserted into this interface table, after which a concurrent request (such as the "Import Sourcing Negotiations" program) processes the records, validates them against business rules, and loads them into the main application tables like PON_AUCTION_SHIPMENTS_ALL. Common queries involve monitoring the interface process. For example, to identify pending import records or errors for a specific batch:

  • SELECT interface_auction_header_id, interface_line_number, interface_ship_number, process_status FROM pon_auc_shipments_interface WHERE batch_id = :p_batch_id;
  • SELECT * FROM pon_auc_shipments_interface WHERE interface_auction_header_id = :p_header_id ORDER BY interface_line_number, interface_ship_number;

Reporting use cases focus on auditing the data flow through the interface and troubleshooting failed imports by examining records that were not successfully processed.

Related Objects

As per the provided metadata, PON_AUC_SHIPMENTS_INTERFACE has integral relationships with other sourcing interface tables. It is a child table to PON_AUC_HEADERS_INTERFACE and PON_AUC_ITEMS_INTERFACE, ensuring shipment data aligns with an existing imported negotiation header and line. It is also a parent table to PON_PRICE_DIFFER_INTERFACE, which stores price differential information specific to a shipment. The key dependent object is the concurrent program or API that reads from this table to populate the transactional base tables, such as PON_AUCTION_SHIPMENTS_ALL. The foreign key to HR_LOCATIONS_ALL ensures location validation during the import process.