Adjustment showing Double or Triple accounting when running Create Accounting (Doc ID 786302.1)

Last updated on APRIL 22, 2019

Applies to:

Oracle Receivables - Version 12.0.5 to 12.0.5 [Release 12.0]
Information in this document applies to any platform.
This problem can occur on any platform.
ARPDDB.pls

Symptoms

Running Create Accounting the values for Adjustment are showing as triplicate accounting in ar_distributions all
when adjustment is applied to an Invoice with rules.

Check the values of ar_distributions_all you will see that you have more debits <> credits.
This is because the UNEARN values for Adjustments with rules are on the wrong side of the equation.
Data fix will need to be performed to correct the entries in ar_distributions_all for the adjustments generated.