Search Results ap_supplier_sites_all




Overview
Explore in AI Chat

Overview

AP_SUPPLIER_SITES_ALL is the Oracle Payables table that stores supplier site level attributes within Oracle E-Business Suite 12.1.1 and 12.2.2. A supplier in Oracle Payables (AP_SUPPLIERS) can have one or more sites, and each site represents a specific purchasing, payment, or remittance location associated with that supplier. The table is owned by the AP schema and is described in the ETRM repository as storing "information about your supplier site level attributes." Because a supplier may transact with a purchasing organization from multiple addresses with distinct payment terms, bank accounts, tax settings, and holding rules, AP_SUPPLIER_SITES_ALL is the operational record that drives invoice entry, payment processing, tax calculation, and withholding behavior at the site level.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure treats AP_SUPPLIER_SITES_ALL as a hub. This suggests it functions as a core business entity — the supplier site — whose identity is anchored by its own primary key, independent of the descriptive attributes that may be tracked elsewhere or versioned separately.

Key Information Stored

The table contains 164 columns in the documented 12.2.2 physical schema. The most significant columns are:

Two unique indexes are documented: AP_SUPPLIER_SITES_U1 (VENDOR_SITE_ID), the primary key, and AP_SUPPLIER_SITES_U2 (VENDOR_ID, VENDOR_SITE_CODE, ORG_ID), which is the business-key candidate that enforces uniqueness of the site code within a supplier and operating unit.

Common Use Cases and Queries

AP_SUPPLIER_SITES_ALL is queried in nearly every Payables workflow. Typical use cases include retrieving active payment sites for a supplier, validating that a site permits invoicing, and identifying sites configured for a specific pay group or currency.

A common pattern is to list active pay sites with their payment defaults:

  • SELECT ass.vendor_site_id, ass.vendor_site_code, ass.pay_group_lookup_code, ass.terms_id, ass.payment_method_lookup_code, ass.invoice_currency_code FROM ap_supplier_sites_all ass WHERE ass.vendor_id = :vendor_id AND ass.pay_site_flag = 'Y' AND (ass.inactive_date IS NULL OR ass.inactive_date > SYSDATE) AND ass.org_id = :org_id;

Another frequent requirement is to join supplier and site information for invoice reconciliation or reporting:

  • SELECT sup.vendor_name, ass.vendor_site_code, inv.invoice_num, inv.invoice_amount FROM ap_invoices_all inv JOIN ap_supplier_sites_all ass ON inv.vendor_site_id = ass.vendor_site_id JOIN ap_suppliers sup ON ass.vendor_id = sup.vendor_id WHERE inv.org_id = :org_id;

Site-level hold analysis is also common, particularly to identify sites where all payments are held:

  • SELECT vendor_site_id, vendor_site_code, hold_reason FROM ap_supplier_sites_all WHERE hold_all_payments_flag = 'Y' AND org_id = :org_id;

Related Objects

AP_SUPPLIER_SITES_ALL sits at the center of an extensive foreign key network. The most significant related objects are:

These relationships confirm that AP_SUPPLIER_SITES_ALL is a foundational hub: invoices, payments, contacts, and multiple specialized extensions all resolve their supplier site context through its primary key.