Search Results ap_supplier_sites_all




The AP_SUPPLIER_SITES_ALL table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for storing supplier site-level information within the Accounts Payable (AP) module. It serves as a foundational data structure that enables organizations to manage vendor relationships, procurement processes, and payment transactions efficiently. Below is a detailed summary of its purpose, key attributes, relationships, and functional significance in Oracle EBS.

Purpose and Functional Context

The AP_SUPPLIER_SITES_ALL table stores detailed information about physical or logical locations associated with suppliers. Each supplier (AP_SUPPLIERS) can have multiple sites, allowing organizations to define distinct addresses, payment terms, banking details, and purchasing preferences per location. This granularity supports multi-site procurement, tax compliance, and payment processing workflows.

Key Attributes

The table includes columns that capture essential supplier site details:
  • VENDOR_SITE_ID: Primary key uniquely identifying the supplier site.
  • VENDOR_ID: Foreign key linking to AP_SUPPLIERS, associating the site with a supplier.
  • VENDOR_SITE_CODE: User-defined identifier for the site (e.g., "HQ" or "Warehouse").
  • ADDRESS_LINES: Physical address details (street, city, state, postal code).
  • COUNTRY: Country code for international tax/regulatory compliance.
  • PAY_GROUP_LOOKUP_CODE: Determines payment processing rules.
  • TERMS_ID: Payment terms (e.g., Net 30) linked to AP_TERMS.
  • ORG_ID: Multi-org identifier segregating data by operating unit.
  • INVOICE_CURRENCY_CODE: Default currency for invoices from this site.
  • PAYMENT_METHOD_LOOKUP_CODE: Preferred payment method (e.g., Electronic, Check).
  • BANK_ACCOUNT_NAME/ID: Banking details for electronic payments.
  • WITHHOLDING_TAX_ENABLED_FLAG: Controls tax withholding compliance.

Relationships with Other Modules

The table integrates with several Oracle EBS modules:
  • Purchasing (PO): Supplier sites are assigned to purchase orders and receipts.
  • Payables (AP): Invoices and payments reference VENDOR_SITE_ID for processing.
  • Tax (ZX): Address and country data drive tax calculations.
  • Cash Management (CE): Bank account details facilitate payment reconciliation.

Multi-Org Structure

The _ALL suffix indicates the table stores data across multiple operating units (Orgs). Access is controlled via ORG_ID and Virtual Private Database (VPD) policies, ensuring data isolation in shared-instance deployments.

Technical Considerations

  • Indexes: Key indexes include AP_SUPPLIER_SITES_U1 (on VENDOR_SITE_ID) and AP_SUPPLIER_SITES_N1 (on VENDOR_ID).
  • APIs: The AP_SUPPLIER_PKG PL/SQL package provides programmatic access for CRUD operations.
  • Audit Columns: CREATION_DATE, LAST_UPDATE_DATE, and LAST_UPDATED_BY track changes.

Business Process Impact

Accurate maintenance of AP_SUPPLIER_SITES_ALL ensures:
  • Correct invoice routing and payment processing.
  • Compliance with tax jurisdictions and reporting requirements.
  • Efficient procurement through site-specific terms and contacts.

Conclusion

The AP_SUPPLIER_SITES_ALL table is a cornerstone of Oracle EBS’s procure-to-pay lifecycle, enabling organizations to manage complex supplier hierarchies with precision. Its design supports scalability, regulatory compliance, and integration across financial and supply chain modules, making it indispensable for global enterprises running Oracle EBS 12.1.1 or 12.2.2.