Exchange Rate Variance (ERV) Amount Is Not Correct for Miscellaneous Tax Distribution Lines During Difference In Currency Conversion Rate at Receipt Level and at Invoice Level

(Doc ID 2078770.1)

Last updated on DECEMBER 01, 2015

Applies to:

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


On : 12.1.3 version, India PO Localizations

Invoice tax lines are showing different amounts i.e more than receipt amount with different accounts during scenarios like the following one:-

1) Unit Of Material (UOM) Conversion Setup is as follows:-

1 PACK =1000 Each

2) Exchange Rate Setup is as follows:-

1 USD = 63.15 INR

3) Create PO with UOM PACK, currency USD.

4) Receive the material in Each UOM.

5) Create invoice with conversion different from PO conversion rate e.g. 1 USD = 70 INR

6) Match the invoice with the receipt. Also, add tax lines by matching with the receipt.

7) Exchange Rate Variance (ERV) Line for the tax line is becoming tax amount * Exchange Rate Difference * UOM Conversion rate. It should be tax amount * Exchange Rate Difference ideally.

Invoice tax lines should show same amount as receipt amount.

The issue cannot be reproduced at will as per customer confirmation.

The issue has the following business impact:
Due to this issue, users cannot pay the vendor correctly.


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