Search Results mrc_amount




Overview
Explore in AI Chat

Overview

The RA_TRX_LINE_GL_DIST_ALL_MRC_V view in Oracle EBS 12.1.1 and 12.2.2 is a Multi-Reporting Currency (MRC) view owned by the APPS schema and defined within the Oracle Receivables (AR) product. It presents distribution accounting information for receivable transaction lines across multiple sets of books, allowing reporting and integration processes to retrieve general ledger distribution data that has been translated into each configured reporting currency. The view combines the primary ledger distribution rows stored in RA_CUST_TRX_LINE_GL_DIST_ALL with their corresponding reporting-currency counterparts in RA_MC_TRX_LINE_GL_DIST. This design supports MRC environments where a single transaction must be reflected in several sets of books with different functional currencies. The view is particularly relevant to users searching on mrc_amount, since that column surfaces the reporting-currency amount associated with each distribution line, complementing the primary-currency AMOUNT and accounted ACCTD_AMOUNT values.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view references two base objects through synonyms: RA_CUST_TRX_LINE_GL_DIST_ALL and RA_MC_TRX_LINE_GL_DIST. The primary source table, RA_CUST_TRX_LINE_GL_DIST_ALL, stores the core revenue distribution lines generated when an AutoInvoice or manual transaction is created, including the account class, code combination, amount, and accounting date. The MRC companion table, RA_MC_TRX_LINE_GL_DIST, holds the reporting-currency equivalents keyed to the same distribution line. The view join is defined on CUST_TRX_LINE_GL_DIST_ID between the two tables, and it is further constrained by a SET_OF_BOOKS_ID filter that uses the session's CLIENT_INFO value (with a fallback of -99 when no set of books is available in the client context). This means the view returns data only for the reporting set of books currently identified by the application session, which is standard behavior for MRC views in EBS.

Key Columns

The view exposes identification and accounting columns drawn from both base tables. From the primary table, CUST_TRX_LINE_GL_DIST_ID is the unique distribution identifier, while CUSTOMER_TRX_ID and CUSTOMER_TRX_LINE_ID link the row back to its transaction and line. ACCOUNT_CLASS identifies the distribution type (for example, Revenue, Tax, Freight, or Receivable), and CODE_COMBINATION_ID and CONCATENATED_SEGMENTS describe the accounting flexfield. The primary amounts are carried in AMOUNT and the accounted ACCTD_AMOUNT, with GL_DATE and GL_POSTED_DATE giving the accounting and posting dates. The reporting set of books is identified by SET_OF_BOOKS_ID, and the reporting-currency values appear as MRC_AMOUNT (the amount translated into the reporting currency), MRC_ACCTD_AMOUNT, MRC_ACCOUNT_CLASS, MRC_CUSTOMER_TRX_ID, and the reporting posting dates and control identifiers. Supplementary columns include PERCENT, salesperson reference, multi-currency related fields, descriptive flexfield attributes, and audit columns such as CREATED_BY and LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical use cases include reconciling Receivables distributions to the general ledger across multiple sets of books, validating that reporting-currency amounts agree with the primary ledger, and feeding downstream extracts or interfaces that require both functional and reporting-currency values. A commonly used query retrieves the reporting-currency amount alongside the primary amount for a given transaction:

  • Selecting CUST_TRX_LINE_GL_DIST_ID, SET_OF_BOOKS_ID, CUSTOMER_TRX_ID, ACCOUNT_CLASS, AMOUNT, MRC_AMOUNT, and GL_DATE from the view filtered by CUSTOMER_TRX_ID to review how a single transaction distributes across reporting books.
  • Aggregating MRC_AMOUNT by ACCOUNT_CLASS and SET_OF_BOOKS_ID to produce reporting-currency balances for reconciliation against the GL.
  • Joining the view to RA_CUSTOMER_TRX_ALL and GL_CODE_COMBINATIONS to present human-readable account descriptions for MRC distributions.

Because the view is filtered by the session's set of books, queries should be executed in an environment with a valid MRC client context, or the caller should account for the -99 fallback that returns no reporting-currency rows.