Results for “rounding_correction_flag”

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

Overview

AR_CUST_TRX_LINES_BASE_V is a read-only Oracle EBS view owned by the APPS schema and defined in the Receivables (AR) product. It exposes the transaction line base extract for Subledger Accounting (SLA) processing. In Oracle EBS 12.1.1 and 12.2.2, the view serves as a reporting and extraction layer over the SLA line-level accounting extract, joined to the Receivables transaction line GL distribution table. Its documented description is "transaction line base extract," indicating that it delivers the line-level base amounts, currency conversion attributes, and ledger context required to reconcile or report on Receivables transaction line accounting entries.

Typically, this view is used when the Subledger Accounting engine needs to extract line-level base data for journal creation, or when technical consultants build custom reports and interfaces that require transaction line amounts in both entered and accounted (base) currency. The view is valid in the dictionary and is intended for query access rather than direct DML.

Underlying Base Objects

The view is defined over two documented base objects:

• AR_XLA_LINES_EXTRACT (SYNONYM) — the line-level SLA extract table that stores event and line accounting information, aliased as HE. The view enforces that CUST_TRX_LINE_GL_DIST_ID is not null, LEVEL_FLAG equals 'L', and POSTING_ENTITY equals 'CTLGD', ensuring only line-level Receivables distribution records are returned.
• RA_CUST_TRX_LINE_GL_DIST_ALL (SYNONYM) — the Receivables transaction line GL distribution table, aliased as CTLGD. It joins to the extract on CUST_TRX_LINE_GL_DIST_ID, providing the distribution-level attributes used by the view.

The view's text employs the hint /*+ INDEX(HE AR_XLA_LINES_EXTRACT_N1) */, indicating the index on the extract table drives access. The join is an inner join between the extract and the GL distribution table, so every row returned represents a matched SLA line extract and its corresponding Receivables distribution.

Key Columns

• EVENT_ID — the SLA event identifier, used to group transaction lines under a single accounting event.
• LINE_ID — sourced from CUST_TRX_LINE_GL_DIST_ID, uniquely identifying the Receivables GL distribution line.
• TRX_LINE_CUR_CODE — the transaction line's base currency code from the extract.
• TRX_LINE_CUR_CONVERSION_TYPE, TRX_LINE_CUR_CONVERSION_DATE, TRX_LINE_CUR_CONVERSION_RATE — the currency conversion type, date, and rate applied to the transaction line.
• TRX_LINE_ACCTD_AMT — the accounted (base currency) amount for the transaction line.
• LINE_NUMBER — the distribution line number.
• LANGUAGE — the language code associated with the extract record.
• LEDGER_ID — the ledger identifier for the accounting context.
• ROUNDING_CORRECTION_FLAG — indicates whether the distribution line represents a rounding correction.

Common Use Cases and Queries

The view supports subledger reconciliation, base-currency reporting, and custom SLA extracts. A common requirement is to list all line-level accounted amounts for a given ledger or event, for example:

SELECT event_id, line_id, trx_line_cur_code, trx_line_acctd_amt, ledger_id
FROM apps.ar_cust_trx_lines_base_v
WHERE ledger_id = :ledger_id
ORDER BY event_id, line_number;

Another scenario identifies rounding correction lines that may require review:

SELECT line_id, event_id, trx_line_acctd_amt, rounding_correction_flag
FROM apps.ar_cust_trx_lines_base_v
WHERE rounding_correction_flag = 'Y';

Consultants may also join the view back to RA_CUST_TRX_LINE_GL_DIST_ALL on LINE_ID to retrieve additional distribution attributes, or aggregate TRX_LINE_ACCTD_AMT by LEDGER_ID and EVENT_ID for control totals. Because the view filters on LEVEL_FLAG = 'L' and POSTING_ENTITY = 'CTLGD', it should be understood as delivering strictly line-level Receivables distribution extracts, not header or tax-level SLA data.