Results for “arfv_application_distributions”

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

Overview

ARFV_APPLICATION_DISTRIBUTIONS is a read-only Oracle E-Business Suite view owned by the APPS schema and classified under the Receivables (AR) product family. It presents the accounting distributions generated when cash receipt applications are posted to the General Ledger through Subledger Accounting (SLA/XLA). In practice, it exposes the debit and credit lines, accounted amounts, general ledger dates, and balancing segment combinations associated with receivable application events, together with their current GL transfer status. The view is commonly referenced in Receivables reporting, reconciliation, and integration work where line-level accounting detail for receipt applications is required. The object holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2. Users frequently locate it while searching on the related base object ar_receivable_applications, since the view joins directly to that table on RECEIVABLE_APPLICATION_ID.

Underlying Base Objects

The view is defined over five documented base objects. AR_RECEIVABLE_APPLICATIONS (a synonym to the core AR table) supplies the application header information, including the application ID, GL date, organization ID, and status. AR_XLA_ARD_LINES_V is the Subledger Accounting distribution view that provides the actual debit/credit and accounted amounts together with the source type, source ID, source table, code combination, and AE header reference. GL_CODE_COMBINATIONS (synonym) supplies the accounting flexfield combination to which each distribution is charged. HR_ALL_ORGANIZATION_UNITS (synonym) resolves the operating unit name through an outer join on ORG_ID. XLA_AE_HEADERS (synonym) contributes the GL_TRANSFER_STATUS_CODE used to indicate whether the accounting entry has been transferred to the General Ledger. The join is driven by the condition DIST.SOURCE_TABLE = 'RA' and DIST.SOURCE_ID = RA.RECEIVABLE_APPLICATION_ID.

Key Columns

• RECEIVABLE_APPLICATION_ID — Links each distribution row back to the originating receipt application in AR_RECEIVABLE_APPLICATIONS.
• AMOUNT_DR / AMOUNT_CR — Entered debit and credit amounts for the distribution line.
• ACCTD_AMOUNT_DR / ACCTD_AMOUNT_CR — Accounted (functional currency) debit and credit amounts.
• GL_DATE — The general ledger date carried on the application, determining the accounting period.
• NAME (AOU.NAME) — The operating unit name resolved via HR_ALL_ORGANIZATION_UNITS.
• CODE_COMBINATION_ID — The GL account combination charged by the distribution.
• ORG_ID — The operating unit identifier for the application.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, and CREATED_BY for audit tracking.

Two special attributes are exposed through lookup decoding: the account type, derived by decoding RA.STATUS (UNAPP, APP, UNID, ACC) or the literal 'EDISC' for earned discount distributions, and a YES/NO meaning decoded from the GL transfer status code.

Common Use Cases and Queries

Typical scenarios include reconciling receipt applications against their GL postings, auditing accounted versus entered amounts, and validating that distributions have been transferred to the GL. The following query returns posted distributions for a given application:

• SELECT receivable_application_id, amount_dr, amount_cr, acctd_amount_dr, acctd_amount_cr, gl_date, name, code_combination_id FROM arfv_application_distributions WHERE receivable_application_id = :p_application_id;
• SELECT name, gl_date, SUM(acctd_amount_dr) dr, SUM(acctd_amount_cr) cr FROM arfv_application_distributions GROUP BY name, gl_date;

The view is most reliable for environments running Subledger Accounting, since its distribution source depends on AR_XLA_ARD_LINES_V and XLA_AE_HEADERS rather than legacy posting tables.