My Oracle Support Banner

TOTAL_ITEM_VALUE and TOTAL_INVOICE_VALUE is Wrong in JAI_IRN_DETAILS when UNIT_PRICE is in 3 Decimals (Doc ID 2856161.1)

Last updated on MARCH 15, 2022

Applies to:

Oracle Financials for India - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, GST E-Invoicing

ACTUAL BEHAVIOR
---------------------
TOTAL_ITEM_VALUE and TOTAL_INVOICE_VALUE is wrong in JAI_IRN_DETAILS when UNIT_PRICE is in 3 Decimals.

EXPECTED BEHAVIOR
-----------------------
TOTAL_ITEM_VALUE and TOTAL_INVOICE_VALUE should be calculated correctly in JAI_IRN_DETAILS.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Sales Order (N) > Oracle Order management > Orders,Returns > Sales Order.
2. Populate the Header and Line details. Lets Say Quantity 5000 and UNIT_PRICE 575.675.
3. Navigate back to Header .Tools > India Tax Details.
4. Add Taxes.
5. Book the order.
6. Pick Release and Ship Confirm the same.
7. In JAI_IRN_DETAILS, TOTAL_ITEM_VALUE and TOTAL_INVOICE_VALUE is calculated incorrectly.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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