Discrepancy Of Rounding In Values - Im_doc_head,im_doc_tax And Im_ap_stage_head Values (Doc ID 3015357.1)

Last updated on APRIL 09, 2024

Applies to:

Symptoms

Apply hotfix REIM_16.0.3_CUMULATIVE_HF_MAR_2024_1

ACTUAL BEHAVIOR
---------------
Discrepancy of rounding in values - Im_doc_head,im_doc_tax and im_ap_stage_head values



EXPECTED BEHAVIOR
-----------------------
There should not be Discrepancy of rounding in values - Im_doc_head,im_doc_tax and im_ap_stage_head values

STEPS
-----------------------
The issue can be reproduced at will with the following steps:



1.Create a Credit not request for an amount which is not rounded figure ex. 271.89
2. Post applying the tax rate ex. 5% im_doc_tax will have 13.5945 ( adds to 271.89+13.5945 = 285.4845)
3. Same amount flows to Account Payable tables and is posted with 271.895 and 13.59 as tax. (271.895+13.59 = 285.485)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users are seeing around 1500 invoices are getting posted every day from REIM TO EBS. If each invoice has 0.005 difference also then it becomes 75 KD.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.