Search Results action

Deep Dive into SQLAP_Tables.html in Oracle EBS 12.1.1 and 12.2.2

The SQLAP_Tables.html file in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 serves as a critical reference document for the underlying database tables associated with the SQL Accounts Payable (SQLAP) module. This file is typically part of the technical documentation suite provided by Oracle, detailing the schema structure, relationships, and key attributes of tables used in the AP module. Below is a comprehensive breakdown of its significance, structure, and usage in Oracle EBS implementations.

Purpose and Importance

The SQLAP_Tables.html file provides a structured overview of the database tables that support the Accounts Payable functionality in Oracle EBS. It is indispensable for technical consultants, developers, and database administrators who need to:

Understand the data model of the AP module.
Write custom reports or integrations using SQL queries.
Troubleshoot data-related issues.
Perform data migrations or upgrades.

Key Tables Covered

The document typically includes details about the following core tables (among others):

AP_INVOICES_ALL: Stores invoice headers, including supplier, invoice date, and payment terms.
AP_INVOICE_DISTRIBUTIONS_ALL: Captures accounting distributions for invoice lines.
AP_CHECKS_ALL: Contains payment details such as check numbers and payment dates.
AP_SUPPLIERS: Master table for supplier information.
AP_PAYMENT_SCHEDULES_ALL: Tracks payment due dates and amounts.

Structure of the Document

The SQLAP_Tables.html file is organized to provide:

Table Descriptions: High-level explanations of each table's purpose.
Column Details: Lists of columns with data types, constraints, and descriptions.
Primary and Foreign Keys: Relationships between tables for join conditions.
Indexes: Information on indexed columns for performance tuning.

Usage in Oracle EBS 12.1.1 vs. 12.2.2

While the core AP tables remain consistent across versions, differences may arise in:

New Columns: Oracle 12.2.2 may introduce additional columns to support enhanced features.
Deprecated Tables: Some tables may be marked for deprecation in newer releases.
Online Patching (ADOP): In 12.2.2, table structures may align with the Online Patching framework.

Practical Applications

Technical teams leverage this document for:

Custom Reporting: Writing SQL queries for AP-related reports.
Data Fixes: Correcting data inconsistencies via direct SQL updates.
Integration Development: Mapping AP data to external systems.

Conclusion

The SQLAP_Tables.html file is a vital resource for anyone working with the Accounts Payable module in Oracle EBS 12.1.1 or 12.2.2. Its detailed table definitions and relationships enable efficient development, troubleshooting, and data management, ensuring smooth AP operations in enterprise environments.

Lookup Type: PURGE ACTION 12.2.2
product: AP - Payables , meaning: Purge Action , description: Various purge actions ,
Lookup Type: PURGE ACTION 12.1.1
product: AP - Payables , meaning: Purge Action , description: Various purge actions ,
Lookup Type: TRANSACTION ACTION 12.1.1
product: AP - Payables , meaning: Transaction Action , description: Used by check recon to determine how to handle flat-file records ,
Lookup Type: TRANSACTION ACTION 12.2.2
product: AP - Payables , meaning: Transaction Action , description: Used by check recon to determine how to handle flat-file records ,
Lookup Type: PAYMENTBATCH CONFIRM ACTION 12.2.2
product: AP - Payables , meaning: Paymentbatch Confirm Action , description: Payment batch confirmation decision point options ,
Lookup Type: STOP PAYMENT ACTION 12.2.2
product: AP - Payables , meaning: Stop Payment Action , description: Action choices from Stop Payment form ,
Lookup Type: PAYMENTBATCH CONFIRM ACTION 12.1.1
product: AP - Payables , meaning: Paymentbatch Confirm Action , description: Payment batch confirmation decision point options ,
Lookup Type: STOP PAYMENT ACTION 12.1.1
product: AP - Payables , meaning: Stop Payment Action , description: Action choices from Stop Payment form ,
Lookup Type: INV_LINE_VIEW_BY 12.1.1
product: AP - Payables , meaning: Invoice Line View By ,
Lookup Type: INV_LINE_VIEW_BY 12.2.2
product: AP - Payables , meaning: Invoice Line View By ,
Lookup Type: OIE_APWUPDM_ACTION 12.1.1
product: AP - Payables , meaning: Expenses Upload Rates Action , description: Expenses Upload Rates Action ,
Lookup Type: OIE_APWUPDM_ACTION 12.2.2
product: AP - Payables , meaning: Expenses Upload Rates Action , description: Expenses Upload Rates Action ,
Lookup Type: AP_PAY_SRV_REQ_DASHBD_STATUS 12.1.1
product: AP - Payables , meaning: Payment Manager Payment Process Request Dashboard Status , description: Payment Manager Payment Process Request Dashboard Status ,
Lookup Type: TAX UTILITY ACTIONS 12.1.1
product: AP - Payables , meaning: Tax Utility Actions , description: Actions available for the Update Tax Details Utility ,
Lookup Type: AP_PAY_SRV_REQ_DASHBD_STATUS 12.2.2
product: AP - Payables , meaning: Payment Manager Payment Process Request Dashboard Status , description: Payment Manager Payment Process Request Dashboard Status ,
Lookup Type: TAX UTILITY ACTIONS 12.2.2
product: AP - Payables , meaning: Tax Utility Actions , description: Actions available for the Update Tax Details Utility ,
Lookup Type: EXPENSE REPORT STATUS 12.1.1
product: AP - Payables , meaning: Expense Report Status , description: Expense Report Status ,
View: FINANCIALS_PURGES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.FINANCIALS_PURGES_V, object_name:FINANCIALS_PURGES_V, status:VALID, product: AP - Payables , description: (Release 10SC Only) , implementation_dba_data: APPS.FINANCIALS_PURGES_V ,
Lookup Type: PURGE STATUS 12.2.2
product: AP - Payables , meaning: Purge Status , description: Status and action choices for purge process ,
Lookup Type: PURGE STATUS 12.1.1
product: AP - Payables , meaning: Purge Status , description: Status and action choices for purge process ,
View: FINANCIALS_PURGES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLAP.FINANCIALS_PURGES_V, object_name:FINANCIALS_PURGES_V, status:VALID, product: AP - Payables , description: (Release 10SC Only) , implementation_dba_data: APPS.FINANCIALS_PURGES_V ,
Lookup Type: EXPENSE REPORT STATUS 12.2.2
product: AP - Payables , meaning: Expense Report Status , description: Expense Report Status ,
File: RecurringInvoices.pdf 12.2.2
product: AP - Payables , size: 61.29 KBytes , file_type: PDF Diagram ,
File: Credit_Cards.pdf 12.2.2
product: AP - Payables , size: 66.999 KBytes , file_type: PDF Diagram ,
File: Summary.pdf 12.1.1
product: AP - Payables , size: 106.148 KBytes , file_type: PDF Diagram ,
File: FA_Integration.pdf 12.1.1
product: AP - Payables , size: 43.136 KBytes , file_type: PDF Diagram ,
File: Expense_Reports.pdf 12.1.1
product: AP - Payables , size: 34.793 KBytes , file_type: PDF Diagram ,
File: PA_Integration.pdf 12.1.1
product: AP - Payables , size: 53.431 KBytes , file_type: PDF Diagram ,
File: Suppliers.pdf 12.1.1
product: AP - Payables , size: 87.383 KBytes , file_type: PDF Diagram ,
File: GL_Integration.pdf 12.1.1
product: AP - Payables , size: 60.596 KBytes , file_type: PDF Diagram ,
File: PurchasingIntegration.pdf 12.2.2
product: AP - Payables , size: 96.334 KBytes , file_type: PDF Diagram ,
File: Recurring_Invoices.pdf 12.1.1
product: AP - Payables , size: 55.419 KBytes , file_type: PDF Diagram ,
File: Payment_Batches.pdf 12.1.1
product: AP - Payables , size: 105.972 KBytes , file_type: PDF Diagram ,
File: Credit_Cards.pdf 12.1.1
product: AP - Payables , size: 66.999 KBytes , file_type: PDF Diagram ,
File: FixedAssetsIntegration.pdf 12.2.2
product: AP - Payables , size: 100.442 KBytes , file_type: PDF Diagram ,
File: Expense_Reports.pdf 12.2.2
product: AP - Payables , size: 34.793 KBytes , file_type: PDF Diagram ,
File: GeneralLedgerIntegration.pdf 12.2.2
product: AP - Payables , size: 85.26 KBytes , file_type: PDF Diagram ,
File: PO_Integration.pdf 12.1.1
product: AP - Payables , size: 88.695 KBytes , file_type: PDF Diagram ,
File: ProjectIntegration.pdf 12.2.2
product: AP - Payables , size: 75.004 KBytes , file_type: PDF Diagram ,
File: PaymentProcessRequests.pdf 12.2.2
product: AP - Payables , size: 132.838 KBytes , file_type: PDF Diagram ,
File: InvoicePayment.pdf 12.2.2
product: AP - Payables , size: 189.316 KBytes , file_type: PDF Diagram ,
File: SupplierTCAIntegration.pdf 12.2.2
product: AP - Payables , size: 130.067 KBytes , file_type: PDF Diagram ,
Lookup Type: INV_LINE_ACTION_TYPE 12.1.1
product: AP - Payables , meaning: Invoice Line Action Type ,
Lookup Type: INV_LINE_ACTION_TYPE 12.2.2
product: AP - Payables , meaning: Invoice Line Action Type ,
File: SQLAPProduct_Dependencies.html 12.1.1
product: AP - Payables , size: 178.228 KBytes , file_type: HTML Report , description: SQLAPProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the AP product. ,
File: SQLAP_Dependencies.html 12.2.2
product: AP - Payables , size: 617.858 KBytes , file_type: HTML Report , description: SQLAP_Dependencies.html is an html report that documents dependencies to tables and views in the AP product. ,
File: SQLAP_Dependencies.html 12.1.1
product: AP - Payables , size: 603.861 KBytes , file_type: HTML Report , description: SQLAP_Dependencies.html is an html report that documents dependencies to tables and views in the AP product. ,
File: SQLAPProduct_Dependencies.html 12.2.2
product: AP - Payables , size: 129.758 KBytes , file_type: HTML Report , description: SQLAPProduct_Dependencies.html is an html report that documentsexternal dependencies to tables and views in the AP product. ,
File: SQLAP_Tables.html 12.2.2
product: AP - Payables , size: 4.461 MBytes , file_type: HTML Report , description: SQLAP_Tables.html is an html report that documents the table and view definitions for the AP product. ,
File: SQLAP_Tables.html 12.1.1
product: AP - Payables , size: 4.184 MBytes , file_type: HTML Report , description: SQLAP_Tables.html is an html report that documents the table and view definitions for the AP product. ,