Search Results ap_suppliers_int

Overview

The AP_SUPPLIERS_INT table is a critical interface table within the Oracle E-Business Suite Payables module (AP). Its primary role is to serve as a staging area for supplier data before it is formally imported into the core supplier master table, PO_VENDORS. This table facilitates the bulk import of supplier information from external systems, legacy data conversions, or data migration projects. The Oracle Payables application processes the validated records from this interface table to create new supplier records or update existing ones, ensuring data integrity and adherence to business rules before the information becomes active in the transactional system.

Key Information Stored

The table's columns directly map to corresponding fields in the PO_VENDORS table. While the full column list is extensive, key transactional and identifying fields typically include VENDOR_INTERFACE_ID (the primary key sequence for interface records), VENDOR_NAME, VENDOR_NUMBER, and SEGMENT1 (which often holds the supplier number). It also holds critical control and status columns such as PROCESS_FLAG, which indicates whether a record is ready for processing (e.g., 'N' for New, 'P' for Processed, 'E' for Error), and ERROR_CODE, which stores messages for failed records. Other essential data includes tax identifiers, payment terms, and address information.

Common Use Cases and Queries

The predominant use case is the execution of the "Supplier Import" concurrent program, which validates and transfers data from AP_SUPPLIERS_INT to PO_VENDORS. Common SQL queries involve monitoring the interface for troubleshooting. For instance, to identify records that failed import, a query would filter on PROCESS_FLAG = 'E' and review the ERROR_CODE. To check for pending records, one would query for PROCESS_FLAG = 'N'. Data is typically populated into this table via SQL*Loader scripts, custom PL/SQL programs, or database links, often as part of a scheduled integration. Reporting from this table is generally limited to monitoring the status of import jobs rather than operational reporting, which is done from the core PO_VENDORS table.

Related Objects

• PO_VENDORS: The ultimate target table for successful interface records. This is the master supplier table used across Oracle EBS.
• AP_SUPPLIER_INT_REJECTIONS: A view that may provide a detailed summary of records that failed the import process.
• Supplier Open Interface (API): The programmatic interface, often leveraged by custom code, that governs the validation and transfer of data from AP_SUPPLIERS_INT.
• Concurrent Program: "Supplier Import" is the standard EBS program that processes records from this interface table.