Search Results dist_acctd_amt

Overview

AR_DISTRIBUTIONS_BASE_V is a read-only database view owned by the APPS schema within the Oracle E-Business Suite Receivables (AR) module. Its documented purpose in the ETRM metadata is a "distribution base extract," indicating that it exposes accounting distribution information extracted from the Subledger Accounting (SLA/XLA) engine that underpins Oracle Receivables. The view is a UNION-based construct built across multiple posting entities — including adjustments (ADJ) and cash receipts (CRH) — pulling level-flagged lines from the AR_XLA_LINES_EXTRACT table.

The view is primarily consumed by reporting and integration processes that require a normalized, consolidated view of Receivables accounting distributions across transaction types. Because it references the XLA extract layer rather than the transactional tables directly, it reflects the accounting representation of Receivables activity — the debits and credits ultimately posted to the General Ledger — rather than the raw business document.

Users searching for "base_currency" will note that the view exposes a column named BASE_CURRENCY, aliased from the underlying LI.BASE_CURRENCY_CODE column of AR_XLA_LINES_EXTRACT. This is central to the view's function, since distribution amounts, conversion rates, and account dates are expressed relative to the ledger's base or functional currency.

Underlying Base Objects

The documented base objects referenced by AR_DISTRIBUTIONS_BASE_V include:

• AR_XLA_LINES_EXTRACT — the primary source table, supplying line-level accounting data (event, ledger, exchange rate, accounted amounts). The view uses a critical INDEX hint (AR_XLA_LINES_EXTRACT_N1) on this table for performance.
• AR_DISTRIBUTIONS_ALL — the base distributions table for Receivables accounting entries.
• AR_CASH_RECEIPTS_ALL — cash receipt header and line data.
• AR_RECEIVABLE_APPLICATIONS_ALL — application of receipts against transactions.
• AR_CASH_BASIS_DISTS_ALL — cash-basis distribution records.
• RA_CUSTOMER_TRX_ALL — customer transaction headers, providing context for invoices, credit memos, and debit memos.

The presence of these synonyms in the dependency chain reflects the view's breadth across the Receivables accounting lifecycle.

Key Columns

• EVENT_ID — identifier of the accounting event in the subledger.
• BASE_CURRENCY — the ledger base (functional) currency code for the distribution.
• LINE_ID / LINE_NUMBER — the accounting line identifier and sequence.
• DIST_CUR_CONVERSION_TYPE / RATE / DATE — the currency conversion details applied to the distribution currency.
• DIST_ACCTD_AMT — the accounted (base currency) distribution amount. For cash receipts with a specific receivables transaction (RECEIVABLES_TRX_ID = -16), this is derived via DECODE from FROM_ACCTD_AMOUNT.
• DIST_TO_CUR_CONVERSION_TYPE / RATE / DATE and DIST_TO_ACCTD_AMT — conversion information and amount used for reporting/translation to a reporting currency.
• GAIN_LOSS_AMT / GAIN_LOSS_SIGN — reserved for gain/loss amounts; returned as NULL in the excerpt.
• LANGUAGE — language code for multilingual reporting.
• LEDGER_ID — the ledger associated with the accounting event.

Common Use Cases and Queries

Because of its extract-oriented design, the view is typically queried for reconciliation between Receivables subledger accounting and GL, and for currency-aware distribution reporting.

• Reconcile accounted distribution amounts to the GL for a given ledger.
• Report accounting entries by base currency across adjustments and cash receipts.
• Feed downstream data warehouse or ETL processes with normalized distribution rows.

Sample query:

SELECT EVENT_ID, BASE_CURRENCY, LINE_ID, DIST_ACCTD_AMT, LEDGER_ID
FROM   APPS.AR_DISTRIBUTIONS_BASE_V
WHERE  BASE_CURRENCY = :p_base_currency
AND    LEDGER_ID = :p_ledger_id;

Such queries exploit the BUSY INDEX hint behavior and should generally be filtered by LEDGER_ID and BASE_CURRENCY for performance.