Search Results ap_invoice_lines_all
The AP_INVOICE_LINES_ALL
table is a fundamental component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Accounts Payable (AP) module. It stores detailed line-level information for supplier invoices, serving as a critical repository for transactional data that supports financial reporting, tax calculations, and payment processing. This table is part of the core AP schema and is tightly integrated with other key tables such as AP_INVOICES_ALL
, AP_INVOICE_DISTRIBUTIONS_ALL
, and PO_DISTRIBUTIONS_ALL
. Below is a detailed analysis of its structure, functionality, and significance in Oracle EBS.
Table Structure and Key Columns
TheAP_INVOICE_LINES_ALL
table contains columns that capture invoice line details, including amounts, quantities, tax information, and references to purchase orders or other source documents. Key columns include:
- INVOICE_ID: Foreign key linking to
AP_INVOICES_ALL
, identifying the parent invoice. - INVOICE_LINE_NUMBER: Unique identifier for each line within an invoice.
- LINE_TYPE_LOOKUP_CODE: Categorizes the line (e.g., "ITEM," "TAX," "FREIGHT").
- AMOUNT: The monetary value of the line item.
- PO_HEADER_ID and PO_LINE_ID: References to purchase orders, enabling integration with the Purchasing module.
- TAX_CODE_ID: Links to tax definitions for compliance and reporting.
- DISTRIBUTION_SET_ID: Used for automatic distribution of line amounts across accounting segments.
Functional Role in Oracle EBS
The table plays a pivotal role in the invoice lifecycle:- Invoice Entry: Captures line-level details during manual or automated invoice creation.
- Validation: Ensures consistency with purchase orders (via
PO_HEADER_ID
andPO_LINE_ID
) and tax rules. - Distributions: Serves as the source for creating accounting distributions in
AP_INVOICE_DISTRIBUTIONS_ALL
. - Reporting: Provides granular data for AP aging, supplier spend analysis, and tax audits.
Integration with Other Modules
TheAP_INVOICE_LINES_ALL
table integrates with multiple Oracle EBS modules:
- Purchasing (PO): Lines referencing purchase orders (
PO_HEADER_ID
) enable matched invoice processing. - General Ledger (GL): Distributions derived from invoice lines post to GL via
AP_INVOICE_DISTRIBUTIONS_ALL
. - Tax (ZX): Tax lines (
LINE_TYPE_LOOKUP_CODE = 'TAX'
) interface with the Tax module for accurate calculations.
Technical Considerations
- Multi-Org Support: The
_ALL
suffix indicates it stores data for all operating units, filtered byORG_ID
. - Indexing: Key indexes include
AP_INVOICE_LINES_N1
(INVOICE_ID
) andAP_INVOICE_LINES_U1
(unique constraint onINVOICE_ID
andINVOICE_LINE_NUMBER
). - Audit Columns:
CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
, andLAST_UPDATED_BY
track changes.
Customization and Extensions
Organizations often extend this table with descriptive flexfields (DFFs) to capture additional attributes. Custom triggers or APIs may also be implemented to enforce business rules during line entry.Conclusion
TheAP_INVOICE_LINES_ALL
table is indispensable for Oracle EBS Accounts Payable operations, providing the granular data needed for accurate financial processing, compliance, and cross-module integration. Its design reflects Oracle's commitment to scalability, auditability, and interoperability within the EBS ecosystem.
-
Table: AP_INVOICE_LINES_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_LINES_ALL, object_name:AP_INVOICE_LINES_ALL, status:VALID, product: AP - Payables , description: AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. , implementation_dba_data: AP.AP_INVOICE_LINES_ALL ,
-
Table: AP_INVOICE_LINES_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_LINES_ALL, object_name:AP_INVOICE_LINES_ALL, status:VALID, product: AP - Payables , description: AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface. , implementation_dba_data: AP.AP_INVOICE_LINES_ALL ,
-
APPS.POS_TOTALS_PO_SV dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.PSA_FA_INVOICE_DISTRIBUTIONS dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_ETAX_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_INTEREST_INVOICE_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_MATCHING_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.PO_CHARGES_GRP dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.FII_AP_INV_SUM_INC dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_XLA_UPGRADE_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_VOID_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_PREPAY_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_QUICK_CREDIT_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_AIL_TABLE_HANDLER_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JAI_FA_MA_TRIGGER_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_VOID_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_WORKFLOW_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_APPROVAL_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JAI_AP_IA_DTC_TRIGGER_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JA_JAINITCP_XMLP_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.PO_MULTI_MOD_VALIDATIONS dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.INL_INTERFACE_PVT dependencies on AP_INVOICE_LINES_ALL
12.2.2
-
APPS.JAI_FA_ASSETS_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_AI_TABLE_HANDLER_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_GENERATE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_ETAX_SERVICES_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.CSE_IPV_FA_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_RECT_MATCH_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_WORKFLOW_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_RCT_AMT_MATCH_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.JAI_CMN_ST_FORMS_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1
-
APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INVOICE_LINES_ALL
12.1.1