Results for “exch_gain”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.ARFV_APP_DISTS_ALC_V is a reporting view in the Oracle E-Business Suite Receivables (AR) module, defined over the Subledger Accounting (XLA) and General Ledger (GL) accounting infrastructure. It presents earned discount, unearned discount, exchange gain, and exchange loss distributions associated with Receivables application accounting, filtered specifically to ledgers whose category code is ALC (a secondary or reporting ledger category often used for adjustments). The view is part of the "ACC LINK" family of objects, which expose the linkage between transactional accounting entries and their underlying distribution lines. When a user searches for "ACC LINK," this view represents the receivable-focused variant that resolves accounting class codes into meaningful, user-facing account-type references.

Its principal role is to make subledger accounting data queryable with correct rounding, lookup decoding, and reversal filtering applied, so that reporting tools and integrations do not have to replicate the complex join and decode logic independently.

Underlying Base Objects

The view is defined over the following documented base objects:

• AR_DISTRIBUTIONS_ALL (synonym) — the source of Receivables distribution records, joined via ARD.source_type.
• XLA_AE_HEADERS (synonym) — subledger accounting event headers, the anchor of the accounting event chain.
• XLA_AE_LINES (synonym) — the individual accounting entry lines containing the accounting class code.
• XLA_DISTRIBUTION_LINKS (synonym) — links accounting lines back to their originating distributions, including reversal relationships.
• FND_CURRENCIES (synonym) — supplies currency precision and minimum accountable unit for rounding.
• GL_LEDGERS_PUBLIC_V (view) — the public ledger view providing ledger name, ledger ID, and currency.

The joins enforce application_id = 222 (Receivables) throughout, and the ledger category must be ALC. A DISTINCT clause and an anti-join against XLA_DISTRIBUTION_LINKS remove reversal links, ensuring only valid, non-reversed accounting distributions are returned.

Key Columns

• accounted_dr / accounted_cr — rounded accounted debit and credit amounts computed against the currency's minimum accountable unit.
• GL_TRANSFER_STATUS_CODE decode — a flexfield-style lookup returning 'Y'/'N' based on whether the header has been transferred to GL.
• LEDGER name and ledger_id — identification of the ledger from GL_LEDGERS_PUBLIC_V.
• source_id — the Receivables distribution identifier linking back to the transaction.
• ACCOUNT_TYPE (decoded) — derived from LIN.accounting_class_code, mapping EDISC, UNEDISC, EXCH_GAIN, EXCH_LOSS, and receivable statuses (UNAPP, APP, UNID, ACC) into meaningful lookup values.
• accounting_class_code — the raw Subledger Accounting class code from XLA_AE_LINES.

Common Use Cases and Queries

Typical uses include reconciling earned and unearned discounts posted to GL, validating exchange gain/loss distributions, and building custom "ACC LINK" style reports tracing an accounting line to its receivables distribution.

SELECT ledger_id, ledger_name, source_id,
       accounted_dr, accounted_cr, accounting_class_code
FROM   apps.arfv_app_dists_alc_v
WHERE  ledger_id = :p_ledger_id
AND    accounting_class_code IN ('EDISC','UNEDISC','EXCH_GAIN','EXCH_LOSS');

Analysts also aggregate by account type to confirm that discount and exchange distributions net correctly, and join source_id back to AR transaction tables for drill-down. Because reversal links are excluded, results reflect only active, current-period accounting. The view is read-only and should be leveraged rather than reimplemented to preserve the vendor-supplied decoding and rounding semantics.