Search Results rcv_mc_sub_ledger_details




Overview
Explore in AI Chat

Overview

RCV_MC_SUB_LEDGER_DETAILS is the Multiple Reporting Currencies (MRC) sub-ledger subsidiary table that mirrors RCV_SUB_LEDGER_DETAILS within the Purchasing (PO) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the accounting distributions generated for receiving transactions managed by the Receiving (RCV) module, expressed in one or more reporting currencies rather than only the functional (set of books) currency. Each row corresponds to a single accounting entry line produced when a receipt, delivery, correction, or return is accounted. Because it is a physical sub-table of RCV_SUB_LEDGER_DETAILS, records are created and maintained by the same receiving accounting programs (logical name RCV). The object is classified as valid and owned by the PO schema, containing 75 documented columns.

Following Oracle's MRC architecture, this table exists whenever a set of reporting currencies has been enabled for a set of books. It stores accounting amounts simultaneously in the reporting currency alongside the functional-currency values held in the parent table. The heuristic Data Vault classification mined from the FK structure is standalone; from a modeling-suggestion perspective, this object is best treated as a satellite — a context-dependent descriptor of the receiving accounting event — rather than a hub or link, since it carries descriptive and financial attributes keyed to an underlying transaction.

Key Information Stored

Although the table exposes 75 columns, the following carry the substantive business content:

Common Use Cases and Queries

Typical reporting scenarios reconcile sub-ledger accounting entries to General Ledger by reporting currency, and audit receiving distributions that failed to transfer.

  • Reconcile MRC to parent currency — join RCV_MC_SUB_LEDGER_DETAILS to RCV_SUB_LEDGER_DETAILS on RCV_SL_DETAILS_ID to compare reporting-currency amounts with functional-currency amounts.
  • Unposted entries — filter where GL_SL_LINK_ID IS NULL and JE_SOURCE_NAME = 'Purchasing' to identify lines not yet transferred to GL.
  • Account analysis — aggregate ACCOUNTED_DR and ACCOUNTED_CR by CODE_COMBINATION_ID and PERIOD_NAME for a given CURRENCY_CODE.
  • Tax reporting — sum ENTERED_REC_TAX and ENTERED_NR_TAX per accounting period.

A representative query pattern selects from RCV_MC_SUB_LEDGER_DETAILS where SET_OF_BOOKS_ID = :ledger and PERIOD_NAME = :period, grouping by CURRENCY_CODE and CODE_COMBINATION_ID.

Related Objects