Search Results ar_xla_ard_lines_v




Overview
Explore in AI Chat

Overview

AR_XLA_ARD_LINES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Receivables (AR) product family and exists to support reporting that must read the code combination identifier (CCID) generated by the Subledger Accounting (XLA) engine. In Release 12, accounting entries for Receivables distributions are no longer derived directly from the transaction tables; they are created by XLA and stored in the XLA_AE_LINES and XLA_AE_HEADERS tables. The view bridges the original Receivables distribution rows in AR_DISTRIBUTIONS_ALL with their corresponding XLA accounting lines, thereby exposing the general ledger account (CCID) plus the unrounded entered and accounted amounts that XLA calculated.

The view is defined as a join across Receivables distributions, distribution links, XLA accounting lines and headers, and cash receipt tables. Its status is VALID. It is most commonly used by standard and custom Receivables reports, dashboards, and reconciliation extracts that need the accounting flexfield identifier alongside the subledger distribution detail without having to replicate the XLA linking logic.

Underlying Base Objects

According to the documented metadata, AR_XLA_ARD_LINES_V is defined over the following base objects (all referenced through synonyms in APPS): AR_DISTRIBUTIONS_ALL, XLA_DISTRIBUTION_LINKS, XLA_AE_LINES, XLA_AE_HEADERS, AR_CASH_RECEIPTS_ALL, and AR_CASH_RECEIPT_HISTORY_ALL. The documented view text additionally references AR_ADJUSTMENTS_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_TRANSACTION_HISTORY_ALL, and RA_CUSTOMER_TRX_ALL, which supply the secondary source information for the various Receivables source tables.

The core relationship is driven by the join condition ARD.LINE_ID = LK.SOURCE_DISTRIBUTION_ID_NUM_1 with LK.APPLICATION_ID = 222 and LK.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'. The distribution link row then connects to XLA_AE_LINES on AE_HEADER_ID and AE_LINE_NUM, and to XLA_AE_HEADERS on AE_HEADER_ID. Cash receipt context is obtained through the condition ARD.SOURCE_TABLE = 'CRH' linking SOURCE_ID to CASH_RECEIPT_HISTORY_ID, and then to AR_CASH_RECEIPTS_ALL through CASH_RECEIPT_ID. The view also requires that CRH.EVENT_ID IS NOT NULL and restricts accounting class codes to values such as CASH and REMITTANCE.

Key Columns

Common Use Cases and Queries

Typical use cases include reconciling Receivables cash receipt distributions to their XLA-generated accounting entries, extracting CCIDs for a given receipt or accounting period, and validating that unrounded entered and accounted amounts match between the distribution and the XLA line.

A representative query retrieving accounting information for a cash receipt is shown below:

  • SELECT v.cash_receipt_id, v.line_id, v.code_combination_id, v.unrounded_entered_dr, v.unrounded_entered_cr, v.accounting_date FROM ar_xla_ard_lines_v v WHERE v.cash_receipt_id = :p_receipt_id;
  • Filter by ORG_ID and ACCOUNTING_DATE to reconcile a period: WHERE v.org_id = :p_org AND v.accounting_date BETWEEN :p_start AND :p_end.
  • Join the CCID to GL_CODE_COMBINATIONS to report the concatenated account string for a distribution.

Because the view enforces the XLA distribution link and the accounting class filter internally, reports can rely on it to return only those Receivables distributions that have been successfully accounted by Subledger Accounting.