Search Results ar_mrc_engine




Overview
Explore in AI Chat

Overview

AR_MRC_ENGINE is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its name reflects its role within the Multiple Reporting Currencies (MRC) architecture of Oracle Receivables and Oracle General Ledger. Multiple Reporting Currencies allows a single transaction entered in a primary functional currency to be automatically replicated and maintained in one or more additional reporting currencies, enabling statutory, corporate, and management reporting without duplicate data entry. AR_MRC_ENGINE serves as an engine-level utility that constructs and maintains the MRC representations of Receivables data, coordinating the creation, update, and deletion of reporting-currency rows in the associated MRC tables.

The package is classified as OTHER in the EBS API taxonomy, indicating that it is an internal engine rather than a public, supported API intended for direct customer invocation. This classification is consistent with its role as supporting infrastructure for standard MRC processing rather than a callable business interface.

Key Procedures and Functions

The documented package exposes three procedures or functions. Their purpose, inferred from naming conventions and the package's MRC context, is as follows:

  • MAINTAIN_MRC_DATA — The central routine for synchronizing Multiple Reporting Currencies records. It is invoked to propagate insert, update, and delete activity from the primary functional-currency rows to the corresponding reporting-currency rows, applying the appropriate currency conversion and rounding rules.
  • INIT_STRUCT — An initialization routine that prepares the internal data structures or working records required by the maintenance logic before processing begins. It establishes the state on which subsequent MRC operations depend.
  • MRC_BULK_PROCESS — A set-based, bulk processing entry point that drives MRC maintenance across many records in a single pass, rather than one row at a time. This is the routine typically used by concurrent and batch processing where throughput matters.

Each routine is oriented toward internal engine behavior; no documented parameter lists are published in the ETRM metadata, and consumers should not assume a stable callable signature.

Tables Accessed

The ETRM metadata for this object does not enumerate specific tables accessed through APPS synonyms. Functionally, the package is understood to operate on the Receivables base tables and their corresponding MRC shadow tables, which mirror the primary data in each enabled reporting currency. It reads the primary-currency distributions and writes the equivalent reporting-currency rows, converting amounts using the applicable exchange rate types and rate dates defined in the MRC configuration.

Usage Notes

AR_MRC_ENGINE is not designed for direct invocation by end users or standard custom code. It is called internally by standard Receivables processing, and the metadata records that it is referenced by nineteen other database objects, confirming its role as a shared dependency within the MRC processing chain. Alongside its own package specification, its documented dependencies include FND_PROFILE, used to read MRC-related profile options, and GL_CA_UTILITY_PKG, used to retrieve currency and conversion information. The metadata also records it as not referenced by any database object, indicating that no stored object invokes it externally and that its callers are the application-tier packages and concurrent programs that manage MRC data. Customizations should not call these procedures directly; instead, MRC should be maintained through standard Oracle forms and concurrent programs so that the engine's state and prerequisites remain consistent.