Search Results interface_shipment_number

Overview

The PON_PRICE_DIFFER_INTERFACE table is a staging table within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to serve as a data interface for importing price differential information into the system during the creation or update of negotiations (auctions). Price differentials are mechanisms that adjust the base price of an item based on specific attributes, such as quantity breaks, supplier locations, or shipment destinations. This table temporarily holds the differential data from external sources or legacy systems before it is validated and processed into the core transactional tables, ensuring data integrity and facilitating bulk data operations.

Key Information Stored

The table stores records that uniquely identify each price differential within the context of an imported negotiation line and shipment. The primary key is a composite of four columns, establishing the critical relationships for the data. The column INTERFACE_AUCTION_HEADER_ID is the unique identifier for the negotiation header record in the interface. INTERFACE_LINE_NUMBER identifies the specific item line within that negotiation. INTERFACE_SHIPMENT_NUMBER denotes the shipment associated with the line. Finally, INTERFACE_PRICE_DIFFER_NUMBER uniquely sequences the price differentials for a given line and shipment. Other typical columns in such interface tables, though not explicitly listed in the provided metadata, would include the differential type, adjustment value or percentage, applicable attribute, and processing status flags (e.g., ERROR_FLAG, ERROR_MESSAGE).

Common Use Cases and Queries

The primary use case is the bulk import of complex pricing structures into Sourcing negotiations via custom programs or data conversion scripts. A typical process involves populating this table along with its parent interface tables (PON_AUC_HEADERS_INTERFACE, PON_AUC_ITEMS_INTERFACE, PON_AUC_SHIPMENTS_INTERFACE) and then calling the standard import concurrent program to validate and transfer the data. Common queries involve checking for unprocessed records or identifying errors. For example, to find all price differentials for a specific interface auction header, one might use:

• SELECT * FROM PON_PRICE_DIFFER_INTERFACE WHERE INTERFACE_AUCTION_HEADER_ID = <header_id> ORDER BY INTERFACE_LINE_NUMBER, INTERFACE_SHIPMENT_NUMBER;

Reporting from this table is generally limited to monitoring the interface process itself, rather than operational reporting, which would query the base transactional tables like PON_PRICE_DIFFERENTIALS after successful import.

Related Objects

As defined by its foreign keys, PON_PRICE_DIFFER_INTERFACE has a strict hierarchical dependency on three other interface tables. It is a child of PON_AUC_SHIPMENTS_INTERFACE, which is itself a child of PON_AUC_ITEMS_INTERFACE, which is a child of PON_AUC_HEADERS_INTERFACE. This structure mirrors the data relationships in the transactional schema. The successful processing of records in this table by the standard import program results in the creation of corresponding records in the base table PON_PRICE_DIFFERENTIALS. The table is integral to the Open Interface API for Sourcing negotiations.