Adjustment Journal Report Shows Too Many Details (Doc ID 1532509.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Reports Issues
 
Adjustment Journal Report shows too many details. It is listing all activity on the adjustment
instead of actual adjustment. We need to display only the actual adjustment, not all
the activity surrounding the adjustment or transaction.


Example:
Transaction number 3914619 has two adjustments (418828 and 418831).
For Adjustment 418831 report output includes too many lines, ie:

418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 29.15 0.00 29.15 0.00 29.15
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 2.76 0.00 2.76 0.00 2.76
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 3.88 0.00 3.88 0.00 3.88
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 0.21 0.00 0.21 0.00 0.21
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 0.00 29.15 0.00 29.15 -29.15
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 0.21 0.00 0.21 0.00 0.21
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 0.00 2.76 0.00 2.76 -2.76
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 2.76 0.00 2.76 0.00 2.76
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 0.00 3.88 0.00 3.88 -3.88
418831 Adjustment MB FITNESS CLUBS LLC 9/5/12 3914619 3.88 0.00 3.88 0.00 3.88
..
..


The issue can be reproduced at will with the following steps:
Run Adjustment Journal Report and review output

The issue has the following business impact:
Due to this issue, users have too much data to balance to

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms