Results for “arfv_cash_distributions”

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

Overview

ARFV_CASH_DISTRIBUTIONS is a read-only view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is part of the Oracle Receivables (AR) product family and exposes the accounting distribution lines generated for cash receipts. The view presents the subledger accounting entries created by the Receivables SLA (Subledger Accounting) engine, joining the cash receipt header and history information to the corresponding XLA distribution lines and general ledger code combinations.

The view is primarily a reporting and integration object. It allows receivables analysts, financial users, and downstream reporting tools to retrieve cash receipt accounting distributions along with descriptive attributes such as the receipt number, operating unit, GL date, and account type without having to write the underlying multi-table subledger joins manually. Because it is defined with WITH READ ONLY, it cannot be used for data manipulation; it is intended strictly for query and extraction. The presence of DISPLAY-format attributes (prefixed with _LA: and _KF:) indicates that the view is designed to support Oracle's formatted value and key flexfield resolution conventions used by EBS reporting frameworks.

Underlying Base Objects

The view is defined over six referenced base objects, documented in the ETRM 12.2.2 metadata as follows:

• AR_CASH_RECEIPTS (SYNONYM) — supplies the receipt header and receipt number.
• AR_CASH_RECEIPT_HISTORY (SYNONYM) — provides the GL date and joins to the distribution source via CASH_RECEIPT_HISTORY_ID.
• AR_XLA_ARD_LINES_V (VIEW) — the principal source of the SLA distribution lines, source type, and debit/credit amounts.
• GL_CODE_COMBINATIONS (SYNONYM) — resolves the accounting flexfield for each distribution line.
• HR_ALL_ORGANIZATION_UNITS (SYNONYM) — resolves the operating unit name.
• XLA_AE_HEADERS (SYNONYM) — provides the GL transfer status used to derive the posted flag.

The join condition ties distributions to cash receipt history on SOURCE_ID and SOURCE_TABLE = 'CRH', then links history to receipts, operating units, code combinations, and XLA headers by their respective keys. Outer joins ((+)) are applied to the organization unit and code combination lookups, so distribution rows are retained even when those descriptive values are absent.

Key Columns

The view exposes a curated set of columns. Important attributes include:

• LINE_ID — unique identifier for the distribution line.
• _LA:ACCOUNT_TYPE — decoded account type (CONFIRMATION, REMITTANCE, CASH, FACTOR, SHORT_TERM_DEBT, BANK_CHARGES) derived from DIST.SOURCE_TYPE via the AR_LOOKUPS lookup.
• DEBIT_AMOUNT / CREDIT_AMOUNT — entered debit and credit amounts for the distribution.
• FUNCTIONAL_DEBIT_AMOUNT / FUNCTIONAL_CREDIT_AMOUNT — accounted (functional currency) amounts.
• GENERAL_LEDGER_DATE — the GL date from cash receipt history, used for period and posting analysis.
• _LA:POSTED_FLAG — decoded YES/NO flag reflecting HED.GL_TRANSFER_STATUS_CODE.
• RECEIPT_NUMBER — the cash receipt number.
• OPERATING_UNIT — the organization unit name.
• _KF:ACCOUNT_NAME — key flexfield resolution for the accounting flexfield (GL#).
• CASH_RECEIPT_ID, ORG_ID, ACCOUNT_ID — foreign key identifiers.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include reconciling cash receipt distributions to the general ledger, analyzing account types such as short-term debt or bank charges, and reporting receipt accounting by operating unit or period. A basic query retrieving distributions for a specific receipt follows:

SELECT receipt_number, operating_unit, "_LA:ACCOUNT_TYPE" account_type,
  debit_amount, credit_amount, general_ledger_date, "_LA:POSTED_FLAG" posted
FROM apps.arfv_cash_distributions
WHERE cash_receipt_id = :p_receipt_id;

To summarize posted distributions by account type for a given period:

SELECT "_LA:ACCOUNT_TYPE" account_type,
  SUM(functional_debit_amount) dr, SUM(functional_credit_amount) cr
FROM apps.arfv_cash_distributions
WHERE general_ledger_date BETWEEN :p_start AND :p_end
  AND "_LA:POSTED_FLAG" = 'Yes'
GROUP BY "_LA:ACCOUNT_TYPE";

Because the decoded columns are quoted identifiers, they must be referenced with double quotation marks in SQL. The view is best used for read-only extraction and reconciliation reporting; persistence of results, if required, should be handled by the calling application or report.