My Oracle Support Banner

RX-only: Miscellaneous Receipts Register (ARRXMTRG) Report Displaying Incorrect Functional Amounts. (Doc ID 2108178.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Reports Issues


The report "Miscellaneous Receipts Register" (ARRXMTRG) is displaying the "Functional Amount" as the functional receipt amount instead of the receipt amount that corresponds to the specific receipt distribution .

The report will display the "Functional Amount" field (the last field) as 110.04 for both the account distributions (D1 and D2) .

As a result , the summary total fields by currency and report display 220.08 instead of 110.04 .

The report should actually display the corresponding functional amounts that is specific to the distributions in the "Functional Amount" field instead of receipt functional amount .


011.9000.XXX.703XXX.0000 - Functional Amount value should be 40 EUR - Converted to USD .,
011.9000.XXX.703YYY.0000 - Functional Amount value should be 60 EUR - Converted to USD .,

The report should show the functional amounts equal to the distributions instead of the total amount

The issue can be reproduced at will with the following steps:
1) Create a miscellaneous receipt in EUR (Functional currency - USD) . Entered amt - 100 EUR . Functional amt - 110.04 USD
2) Create two distributions . D1 - 60 EUR ; D2 - 40 EUR .
3) Run the "Miscellaneous Receipts Register" report .

The issue has the following business impact:
Due to this issue, customer's month end reconciliation as part of the AR Close is getting delayed as the numbers do not match


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.