Search Results ap_invoice_distributions_all




Overview
Explore in AI Chat

Overview

AP_INVOICE_DISTRIBUTIONS_ALL is the core distribution table in the Oracle Payables (AP) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Each row represents a single accounting distribution line for an invoice, recording how an invoice amount is allocated across expense accounts, projects, assets, and tax authorities. The table resides in the AP schema and holds 244 documented columns, making it one of the most richly populated transactional entities in the Payables data model.

Structurally, the table records the accounting impact of every invoice line. An invoice header stored in AP_INVOICES_ALL may have multiple lines in AP_INVOICE_LINES_ALL, and each line may in turn generate one or more distributions, giving the table a granularity of one row per invoice-line-distribution combination. This granularity is enforced by the primary key AP_INVOICE_DISTRIBUTIONS_PK (INVOICE_ID, DISTRIBUTION_LINE_NUMBER).

Under a heuristic Data Vault classification derived from the foreign-key structure, AP_INVOICE_DISTRIBUTIONS_ALL models as a hub, since it is the central anchor referenced by many downstream tables including FA_ASSET_INVOICES, PA_COST_DISTRIBUTION_LINES_ALL, AP_TRIAL_BALANCE, and several mass-additions and commitment tables. In practice, this hub role is enriched by satellite-like columns capturing posting status, withholding tax attributes, multi-reporting-currency (MRC) values, and encumbrance tracking.

Key Information Stored

The table's most operationally significant columns fall into several categories:

The unique index AP_INVOICE_DISTRIBUTIONS_U1 (INVOICE_ID, INVOICE_LINE_NUMBER, DISTRIBUTION_LINE_NUMBER) identifies the business-key candidate for a distribution within an invoice line.

Common Use Cases and Queries

Typical reporting and reconciliation activities query this table to analyze expense distribution, validate posting status, and reconcile invoice amounts to the general ledger.

  • Distribution listing for an invoice: Select INVOICE_ID, DISTRIBUTION_LINE_NUMBER, AMOUNT, DIST_CODE_COMBINATION_ID, and POSTED_FLAG filtered by a specific INVOICE_ID.
  • Unposted distributions: Filter where POSTED_FLAG = 'N' and PERIOD_NAME is in an open accounting period to identify items awaiting the Payables Accounting process.
  • Project cost analysis: Join PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE to PA_TASKS and PA_EXPENDITURE_TYPES for capitalizable or billable cost reporting.
  • Withholding tax reporting: Filter AWT_FLAG = 'Y' and aggregate AWT_WITHHELD_AMT by supplier or tax authority for statutory filings.
  • Encumbrance reconciliation: Query rows where ENCUMBERED_FLAG = 'Y' to reconcile PO encumbrances against actual invoice distributions.
  • MRC reporting: Select MRC_AMOUNT and MRC_DIST_CODE_COMBINATION_ID for secondary-ledger reporting requirements.

A common pattern joins AP_INVOICES_ALL to AP_INVOICE_DISTRIBUTIONS_ALL on INVOICE_ID, then to GL_CODE_COMBINATIONS on DIST_CODE_COMBINATION_ID, to produce an account-level distribution report.

Related Objects

The table participates in an extensive relationship network. The most significant related objects include:

Together these relationships establish AP_INVOICE_DISTRIBUTIONS_ALL as the principal accounting anchor for invoice activity, linking Payables to General Ledger, Purchasing, Projects, Assets, and Tax.