Transaction Workbench Issue: Credit Memo Created via AutoInvoice Has Incorrect Accounting Which Causes Error to Be Raised: This action has been blocked to avoid inaccurate accounting entries

(Doc ID 1470098.1)

Last updated on JUNE 07, 2016

Applies to:

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

Symptoms

Attempting to create a credit memo and invoice through AutoInvoice.  The following distributions created:
 
Create invoice with no tax line
REC   4,460
REV   4,460
 
Create and apply credit memo.
REC  -4,248  
REV  -4,248
TAX    -212   <-- wrong, since Invoice has NO Tax, Credit memo is expected to not have TAX as well
 
In the Transactions form the following error occurs when attempting to incomplete the invoice:

This action has been blocked to avoid inaccurate accounting entries. Please contact Oracle Support Services
 
The Credits do not have any TAX line in RA_CUSTOMER_TRX_LINES_ALL, however the RA_CUST_TRX_LINE_GL_DIST_ALL shows a TAX line.
 
The tax line and tax distributions for this CM were submitted through RA_INTERFACE_DISTRIBUTIONS_ALL and RA_INTERFACE_LINES_ALL.
 
INVOICE:
 RA_INTERFACE_LINES_ALL --> 1 line (LINE only)
 RA_INTERFACE_DISTRIBUTIONS_ALL --> 2 lines (REC,REV)
 
CREDIT MEMO:
 RA_INTERFACE_LINES_ALL --> 2 lines (LINE,TAX)
 RA_INTERFACE_DISTRIBUTIONS_ALL --> 3 lines (REC, REV for LINE, TAX for Tax line)
 
As a result, even though there is no Tax line for Invoice, the applying CM has tax distributions.
 
The expectation is to add a validation not to create a tax line for CM when applying lines to an Invoice with no Tax line.

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