Search Results bank_charges




Overview
Explore in AI Chat

Overview

APPS.ARBV_CASH_DISTRIBUTIONS is a read-only Oracle EBS view in the Receivables (AR) module that exposes the accounting distributions generated for cash receipts. It is a Business Intelligence (BI) style view — prefixed "ARBV_" — intended for external reporting, extraction, and integration into data warehouses rather than for transactional processing. The view consolidates general ledger accounting lines derived from the Subledger Accounting (SLA/XLA) engine for cash receipts, exposing both the entered amounts (AMOUNT_DR / AMOUNT_CR) and the accounted amounts (ACCTD_AMOUNT_DR / ACCTD_AMOUNT_CR), along with the associated GL date and transfer status.

The view text carries embedded Lookup attributes (the "_LA:" prefixed columns), which are a convention in EBS BI views that instruct the BI Publisher / EBS reporting layer to display decoded meaning values for coded columns. In this case, the SOURCE_TYPE column is decoded against the AR_LOOKUPS lookup type ACCOUNT_TYPE, and the GL_TRANSFER_STATUS_CODE is decoded against AR_LOOKUPS with type YES/NO. These embedded instructions make the view directly consumable by report definitions without requiring additional lookup joins.

Because the user searched for "bank_charges," it is significant that BANK_CHARGES is one of the explicit SOURCE_TYPE values decoded within the view's SQL. The view therefore surfaces bank charge distributions as a distinct, decodable category of cash receipt accounting lines.

Underlying Base Objects

The view is defined over three documented objects:

The join path is: cash receipt history → SLA distribution lines → SLA accounting entry header. This reflects the standard EBS subledger accounting architecture, where the history table holds the operational receipt record and the XLA tables hold the resulting journal lines.

Key Columns

  • LINE_ID — The unique attribute identifying each distribution line.
  • ACCOUNT_TYPE (decoded from SOURCE_TYPE) — The accounting line category. Documented decode values include CONFIRMATION, REMITTANCE, CASH, FACTOR, SHORT_TERM_DEBT, and BANK_CHARGES.
  • AMOUNT_DR / AMOUNT_CR — Entered debit and credit amounts for the distribution.
  • ACCTD_AMOUNT_DR / ACCTD_AMOUNT_CR — Accounted debit and credit amounts after conversion.
  • GL_DATE — The general ledger date sourced from the cash receipt history.
  • GL_TRANSFER_STATUS (decoded from GL_TRANSFER_STATUS_CODE) — Indicates whether the accounting line has been transferred to the general ledger (Y/N).
  • IDS — CASH_RECEIPT_ID, ORG_ID, and CODE_COMBINATION_ID, supporting joins to receipts, operating units, and accounting flexfields.
  • WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for audit and incremental extraction.

Common Use Cases and Queries

The view is commonly used to report cash receipt accounting detail, to reconcile unposted or untransferred distributions, and — given the bank_charges interest — to isolate bank charge lines. For example, to list all bank charge distributions with their amounts and GL transfer status:

  • SELECT LINE_ID, ACCOUNT_TYPE, AMOUNT_DR, AMOUNT_CR, ACCTD_AMOUNT_DR, ACCTD_AMOUNT_CR, GL_DATE, GL_TRANSFER_STATUS, CASH_RECEIPT_ID, ORG_ID, CODE_COMBINATION_ID FROM APPS.ARBV_CASH_DISTRIBUTIONS WHERE ACCOUNT_TYPE = 'BANK_CHARGES' ORDER BY GL_DATE;

To audit distributions not yet transferred to the GL for a given period:

  • SELECT CASH_RECEIPT_ID, ACCOUNT_TYPE, CODE_COMBINATION_ID, AMOUNT_DR, AMOUNT_CR FROM APPS.ARBV_CASH_DISTRIBUTIONS WHERE GL_TRANSFER_STATUS = 'N' AND GL_DATE BETWEEN :from_date AND :to_date;

Because the view is defined WITH READ ONLY, it supports safe, non-mutative querying for reporting, data extraction, and reconciliation workloads across Oracle EBS 12.1.1 and 12.2.2.