My Oracle Support Banner

Issues fixed in Receipt Journal Report with Parameter Report Mode = Balance (Doc ID 2561418.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
ARXRJR : Receipt Journal Report


On : 12.1.3 version, Reports Issues

Receipt Journal Report has a parameters called Report Mode
The common value is Transaction.
There is another option Balance
As per Oracle Receivables User Guide
Report Mode: The mode in which to print the report.
If run in Balance mode, Receivables displays receipts only in their last status.
If run in Transaction mode, Receivables displays every transaction entering and leaving each status.
For example, if a receipt that had been remitted is now cleared,it will appear in both the remitted status and the cleared status of the report.
In the remitted status it will appear as entering the status (as a positive amount) as well as leaving the status (as a negative amount).
The net effect being a zero balance in the remittance account.

There are 2 major issues reported with Receipt Journal Report in Balance mode 
1) It displays Reversed Receipts with the amount which is causing confusion to the user as amounts and totals are wrong. 
2) Batch Date and GL Date  are null when we run Report in Balance 

Receipt Journal Report to match with GL balances and Reversed receipts should not appear in the Report


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.