Search Results ap_invoices_all

Overview

The AP_INVOICES_ALL table is the central repository for detailed invoice records within the Oracle E-Business Suite Payables module. It stores the core transactional data for every invoice entered into the system, regardless of the operating unit. The suffix "_ALL" indicates it is a multi-org table, containing data for all business units, with access typically controlled by a security profile. This table is fundamental to the procure-to-pay cycle, recording essential information such as vendor details, invoice amounts, payment terms, and accounting distributions. Its integrity is maintained through multiple primary and foreign key relationships, linking it to critical master data like vendors, currencies, purchase orders, and the general ledger.

Key Information Stored

The table's structure captures the complete lifecycle of an invoice. Key columns include the unique identifier INVOICE_ID and the business keys VENDOR_ID and INVOICE_NUM. Financial data is stored in columns such as INVOICE_AMOUNT, INVOICE_CURRENCY_CODE, and PAYMENT_CURRENCY_CODE. The table also holds critical references for accounting and processing: SET_OF_BOOKS_ID for the ledger, ACCTS_PAY_CODE_COMBINATION_ID for the liability account, and BATCH_ID for batch control. For integration with other modules, it includes columns like PO_HEADER_ID for Purchasing and PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE for Projects.

Common Use Cases and Queries

This table is central to invoice reporting, auditing, and data extraction. Common queries involve joining with related master tables to produce meaningful reports. A typical pattern is to retrieve invoice headers with vendor and site information for a specific operating unit. For example:

• Invoice Status Inquiry: Querying invoices based on status (e.g., 'NEEDS REAPPROVAL', 'PAID'), date ranges, and vendor.
• Open Invoice Reporting: Joining with AP_PAYMENT_SCHEDULES_ALL to list unpaid invoices and their due dates for cash flow analysis.
• Project-Related Invoices: Filtering on PROJECT_ID and joining to PA_PROJECTS_ALL to track project expenditures.
• Data Migration & Interfaces: The table is the target for invoice imports via the Payables Open Interface (AP_INVOICES_INTERFACE), and direct data fixes often require updates to specific columns with proper validation.

Related Objects

AP_INVOICES_ALL has extensive relationships within the EBS schema. It is the parent table for key transactional entities, most notably AP_INVOICE_DISTRIBUTIONS_ALL, which holds the accounting distributions for each invoice. For payment processing, it relates to AP_PAYMENT_SCHEDULES_ALL and AP_CHECKS_ALL. As shown in the metadata, critical foreign key dependencies link it to master data tables: PO_VENDORS and PO_VENDOR_SITES_ALL for supplier data; FND_CURRENCIES for currency details; GL_CODE_COMBINATIONS for accounting flexfields; and PO_HEADERS_ALL for purchase order matching. Important views like AP_INVOICES and AP_INVOICES_V provide simplified, operating-unit-secured access to this core data.