Results for “ar_mrc_engine2”

50+ results




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

Overview

AR_MRC_ENGINE2 is a PL/SQL package owned by APPS within the Oracle E-Business Suite Receivables module. It serves as a core component of the Multiple Reporting Currencies (MRC) architecture, which allows an organization to maintain accounting records in more than one functional currency simultaneously. The package acts as the initial entry point for all Receivables processing logic that must maintain, create, or delete MRC data across three specific base tables: AR_DISTRIBUTIONS, AR_RECEIVABLE_APPLICATIONS, and RA_CUST_TRX_LINE_GL_DIST. By centralizing this responsibility, the package ensures consistent propagation of base-table activity into the corresponding MRC tables. The ETRM documentation classifies this package as "OTHER" within the API taxonomy, indicating it is a technical engine rather than a public, customer-facing API intended for direct external consumption.

Key Procedures and Functions

The package exposes three documented procedures, each addressing a distinct element of MRC data maintenance.

  • MAINTAIN_MRC_DATA2 — The primary entry point for Receivables code to maintain, create, or delete MRC data. It accepts an event mode indicating the operation to perform, a base table name, and supporting key or row information, then dispatches to the appropriate MRC application programming interface. The procedure was originally authored in April 2002.
  • MRC_BULK_PROCESS — Designed for high-volume processing, this procedure is invoked by Auto Receipts to insert records into MRC tables using bulk operations. It leverages the ar_mc_info.rec_mrc_bulk_process API and supports MRC data for AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, and AR_PAYMENT_SCHEDULES. Bulk processing substantially reduces per-row overhead during receipt creation.
  • MRC_CORRECT_ROUNDING — Handles correction of rounding discrepancies that arise when base-currency amounts are converted into reporting currencies, ensuring MRC balances reconcile with the originating ledger.

Tables Accessed

The documented table referenced through APPS synonyms is AR_DISTRIBUTIONS, the base table storing accounting distributions for Receivables transactions. AR_MRC_ENGINE2 reads and writes this table as part of its role in maintaining corresponding MRC distribution records. The procedure documentation also identifies AR_RECEIVABLE_APPLICATIONS and RA_CUST_TRX_LINE_GL_DIST as base tables within its maintenance scope, though AR_DISTRIBUTIONS is the table captured explicitly in the ETRM metadata. These tables represent the transactional, application, and line-level distribution data that must be mirrored across reporting currency sets.

Usage Notes

AR_MRC_ENGINE2 is an internal engine, not a public API. It is invoked indirectly by standard Receivables processing — most notably Auto Receipts, which calls MRC_BULK_PROCESS — and by other packages within the Receivables code base. The ETRM metadata records that the package is referenced by five other packages, reflecting its role as a shared service across the module. Customers and implementers would not ordinarily call these procedures from custom code; instead, MRC data maintenance occurs transparently as users create transactions, receipts, and adjustments through standard Receivables forms and concurrent programs. The package header reveals that the source is version-controlled under the internal header ARMCEN2S.pls and carries AUTHID CURRENT_USER, meaning execution privileges derive from the calling schema. In 12.1.1 and 12.2.2 environments, the behavior is consistent: whenever MRC is enabled, this package ensures the base and reporting currency records remain synchronized.