Results for “original_gl_date”

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

Overview

RA_TRX_LINE_GL_DIST_MRC_V is an APPS-owned, VALID database view in the Oracle E-Business Suite Receivables (AR) module. Its name reflects its three defining characteristics: it exposes transaction line General Ledger distribution data (RA_TRX_LINE_GL_DIST), and it is an MRC view — a Multiple Reporting Currencies view — meaning it joins primary ledger distribution records with their corresponding reporting-currency equivalents. The purpose of such a view is to allow concurrent retrieval of distribution amounts as recorded in the primary set of books and the converted amounts recorded in one or more reporting sets of books, without the caller needing to write the join manually.

This view is not intended for direct data entry. It is a read-oriented construct used by reports, inquiries, and integration programs that must reconcile or present GL distribution data across multiple ledgers. The view is governed by MOAC (Multi-Org Access Control) and by the CLIENT_INFO session context, so its returned rows are automatically filtered by the user's current operating unit and reporting set of books.

Underlying Base Objects

The view is defined over exactly two documented base objects:

• RA_CUST_TRX_LINE_GL_DIST_ALL (SYNONYM) — the primary distribution table, aliased as PRIMARY. This is the transaction-level source of the distribution records and supplies the customer transaction identifiers, account class, code combination, percentages, GL dates, and descriptive attributes.
• RA_MC_TRX_LINE_GL_DIST (SYNONYM) — the multiple reporting currency distribution table, aliased as MC. This supplies the reporting set of books identifier, the converted amount, the accounted amount, posting control information, and the GL posted date.

The join is an equijoin on CUST_TRX_LINE_GL_DIST_ID. Row filtering is enforced through two predicates: the operating unit is matched against the first 10 characters of USERENV('CLIENT_INFO') (with a NVL default of -99), and SET_OF_BOOKS_ID is matched against the reporting set of books read from offset 45 of CLIENT_INFO. This confirms the view returns one row per distribution per reporting currency in the active session context.

Key Columns

The view exposes roughly fifty columns, drawn predominantly from the primary table with the currency-specific amounts taken from the MRC table.

• CUST_TRX_LINE_GL_DIST_ID — the join key and primary identifier of the distribution line.
• SET_OF_BOOKS_ID — the reporting set of books; sourced from the MRC table.
• CUSTOMER_TRX_ID and CUSTOMER_TRX_LINE_ID — the parent transaction header and line.
• ACCOUNT_CLASS — classification of the distribution (for example REC, TAX, FREIGHT, REV).
• AMOUNT and ACCTD_AMOUNT — the entered and accounted amounts in the reporting currency.
• CODE_COMBINATION_ID and CONCATENATED_SEGMENTS — the accounting flexfield reference and its display form.
• GL_DATE and ORIGINAL_GL_DATE — accounting date and its original value prior to re-derivation.
• PERCENT — the distribution percentage of the transaction line.
• GL_POSTED_DATE and POSTING_CONTROL_ID — posting status indicators from the MRC table.
• LATEST_REC_FLAG — indicates the most recent distribution record for a given line.
• REC_OFFSET_FLAG — the column referenced in the user's search; it flags distributions that represent receivable offset entries, distinguishing offset distributions from the primary revenue and tax distributions.

Common Use Cases and Queries

Typical uses include multi-currency distribution reconciliation, subledger-to-GL tie-out, and reporting on revenue, tax, and offset postings by reporting ledger. Because the view filters on CLIENT_INFO, callers should initialize the session context before querying so that ORG_ID and SET_OF_BOOKS_ID resolve correctly.

A representative query filtering on the searched column:

• SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, ACCOUNT_CLASS, SET_OF_BOOKS_ID, AMOUNT, ACCTD_AMOUNT, REC_OFFSET_FLAG, GL_DATE FROM APPS.RA_TRX_LINE_GL_DIST_MRC_V WHERE REC_OFFSET_FLAG = 'Y';

Additional practical patterns include aggregating accounted amounts by account class and set of books to reconcile the reporting ledger, and joining the view back to RA_CUSTOMER_TRX_ALL on CUSTOMER_TRX_ID to attribute distributions to specific transactions and customers. All such queries should be treated as read-only and executed with the appropriate org and ledger context set.