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
TheAP_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
(onVENDOR_SITE_ID
) andAP_SUPPLIER_SITES_N1
(onVENDOR_ID
). - APIs: The
AP_SUPPLIER_PKG
PL/SQL package provides programmatic access for CRUD operations. - Audit Columns:
CREATION_DATE
,LAST_UPDATE_DATE
, andLAST_UPDATED_BY
track changes.
Business Process Impact
Accurate maintenance ofAP_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
TheAP_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.
-
Table: AP_SUPPLIER_SITES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIER_SITES_ALL, object_name:AP_SUPPLIER_SITES_ALL, status:VALID, product: AP - Payables , description: AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. , implementation_dba_data: AP.AP_SUPPLIER_SITES_ALL ,
-
Table: AP_SUPPLIER_SITES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIER_SITES_ALL, object_name:AP_SUPPLIER_SITES_ALL, status:VALID, product: AP - Payables , description: AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes. , implementation_dba_data: AP.AP_SUPPLIER_SITES_ALL ,
-
APPS.ZX_TCM_BES_REGISTRATION_PVT dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.JA_CN_COA_EXP_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.EGO_IMPORT_PVT dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.DPP_REQUEST_STATUS_PVT dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.POS_PROFILE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.DPP_PRICING_PVT dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.IGI_CIS2007_UTIL_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_APXFPMDR_XMLP_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.JAI_PO_VSA_TRIGGER_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.ZX_AP_POPULATE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_BANK_CHARGE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_ETAX_SERVICES_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.POS_BULKLOAD_ENTITIES dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.JAI_PO_VSA_TRIGGER_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_BANK_CHARGE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.ZX_TCM_CONTROL_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_WEB_EXPORT_ER dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_PURGE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.POS_UTIL_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.POS_PROFILE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_ETAX_SERVICES_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.XLA_CA_BALANCES_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.IGI_STP_CREATE_PCK_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.PON_WITH_DRAW_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.ZX_AP_ACTG_POPULATE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.2.2
-
APPS.ZX_JL_EXTRACT_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.POS_UTIL_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.JAI_PO_VSA_TRIGGER_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_APPROVAL_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.EGO_ITEM_BULKLOAD_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_TAX_ENGINE_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_ISP_UTILITIES_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.JTF_RS_IMP_RES_PVT dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
APPS.POS_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1