Search Results ap_invoice_distributions_all
The AP_INVOICE_DISTRIBUTIONS_ALL table is a critical component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Accounts Payable (AP) module. This table stores detailed distribution line information for invoices, ensuring accurate accounting entries, tax calculations, and financial reporting. It serves as a bridge between invoice headers (AP_INVOICES_ALL) and the General Ledger (GL_JE_LINES), enabling multi-org and multi-currency functionalities.
Key Attributes and Structure
The table contains over 100 columns, but the most significant include:- INVOICE_ID: Foreign key linking to AP_INVOICES_ALL.
- DISTRIBUTION_LINE_NUMBER: Unique identifier for each distribution line.
- LINE_TYPE_LOOKUP_CODE: Classifies distributions (e.g., 'ITEM', 'TAX', 'FREIGHT').
- AMOUNT: The monetary value of the distribution.
- ACCOUNTING_DATE: Determines the GL period for posting.
- DIST_CODE_COMBINATION_ID: Links to GL_CODE_COMBINATIONS for chart of accounts mapping.
- ORG_ID: Supports multi-org architecture.
Functional Role
- Accounting Integration: Distributes invoice amounts across GL accounts (e.g., expense, liability, tax).
- Tax Processing: Stores tax-specific distributions with references to AP_TAX_CODES_ALL.
- Multi-Currency Support: Tracks exchange rates (EXCHANGE_RATE) and converted amounts.
- Project Costing: Integrates with Oracle Projects via PROJECT_ID, TASK_ID.
Technical Considerations
- Indexing: Key indexes include AP_INVOICE_DISTRIBUTIONS_N1 (INVOICE_ID) and AP_INVOICE_DISTRIBUTIONS_U1 (primary key).
- Partitioning: In 12.2.2, table partitioning by ORG_ID improves performance.
- Audit Columns: CREATION_DATE, LAST_UPDATE_DATE track changes.
Integration Points
The table interacts with:- AP_INVOICE_LINES_ALL: Parent-child relationship via INVOICE_ID.
- GL_JE_LINES: Accounting entries are transferred via Subledger Accounting (SLA).
- PO_DISTRIBUTIONS_ALL: For matched purchase orders.
Customization and Extensions
Common extensions include:- Adding descriptive flexfields (DFFs) for industry-specific attributes.
- Creating triggers to enforce custom validation rules.
- Developing APIs for mass distribution updates.
Data Flow Example
When an invoice is entered:- System creates header in AP_INVOICES_ALL.
- Distribution lines populate AP_INVOICE_DISTRIBUTIONS_ALL with accounting details.
- SLA generates journal entries in XLA_AE_LINES before GL posting.
Performance Optimization
Best practices include:- Purging archived data via AP_INVOICE_PURGE program.
- Analyzing distribution growth with AP_DISTRIBUTIONS_REPORT.
- Leveraging Oracle's Cost Management for inventory-related distributions.
-
Table: AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_DISTRIBUTIONS_ALL, object_name:AP_INVOICE_DISTRIBUTIONS_ALL, status:VALID, product: AP - Payables , description: Invoice distribution line information , implementation_dba_data: AP.AP_INVOICE_DISTRIBUTIONS_ALL ,
-
Table: AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_INVOICE_DISTRIBUTIONS_ALL, object_name:AP_INVOICE_DISTRIBUTIONS_ALL, status:VALID, product: AP - Payables , description: Invoice distribution line information , implementation_dba_data: AP.AP_INVOICE_DISTRIBUTIONS_ALL ,
-
APPS.ZX_AP_POPULATE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JE_IL_TAX_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_ACCOUNTING_PAY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PAAPIMP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.FV_FACTS_TRX_REGISTER dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CSTPMECS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JMF_SHIKYU_GRP dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JL_JLARPCFF_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JE_ES_WHTAX dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_PROJ_TSK_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PSA_AP_BC_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_ACC_GEN_WF_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_ADJUSTMENTS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PO_DOCUMENT_UPGRADE_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.GMS_PA_API dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.OPI_EDW_COGS_F_SZ dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_MATCHING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.POS_AP_CHECKS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JA_JAINSTAC_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.POA_EDW_SUPPERF dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CST_ACCRUAL_REC_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.OPI_DBI_OPM_COGS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CST_ACCRUAL_LOAD dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JAI_PA_COSTING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.GMS_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_EXTENDED_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PSA_BC_XLA_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_WFAPPROVAL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PA_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JE_IT_LISTING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.CSTPOMLD dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.JAI_AP_TOLERANCE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.PJM_TRANSFER_CHARGES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_VOID_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.1.1
-
APPS.AP_RETAINAGE_RELEASE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2
-
APPS.ZX_AP_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2
-
APPS.GMS_COST_PLUS_EXTN dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2
-
APPS.PA_ADJUSTMENTS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2
-
APPS.JAI_AP_TDS_PREPAYMENTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2
-
APPS.PSA_AP_BC_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
12.2.2