Results for “ar_xla_lines_extract_n1”

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

Overview

APPS.AR_DISTRIBUTIONS_BASE_V is a reporting view in the Oracle E-Business Suite Receivables (AR) module that exposes accounting distribution lines for subledger accounting (SLA) processing and downstream reporting. It consolidates line-level data from the Receivables extract populated by the Subledger Accounting Engine, presenting amounts, currencies, conversion attributes, and ledger context in a form suitable for transfer to General Ledger and for financial inquiry. The view is particularly relevant in Oracle EBS 12.1.1 and 12.2.2, where the SLA architecture routes Receivables activity through AR_XLA_LINES_EXTRACT before generating final accounting entries. The column name referenced in the search term, dist_cur_conversion_type, is exposed directly from the source extract column exchange_rate_type and describes the currency conversion rate type applied to a distribution line.

Underlying Base Objects

The view is defined primarily over the AR_XLA_LINES_EXTRACT table, joined in the ETRM metadata through synonyms to several Receivables base objects including AR_DISTRIBUTIONS_ALL, AR_CASH_BASIS_DISTS_ALL, AR_CASH_RECEIPTS_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, and RA_CUSTOMER_TRX_ALL. The extraction logic is a UNION of queries partitioned by posting_entity, covering Adjustment (ADJ), Cash Receipt (CRH), and Bill Receivables activities. Each branch applies the same filter set: posting_entity matching the activity class, level_flag equal to 'L' to restrict rows to line level, and mfar_additional_entry equal to 'N' to exclude multi-fund additional entries. The hint INDEX (li ar_xla_lines_extract_n1) drives access through the extract index for performance.

Key Columns

• event_id — The subledger accounting event identifier linking the distribution to its originating transaction.
• base_currency — Sourced from base_currency_code; the ledger's base currency for the distribution.
• line_id — Extracted accounting line identifier used for drill-down to the SLA line.
• dist_cur_conversion_type — The exchange rate type (from exchange_rate_type) applied to convert the entered amount to the distribution currency.
• dist_cur_conversion_rate / dist_cur_conversion_date — The conversion rate and effective date for the distribution currency conversion.
• dist_acctd_amt — The accounted amount for the distribution; for Cash Receipts with a receivables_trx_id of -16, this is replaced by from_acctd_amount.
• dist_to_acctd_amt, dist_to_cur_conversion_type, dist_to_cur_conversion_rate, dist_to_cur_conversion_date — Parallel conversion attributes supporting the "to" accounted amount.
• gain_loss_amt / gain_loss_sign — Reserved as NULL in the extract view; gain/loss is handled elsewhere in the SLA pipeline.
• line_number, language, ledger_id — Sequencing and contextual identifiers for the distribution line and its ledger.

Common Use Cases and Queries

This view is typically queried to validate accounting distributions prior to or after transfer to GL, to reconcile subledger balances, and to investigate currency conversion attributes. A representative query follows:

SELECT event_id, line_id, base_currency, dist_cur_conversion_type, dist_cur_conversion_rate, dist_acctd_amt, ledger_id FROM apps.ar_distributions_base_v WHERE event_id = :p_event_id ORDER BY line_number;

A second common pattern filters by conversion type to audit rate usage:

SELECT led.ledger_id, v.dist_cur_conversion_type, COUNT(*) FROM apps.ar_distributions_base_v v, apps.gl_ledgers led WHERE v.ledger_id = led.ledger_id GROUP BY led.ledger_id, v.dist_cur_conversion_type;

Integration consumers frequently join the view to AR_XLA_LINES_EXTRACT or AR_DISTRIBUTIONS_ALL using line_id or event_id for reconciliation and drill-down reporting.