Search Results ap_suppliers
The AP_SUPPLIERS
table is a fundamental data structure in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, serving as the primary repository for supplier information within the Accounts Payable (AP) module. This table stores comprehensive details about vendors, including their legal entities, payment terms, tax identifiers, and contact information, making it a critical component for procurement, invoicing, and payment processing workflows. Below is a detailed technical and functional analysis of the AP_SUPPLIERS
table in Oracle EBS.
1. Table Structure and Key Columns
TheAP_SUPPLIERS
table consists of over 150 columns, categorized into logical segments:
- Supplier Identification:
VENDOR_ID
(Primary Key): Unique identifier for each supplier.VENDOR_NAME
: Legal name of the supplier.SEGMENT1
: Supplier number assigned by the system or user.
- Contact and Address Details:
ADDRESS_LINE1
,CITY
,STATE
,ZIP
: Physical address fields.PHONE
,FAX
,EMAIL
: Communication details.
- Tax and Compliance:
VAT_REGISTRATION_NUM
: Tax registration number (e.g., VAT/GST).TAX_REPORTING_NAME
: Alternate name for tax reporting.
- Payment and Financial Controls:
TERMS_ID
: Default payment terms linked toAP_TERMS
.INVOICE_CURRENCY_CODE
: Preferred currency for invoicing.PAY_GROUP_LOOKUP_CODE
: Grouping for payment processing.
2. Integration with Other Modules
TheAP_SUPPLIERS
table integrates with multiple Oracle EBS modules:
- Purchasing (PO): Supplier data is shared with
PO_VENDORS
for procurement. - General Ledger (GL): Tax and payment terms influence journal entries.
- Cash Management (CE): Bank account details (
AP_BANK_ACCOUNTS
) are linked viaVENDOR_ID
.
3. Key Functional Dependencies
- Supplier Sites: The
AP_SUPPLIER_SITES
table stores location-specific details (e.g., shipping addresses) and referencesVENDOR_ID
. - Invoices:
AP_INVOICES
usesVENDOR_ID
to associate invoices with suppliers. - 1099 Reporting: U.S. tax compliance relies on
AP_SUPPLIERS
flags likeTYPE_1099
andFEDERAL_REPORTABLE_FLAG
.
4. Customizations and Extensions
Common extensions include:- Descriptive Flexfields (DFFs): Custom attributes (e.g., industry-specific codes) added to the table.
- API Usage: The
AP_SUPPLIERS_PKG
PL/SQL package provides APIs for programmatic supplier management.
5. Data Security and Auditing
- Access Control: Secured via Oracle EBS responsibilities and function exclusions.
- Audit Columns:
CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
, andLAST_UPDATED_BY
track changes.
6. Performance Considerations
- Indexes on
VENDOR_ID
,SEGMENT1
, andVENDOR_NAME
optimize query performance. - Partitioning strategies may be applied for large-scale implementations.
Conclusion
TheAP_SUPPLIERS
table is a cornerstone of Oracle EBS Accounts Payable, enabling end-to-end supplier lifecycle management. Its design supports global compliance, multi-currency transactions, and seamless integration with procurement and financial systems. Understanding its structure and relationships is essential for effective configuration, reporting, and customization in Oracle EBS 12.1.1 and 12.2.2 environments.
-
Table: AP_SUPPLIERS
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIERS, object_name:AP_SUPPLIERS, status:VALID, product: AP - Payables , description: AP_SUPPLIERS stores information about your supplier level attributes. , implementation_dba_data: AP.AP_SUPPLIERS ,
-
Table: AP_SUPPLIERS
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIERS, object_name:AP_SUPPLIERS, status:VALID, product: AP - Payables , description: AP_SUPPLIERS stores information about your supplier level attributes. , implementation_dba_data: AP.AP_SUPPLIERS ,
-
APPS.ZX_SRVC_TYP_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.FV_CCR_UTIL_PVT dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_WEB_EXPENSE_WF dependencies on AP_SUPPLIERS
12.1.1
-
APPS.EGO_IMPORT_PVT dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_BANKACCT_INACTIVE_WF_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.XLA_TB_AP_REPORT_PVT dependencies on AP_SUPPLIERS
12.1.1
-
APPS.DPP_TRANSACTION_PVT dependencies on AP_SUPPLIERS
12.1.1
-
APPS.JE_IT_LISTING_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.JL_JLZZPSSR_XMLP_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.IGI_CIS2007_CDROM_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_OTHR_CHRG_MATCH_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.JE_IT_XML_LISTING_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.IBY_PAYGROUP_PUB dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_PAY_IN_FULL_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_VENDORS_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.ZX_TCM_BES_REGISTRATION_PVT dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_INVOICES_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.OKL_FXL_PVT dependencies on AP_SUPPLIERS
12.1.1
-
APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIERS
12.1.1
-
APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_SUPPLIERS
12.1.1
-
APPS.FUN_AP_TRANSFER dependencies on AP_SUPPLIERS
12.2.2
-
APPS.OZF_SD_BATCH_PVT dependencies on AP_SUPPLIERS
12.2.2
-
APPS.ECE_AP_PAYMENT dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_WEB_AUDIT_UTILS dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_ACCTG_DATA_FIX_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.OZF_APPROVAL_PVT dependencies on AP_SUPPLIERS
12.2.2
-
APPS.JAI_PO_V_TRIGGER_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.APRX_WT dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_ETAX_SERVICES_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_SUPPLIER_INFO_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.EGO_ITEM_BULKLOAD_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.OTA_TFH_API_BUSINESS_RULES dependencies on AP_SUPPLIERS
12.2.2
-
APPS.POS_SUP_PROF_PRG_GRP dependencies on AP_SUPPLIERS
12.2.2
-
APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.IBY_EXT_BANKACCT_PUB dependencies on AP_SUPPLIERS
12.2.2
-
APPS.ZX_TCM_BES_REGISTRATION_PVT dependencies on AP_SUPPLIERS
12.2.2
-
APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_SUPPLIERS
12.2.2
-
APPS.OKL_EQUIPMENT_EXCHANGE_PVT dependencies on AP_SUPPLIERS
12.2.2
-
APPS.PON_OPEN_INTERFACE_PVT dependencies on AP_SUPPLIERS
12.2.2
-
APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on AP_SUPPLIERS
12.2.2