Search Results dr_cr




Overview
Explore in AI Chat

Overview

APPS.OKL_AR_DIST_UV is a union-based reporting view in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 that consolidates Accounts Receivable distributions relevant to Oracle Lease Management (OKL). The view presents accounting distribution lines drawn from two distinct source streams: standard receivable transaction distributions from RA_CUST_TRX_LINE_GL_DIST, and distributions sourced from AR_DISTRIBUTIONS as joined through the Accounts Receivable application tables (AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, and AR_CASH_RECEIPT_HISTORY). Because it standardizes column names, debit/credit flags, and decoded lookup meanings across both sources, OKL_AR_DIST_UV is primarily consumed by Lease Management accounting, subledger reconciliation, and any custom reporting layer that requires a unified view of AR-related accounting entries.

The view is owned by the APPS schema and is intended for read-only reporting and integration use. It does not store data; it materializes distributions at query time and applies OKL_ACCOUNTING_UTIL package functions to derive concatenated accounting flexfield segments, segment descriptions, and lookup meanings.

Underlying Base Objects

The view is defined over the following documented base objects:

  • RA_CUST_TRX_LINE_GL_DIST (SYNONYM) — source of transaction-level GL distributions for the first UNION ALL branch.
  • RA_CUSTOMER_TRX (SYNONYM) — joined to derive the transaction type and header attributes.
  • RA_CUST_TRX_TYPES (SYNONYM) — provides the transaction type name used to distinguish invoice (INV) from credit memo (CM) behavior and to flip the debit/credit sign.
  • AR_DISTRIBUTIONS (SYNONYM) — primary distribution table in the second UNION ALL branch, supplying AMOUNT_DR and AMOUNT_CR.
  • AR_PAYMENT_SCHEDULES, AR_RECEIVABLE_APPLICATIONS, AR_CASH_RECEIPT_HISTORY (SYNONYMS) — supporting AR objects in the second branch that trace cash receipt and application history.
  • OKL_ACCOUNTING_UTIL (PACKAGE) — supplies GET_CONCAT_SEGMENTS, GET_CONCATE_DESC, and GET_LOOKUP_MEANING for segment text, descriptions, and decoded lookup labels.

The dependencies confirm the view spans both Oracle Receivables and Oracle Lease Management data models, which is expected for an OKL-prefixed AR distribution view.

Key Columns

The user search term amount_cr corresponds directly to a key column in this view. In the AR_DISTRIBUTIONS branch, AMOUNT_CR is exposed and used to derive credit indicators. The principal columns are:

Common Use Cases and Queries

Typical scenarios include reconciling lease-related AR distributions, extracting accounting entries for a given general ledger period, and isolating credit lines. A representative query filtering on the credit amount follows:

SELECT id, ae_line_type_meaning, concate_segments, amount, dr_cr_flag_meaning, accounting_date
FROM apps.okl_ar_dist_uv
WHERE amount_cr IS NOT NULL
ORDER BY accounting_date;

To aggregate debits and credits by account:

SELECT concate_segments,
  SUM(DECODE(cr_dr_flag,NULL,0,0)) d,
  SUM(amount) credit_total
FROM apps.okl_ar_dist_uv
WHERE cr_dr_flag = 'C'
GROUP BY concate_segments;

Because of the UNION ALL structure, callers should expect potential duplicate rows across the two source branches and should filter on SOURCE_TABLE or SOURCE_ID where precise provenance is required.