Search Results maintain_mrc_data2

Overview

AR_MRC_ENGINE2 is a PL/SQL package body in the APPS schema that supports Multi-Reporting Currency (MRC) processing within Oracle Receivables. MRC allows a single transaction set to be maintained and reported in multiple functional currencies, a requirement for organizations operating under multiple regulatory jurisdictions or reporting standards. The package acts as a secondary entry point for maintaining and creating MRC data, complementing the older AR_MRC_ENGINE package. Its principal responsibility, as defined in the source header, is to serve as the initial entry point for all Receivables code that must maintain or create MRC data for the AR_DISTRIBUTIONS, AR_RECEIVABLE_APPLICATIONS, and RA_CUST_TRX_LINE_GL_DIST tables. The version header indicates the file has been stable since release 120.6, dated April 2005, and the package remains present in both 12.1.1 and 12.2.2 environments. Unlike its predecessor, this engine is scoped specifically to insert and update events; deletions to the referenced tables are explicitly excluded and are instead handled uniformly in the original AR_MRC_ENGINE.

Key Procedures and Functions

• MAINTAIN_MRC_DATA2 — The public entry point for MRC data maintenance. It is documented as the initial entry point for all Receivables code requiring MRC maintenance or creation, dispatching to the appropriate MRC API based on the caller's context. Its documented parameters include an event mode indicating whether an insert or update is being performed, a base table name, a primary key value used in single mode, a row-type record from AR_DISTRIBUTIONS, a mode selector distinguishing SINGLE from BATCH processing, and a key value list used in batch mode. Batch mode permits a set of key values to be processed in one call. Delete events are explicitly out of scope.
• MRC_BULK_PROCESS — A procedure providing bulk MRC processing, the term most closely associated with the user's search entry "mrc_bulk_process". Its documented role is to drive MRC maintenance across a set of records rather than a single row, which aligns with the batch-mode capability referenced in MAINTAIN_MRC_DATA2.
• MRC_CORRECT_ROUNDING — A procedure addressing rounding corrections within MRC data. Multi-currency conversion and redistribution can produce rounding residuals across the converted distributions, and this routine is documented to reconcile those amounts.

Tables Accessed

The documented table reference is AR_DISTRIBUTIONS, accessed through an APPS synonym. This is the core Receivables distributions table where accounting flexfield distributions for transactions are stored. The package header additionally names AR_RECEIVABLE_APPLICATIONS and RA_CUST_TRX_LINE_GL_DIST as tables whose MRC data is maintained through MAINTAIN_MRC_DATA2. AR_RECEIVABLE_APPLICATIONS records the application of receipts and credits against transactions, while RA_CUST_TRX_LINE_GL_DIST holds the general ledger distribution lines for customer transactions. The package writes converted MRC rows into the reporting-currency variants of these tables and reads the base-currency rows to derive them.

Usage Notes

The package is internal infrastructure rather than a user-facing component. It is invoked programmatically by standard Receivables transaction processing, including AutoInvoice, receipt application, and adjustments, whenever a transaction touches one of the three documented base tables and MRC reporting is enabled. The ETRM metadata records that the package is referenced by five other packages, confirming its role as a shared dependency in the Receivables MRC call chain. The presence of a key value list parameter and a dedicated bulk procedure indicates use in set-based operations, where many distributions are processed per call instead of row-by-row. The package should not be called directly from Forms; customizations needing MRC maintenance should invoke the standard Receivables APIs that in turn call this engine. Because delete handling is intentionally delegated to AR_MRC_ENGINE, code that must remove MRC rows for the referenced tables should not rely on AR_MRC_ENGINE2. Debug output is controlled through the AFLOG_ENABLED profile option, and the early null branch associated with Bug 4301323 reflects defensive handling introduced during maintenance. Any direct modification of this package body would require recompilation and invalidation review of its five dependent packages.