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

Last updated on JANUARY 21, 2016

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.

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