Results for “arbv_cash_distributions”

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

Overview

ARBV_CASH_DISTRIBUTIONS is an APPS-owned read-only view in the Oracle Receivables (AR) module, valid across EBS 12.1.1 and 12.2.2. It presents the accounting distribution lines generated for cash receipts, exposing the debit and credit amounts, the associated account, the general ledger date, and the posting status of each distribution. The view is documented specifically as a "Cash Distributions" reporting object, and its name and column set indicate that it is intended for reconciliation and reporting between Receivables cash activity and the Subledger Accounting (SLA/XLA) accounting engine.

The view plays a supporting role in reporting and integration rather than transactional data entry. Because distributions are written by Subledger Accounting when a cash receipt is accounted, ARBV_CASH_DISTRIBUTIONS provides a convenient, flattened projection of those distributions joined to the cash receipt history and the accounting event header. Report developers, reconciliation analysts, and interface builders use it to verify that receipt activity was transferred to the general ledger and to analyze the composition of receipt accounting entries.

Underlying Base Objects

The view is defined over three documented base objects:

• AR_CASH_RECEIPT_HISTORY (SYNONYM) — supplies the receipt history context, including the GL date, cash receipt identifier, and organization identifier.
• AR_XLA_ARD_LINES_V (VIEW) — supplies the individual distribution lines, including source type, amounts, and the code combination identifier. This is the subledger accounting lines view for Receivables.
• XLA_AE_HEADERS (SYNONYM) — supplies the accounting entry header, including the GL transfer status code used to derive the posted flag.

The join condition links AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID to AR_XLA_ARD_LINES_V.SOURCE_ID where SOURCE_TABLE equals 'CRH', and links the distribution's AE_HEADER_ID to XLA_AE_HEADERS.AE_HEADER_ID. The view is created WITH READ ONLY and carries a UNIQUE ATTRIBUTES hint on LINE_ID.

Key Columns

• LINE_ID — Unique identifier for the distribution line.
• "_LA:ACCOUNT_TYPE" — A descriptive flexfield/segment labeled column that decodes SOURCE_TYPE into a meaningful account type. The decode maps CONFIRMATION, REMITTANCE, CASH, FACTOR, SHORT_TERM_DEBT, and BANK_CHARGES; any other value returns NULL. This is the column directly relevant to a "bank_charges" search.
• DEBIT_AMOUNT / CREDIT_AMOUNT — Entered debit and credit amounts for the distribution.
• FUNCTIONAL_DEBIT_AMOUNT / FUNCTIONAL_CREDIT_AMOUNT — Accounted (functional currency) debit and credit amounts.
• GENERAL_LEDGER_DATE — The GL date from the cash receipt history.
• "_LA:POSTED_FLAG" — Decoded from HED.GL_TRANSFER_STATUS_CODE, returning 'Y' when the entry has been transferred to GL and 'N' otherwise, via the YES/NO lookup.
• CASH_RECEIPT_ID, ORG_ID, ACCOUNT_ID — Identifier columns linking the distribution to the receipt, the operating unit, and the accounting code combination.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard WHO audit columns.

Common Use Cases and Queries

A frequent use case is isolating bank charge distributions to verify that bank fees were accounted and transferred. The following query returns bank charge lines for a receipt:

• SELECT line_id, cash_receipt_id, debit_amount, credit_amount, general_ledger_date, "_LA:POSTED_FLAG" FROM apps.arbv_cash_distributions WHERE "_LA:ACCOUNT_TYPE" = 'BANK_CHARGES';

Another common pattern is reconciling unposted distributions, filtering on the posted flag to identify entries not yet transferred to the general ledger. Analysts also aggregate debit and credit totals by account_id to analyze the account composition of receipt accounting, and join to AR_CASH_RECEIPTS to enrich results with receipt number and customer information. Because the view is read-only, it should be used exclusively for query and reporting purposes.