Search Results ar_xla_lines_extract_n3




Overview
Explore in AI Chat

Overview

APPS.AR_DISTRIBUTIONS_L_V is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes Accounts Receivable accounting distributions in a normalized, extract-friendly format. It is defined over AR_XLA_LINES_EXTRACT — the staging mechanism used by Subledger Accounting (SLA/XLA) to assemble distribution lines prior to transfer to the General Ledger — joined to the receivables distribution tables. The view presents one row per accounting distribution line linked to an extract line, resolving the "entered" amount for each line as the net of credit and debit amounts.

The name suffix _L_V reflects the "line"-level construct combined with a language join, since the view selects l.language from AR_XLA_LINES_EXTRACT. The view is central to the ETRM (E-Business Suite Technical Reference Manual) documentation and is frequently referenced when troubleshooting SLA extract issues, receivable-to-GL reconciliation, and custom subledger reporting. The presence of the /*+INDEX(l ar_xla_lines_extract_n1)*/ hint in each UNION branch indicates the view is tuned for access via the AR_XLA_LINES_EXTRACT index, reflecting its intended use in high-volume extract processing.

Underlying Base Objects

ETRM metadata documents the following referenced base objects: AR_DISTRIBUTIONS_ALL, AR_CASH_BASIS_DISTS_ALL, AR_CASH_RECEIPTS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, AR_XLA_LINES_EXTRACT, RA_CUSTOMER_TRX_ALL, RA_CUST_TRX_TYPES_ALL, and the package ARP_XLA_EXTRACT_MAIN_PKG. The view text shows a UNION of at least two branches: one joining AR_DISTRIBUTIONS_ALL (alias dat) to AR_XLA_LINES_EXTRACT (alias l), and a second joining a further distribution source (alias daf). The join predicates require matching source_id, source_table, and line_id, with filter conditions l.posting_entity = 'ADJ', l.level_flag = 'L', and l.mfar_additional_entry = 'N'. The package ARP_XLA_EXTRACT_MAIN_PKG is the procedural engine that populates the extract tables consumed here.

Key Columns

The view exposes identifiers and amounts needed to build subledger journal entries. event_id identifies the accounting event; dist_line_id (aliased from line_id) identifies the distribution line. distribution_type is a hard-coded literal 'AR_DISTRIBUTIONS_ALL'. dist_code_combination_id carries the accounting flexfield for the distribution, while dist_source_id, dist_source_table, and dist_source_type (with _secondary variants) trace the originating transaction. dist_tax_link_id links tax-related distributions. dist_ent_amt — the column the user searched for — is computed as NVL(dat.amount_cr,0) - NVL(dat.amount_dr,0), representing the entered amount of the distribution. dist_ent_amt_from carries the same computation for the "from" side of the entry, and dist_currency_code / dist_currency_code_from identify the respective currencies. Party columns (dist_party_type, dist_party_id, dist_party_site_id) are decoded from third_party_id. ledger_id identifies the ledger, and dist_paired_ccid with dist_paired_source_type ('REC') supports paired-entry reconstruction.

Common Use Cases and Queries

The view is used to diagnose SLA extraction, reconcile AR subledger balances to GL, and build custom distribution reports. Because dist_ent_amt is a searched column, a typical query filters or aggregates on it:

  • Locate distributions for a given event: SELECT event_id, dist_line_id, dist_code_combination_id, dist_ent_amt, dist_currency_code FROM apps.ar_distributions_l_v WHERE event_id = :event_id;
  • Sum entered amounts by code combination: SELECT dist_code_combination_id, SUM(dist_ent_amt) FROM apps.ar_distributions_l_v GROUP BY dist_code_combination_id;
  • Investigate a specific source transaction via dist_source_id and dist_source_table, then cross-reference RA_CUSTOMER_TRX_ALL or AR_CASH_RECEIPTS_ALL.
  • Validate unbalanced entries by comparing dist_ent_amt against dist_ent_amt_from.

Note that the view applies the 'ADJ' posting entity filter and level_flag 'L', so it is not a complete extract of every AR distribution; report consumers must account for these restrictions when reconciling totals.