Search Results ra_mc_trx_line_gl_dist




Overview
Explore in AI Chat

Overview

RA_MC_TRX_LINE_GL_DIST is a Receivables (AR) module table in the Oracle E-Business Suite, owned by the AR schema. Its documented description identifies it as the store for currency and accounting records covering revenue, unearned revenue, and unbilled receivables. The table therefore functions as the multi-currency distribution store that carries the accounting entries generated for transaction lines before those entries are transferred to the General Ledger. It bridges the Receivables subledger transaction model and the accounting engine, holding both entered and accounted amounts alongside the posting control state that governs transfer to GL.

The ETRM metadata classifies this object, using a heuristic derived from its foreign key structure, as a standalone data vault entity. This classification should be treated as a modeling suggestion rather than a normative statement; in practice the table behaves as a satellite-like distribution record attached to transaction lines and the posting control hub, with its two-part primary key providing the composite identity.

Key Information Stored

The documented physical schema contains ten columns. The surrogate and composite primary key is RA_MC_TRX_LINE_GL_DIST_PK, defined across CUST_TRX_LINE_GL_DIST_ID and SET_OF_BOOKS_ID. A unique index, RA_MC_TRX_LINE_GL_DIST_U1, is defined on the same two columns, making this pair the business-key candidate that guarantees at most one distribution record per distribution identifier per ledger.

  • CUST_TRX_LINE_GL_DIST_ID — the distribution identifier; the first component of both the primary key and the unique index.
  • SET_OF_BOOKS_ID — the ledger or set of books context; the second key component, allowing the same distribution identifier to exist across multiple ledgers.
  • CUSTOMER_TRX_ID — the transaction header identifier, linking the distribution back to its originating transaction.
  • ACCOUNT_CLASS — classifies the accounting nature of the line, such as revenue, unearned revenue, or unbilled receivables.
  • AMOUNT — the entered (transaction currency) amount of the distribution.
  • ACCTD_AMOUNT — the accounted amount in the functional currency of the ledger.
  • GL_POSTED_DATE — the date on which the entry was posted to the General Ledger.
  • POSTING_CONTROL_ID — foreign key to AR_POSTING_CONTROL, relating the distribution to its posting batch or run.
  • LAST_UPDATE_DATE and LAST_UPDATED_BY — standard audit columns recording the most recent change.

Common Use Cases and Queries

Typical reporting scenarios include reconciliation of revenue and unearned revenue balances by ledger, analysis of unbilled receivables, and verification of General Ledger transfer status. A frequent query pattern joins the distribution to its posting control record to determine whether entries have been transferred:

  • Reconcile accounted balances by account class and ledger, summing ACCTD_AMOUNT grouped by SET_OF_BOOKS_ID and ACCOUNT_CLASS.
  • Identify unposted distributions by selecting rows where GL_POSTED_DATE is null, joined to AR_POSTING_CONTROL on POSTING_CONTROL_ID.
  • Trace distributions for a specific transaction by filtering on CUSTOMER_TRX_ID.
  • Compare entered versus accounted amounts to surface currency conversion differences at the line level.
  • Feed subledger accounting extracts by selecting postable rows ordered by SET_OF_BOOKS_ID and CUST_TRX_LINE_GL_DIST_ID.

Related Objects

  • AR_POSTING_CONTROL — referenced by the POSTING_CONTROL_ID foreign key; governs the posting batch for each distribution.
  • RA_CUSTOMER_TRX_LINES — source of transaction line detail referenced via CUSTOMER_TRX_ID.
  • RA_CUSTOMER_TRX — transaction header providing context for the distribution.
  • RA_CUST_TRX_LINE_GL_DIST — the base distribution table sharing the same distribution identifier semantics.
  • GL_JE_LINES — General Ledger journal lines produced when distributions are transferred.
  • GL_IMPORT_REFERENCES — cross-reference linking subledger distributions to their journal entries.