Search Results earliest_settlement_date




Overview
Explore in AI Chat

Overview

AP_INV_DISTS_UPDATE is a Payables (AP) schema table that stores invoice distribution lines pending or associated with update processing in Oracle E-Business Suite Release 12.1.1 and 12.2.2. In the Payables data model, invoice distributions represent the accounting splits of an invoice line—each distribution carries the charge account (DIST_CODE_COMBINATION_ID), amount, and the tax, project, and encumbrance attributes that ultimately flow to the General Ledger. The AP_INV_DISTS_UPDATE table mirrors the structure of the permanent AP_INVOICE_DISTRIBUTIONS_ALL table at the column level (244 documented columns), functioning as a staging or working area where distribution rows are accumulated or modified before the final accounting and posting cycle completes.

From a Data Vault modeling perspective, the mined foreign-key structure classifies AP_INV_DISTS_UPDATE heuristically as a standalone object. In practice, its high-cardinality transactional grain and its descriptive, mutable attribute set (amounts, flags, tax and recovery rates) suggest treating it as a satellite attached to an invoice-distribution hub or link, with the distribution line and invoice identifiers serving as the business key.

Key Information Stored

The table is keyed at the distribution level. INVOICE_DISTRIBUTION_ID and DISTRIBUTION_LINE_NUMBER uniquely identify a distribution line, while INVOICE_ID links the row to its parent invoice header. These three columns are the principal business-key candidates; LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATED_BY provide the standard WHO audit columns.

Common Use Cases and Queries

Typical uses include reconciliation of distributions awaiting posting, verification of tax and recovery setup, project-cost validation, and pre-posting diagnostics before the Payables Accounting process runs.

  • Identifying unposted distributions for a period: SELECT INVOICE_ID, INVOICE_DISTRIBUTION_ID, AMOUNT_TO_POST FROM AP.AP_INV_DISTS_UPDATE WHERE POSTED_FLAG = 'N' AND PERIOD_NAME = :p_period;
  • Aggregating taxable versus recovered amounts by tax code for reporting.
  • Joining to the distribution code combination to confirm the accounting flexfield assigned to each expense line.
  • Comparing staged rows against the permanent AP_INVOICE_DISTRIBUTIONS_ALL records to detect discrepancies prior to GL transfer.
  • Validating encumbrance elements (ENCUMBERED_FLAG, AMOUNT_ENCUMBERED) for purchase-order-matched invoices.

Related Objects