AutoInvoice Issue: Incorrect Rounding of Accounted Revenue Amount Causes Create Accounting to Fail with: The subledger journal entry does not balance in the entered currency (Doc ID 1409413.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
RAXTRX - Autoinvoice Import Program


Symptoms

For all invoices imported through AutoInvoice, the Revenue Amount in functional currency is incorrectly rounded to nearest whole number. It is not happening for manually created invoices.

Create Accounting Program gives the below error:

The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines.


When these orders are brought into AR via Autoinvoice, the distribution line is created with
acctd_amount <> amount in the RA_CUST_TRX_LINE_GL_DIST_AL table for Tax Lines.

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