The Accounted Amount And Entered Amount For The Subledger Jounral Entry Line Have Different Sign (Doc ID 2133397.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Accounting Issues in AP

When attempting to create accounting
the following error occurs.

ERROR
-----------------------
'The accounted amount and entered amount for the subledger jounral entry line have different sign


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Insert data into ap_invoices_interface and ap_invoice_lines_interface.
 created 1 invoice with 490 invoice lines of line type as 'ITEM'.

Each line has the same amount as 9.28. The tax rate is 0.13000087966221.

This brings the tax amount of each tax line to be 1.20640816326531 (9.28*0.13000087966221).

After rounding, the tax amount is 1.21.

There are 490 invoice lines. So, the sum of all tax lines is 592.9 = 490


amount in Tax Control is in the invoice.

The amount is 591.14 =490*9.28*0.13000087966221.

This is to make sure the total tax amount is correct.

The creates a difference of 1.76 (592.9-591.14).

To resolve the difference, system put the variance into the first distribution line. 1.21-1.76=-0.55.

3. Check the invoice, make sure the tax control amount is in the invoice.

4. Validate the invoice.

5. Check the first distribution line of 'REC_TAX' and we found the amount is negative.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create accounting and transfer to GL

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