Search Results ap_suppliers

Overview

The AP_SUPPLIERS table is a core master data table within the Oracle E-Business Suite Payables (AP) module, specifically for releases 12.1.1 and 12.2.2. It serves as the primary repository for supplier-level attributes, forming the foundational record for every trading partner from whom an organization procures goods or services. Each unique supplier is represented by a single row in this table, identified by a system-generated VENDOR_ID. This table is central to the Procure-to-Pay cycle, as it holds the essential information required for invoice processing, payment execution, tax reporting, and 1099 compliance. Its integrity is critical, as it is referenced by numerous transactional and setup tables across the EBS ecosystem.

Key Information Stored

The table's primary key is VENDOR_ID, which uniquely identifies each supplier. While the full column list is extensive, key attributes typically stored include the supplier name (VENDOR_NAME), supplier number (SEGMENT1), tax identification number (VAT_REGISTRATION_NUM), and type (e.g., TAX_REPORTING_NAME). It also holds critical flags controlling supplier status and payment behavior, such as INACTIVE_DATE and HOLD_FLAG. The table stores links to other setup entities, evidenced by foreign keys like AWT_GROUP_ID, which links to the AP_AWT_GROUPS table for automatic withholding tax configuration. Other significant columns often relate to payment terms, invoicing and payment currency defaults, and 1099 reporting information.

Common Use Cases and Queries

This table is fundamental for reporting, data fixes, and integration. Common scenarios include generating a master supplier list, analyzing supplier creation trends, and identifying suppliers placed on hold. A typical query to retrieve active suppliers for a specific country would be:

• SELECT VENDOR_ID, VENDOR_NAME, SEGMENT1 FROM AP.AP_SUPPLIERS WHERE COUNTRY = 'US' AND INACTIVE_DATE IS NULL;

For troubleshooting payment holds, one might query:

• SELECT VENDOR_ID, VENDOR_NAME, HOLD_FLAG, HOLD_REASON FROM AP.AP_SUPPLIERS WHERE HOLD_FLAG = 'Y';

This table is also central in joins for invoice and payment reporting, linking transactional data in tables like AP_INVOICES_ALL to the supplier master record.

Related Objects

As indicated by the extensive foreign key relationships in the metadata, AP_SUPPLIERS is a heavily referenced parent table. Its most direct child is AP_SUPPLIER_SITES_ALL, which stores site-specific information (e.g., addresses, contacts) for each VENDOR_ID. It is referenced by transactional tables in other products, such as OKL_TRX_AP_INVS_ALL_B in Oracle Lease and Finance Management and JAI_AP_TDS_INV_PAYMENTS in localized tax solutions. The relationship with AP_AWT_GROUPS demonstrates its role in tax setup. For programmatic access and validation, key APIs include AP_SUPPLIER_PKG and the Supplier Open Interface (AP_SUPPLIERS_INT).