Search Results zmmc21 transaction file download

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: 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: EDI TRANSACTION HANDLING 12.1.1
product: AP - Payables , meaning: Edi Transaction Handling , description: EDI transaction code ,
Lookup Type: EDI TRANSACTION HANDLING 12.2.2
product: AP - Payables , meaning: Edi Transaction Handling , description: EDI transaction code ,
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: 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: 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: 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: 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: 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: Credit_Cards.pdf 12.1.1
product: AP - Payables , size: 66.999 KBytes , file_type: PDF Diagram ,
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: 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: 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: 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: 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. ,
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 ,
Concurrent Program: APXAMEXDOWN 12.1.1
execution_filename: AmericanExpressDownloader , product: AP - Payables , user_name: APXAMEXDOWN , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: APXAMEXDOWN 12.2.2
execution_filename: AmericanExpressDownloader , product: AP - Payables , user_name: APXAMEXDOWN , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: 1099 ORIGINAL FILE 12.2.2
product: AP - Payables , meaning: 1099 ORIGINAL FILE ,
Lookup Type: 1099 ORIGINAL FILE 12.1.1
product: AP - Payables , meaning: 1099 ORIGINAL FILE ,
Lookup Type: CODE TYPE 12.1.1
product: AP - Payables , meaning: Code Type , description: Defines date format of bank-file field ,
Lookup Type: CODE TYPE 12.2.2
product: AP - Payables , meaning: Code Type , description: Defines date format of bank-file field ,
Lookup Type: RECEIPT PROGRAM 12.2.2
product: AP - Payables , meaning: Receipt Program , description: Automatic Receipt Program Types for Accounts Receivable ,
Lookup Type: RECEIPT PROGRAM 12.1.1
product: AP - Payables , meaning: Receipt Program , description: Automatic Receipt Program Types for Accounts Receivable ,
Table: AP_WEB_AMEX_PARAMS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_WEB_AMEX_PARAMS, object_name:AP_WEB_AMEX_PARAMS, status:VALID, product: AP - Payables , description: Download parameters for American Express , implementation_dba_data: AP.AP_WEB_AMEX_PARAMS ,
Table: AP_WEB_AMEX_PARAMS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_WEB_AMEX_PARAMS, object_name:AP_WEB_AMEX_PARAMS, status:VALID, product: AP - Payables , description: Download parameters for American Express , implementation_dba_data: AP.AP_WEB_AMEX_PARAMS ,
Lookup Type: RECORD TYPE 12.1.1
product: AP - Payables , meaning: Record Type , description: Used by check recon to determine what table to store flat-file record in ,
Lookup Type: RECORD TYPE 12.2.2
product: AP - Payables , meaning: Record Type , description: Used by check recon to determine what table to store flat-file record in ,
Concurrent Program: APXTRSND 12.2.2
execution_filename: SendPaymentFile , product: AP - Payables , user_name: Transmit Payment File Program , description: Submit Transmit Payment File Program , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXTRRCV 12.1.1
execution_filename: ReceiveConfirmationFiles , product: AP - Payables , user_name: Retrieve Payment File Confirmations Program , description: Submit Retrieve Payment File Confirmations Program , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXTRRCV 12.2.2
execution_filename: ReceiveConfirmationFiles , product: AP - Payables , user_name: Retrieve Payment File Confirmations Program , description: Submit Retrieve Payment File Confirmations Program , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXTRSND 12.1.1
execution_filename: SendPaymentFile , product: AP - Payables , user_name: Transmit Payment File Program , description: Submit Transmit Payment File Program , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Lookup Type: OIE_APWUPDM_SOURCE 12.1.1
product: AP - Payables , meaning: Expenses Upload Rates Source , description: Expenses Upload Rates Source ,
Lookup Type: OIE_APWUPDM_SOURCE 12.2.2
product: AP - Payables , meaning: Expenses Upload Rates Source , description: Expenses Upload Rates Source ,
Lookup Type: DATATYPE 12.2.2
product: AP - Payables , meaning: Datatype , description: Defines datatype of a bank-file field for the check reconciliation program ,
Concurrent Program: APXPBFZG 12.1.1
execution_filename: APXPBFZG , product: AP - Payables , user_name: APXPBFZG , description: Generate Zengin File , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,