Multiple Lines Credit Memo created from Advanced Collections Dispute has Incorrect Tax (Tax is duplicated on all lines) (Doc ID 2754230.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Advanced Collections - Version 12.1 and later
Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Credit Memo is created with incorrect Tax % and Amount
It happens when there are more than 1 lines in the Invoice and create a Partial Dispute on the invoice from the Collections form
Dispute section=Total
The issue is noticed with Standard Tax as well as Inclusive Taxes
The issue is not reproduced if there is 1 Line in the Credit Memo or Invoice, or if Dispute is created for 100%

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Lets assume that a dispute is created on an Invoice that has 2 lines and 15% TAX
Line 1 =100 + 15% Tax =100 + 15 =115
Line 2 =200 + 15% Tax =200 + 30 = 230
Total = 345

This screenshot is taken from Receivables Responsibility
NAV : Transactions --> Transactions

2. Create a Dispute on this Invoice
Collections Agent Responsibility
NAV Collections form
Query up the customer using Organization field in Collections Header.
Go to Transactions Tab. Set the due date from and To to see the transaction created.
Select the invoice and click on Transaction Details screen.
Create a dispute using Dispute Pecent (less than 100%) and Dispute section=Total

3. Approve the Dispute as per your setup along with Workflow Background Process so that Credit Memo is created

4. Review the Credit memo in Receivables Responsibility
NAV : Transactions --> Transactions

Notice that same tax is calculated on all lines.

The expected Tax should be
Line 1 =-76.33+ 15% Tax =-76.33 + -11.45 = -87.78
Line 2 = -152.67 + 15% Tax =-152.67+ -22.90= -175.57
Total = -263.35

Additional Symptoms that are also noticed:

If Transaction has a Tax balance and try to create dispute for partial amount/percentage.
System reverts the percentage to 100 and the amount is reverted back to the full tax amount.