Currency Change on Catalog Item Results In Incorrect Unit Price
Last updated on JUNE 15, 2017
Applies to:Oracle iProcurement - Version 12.2.6 and later
Information in this document applies to any platform.
In Oracle iProcurement, Release 12.2.6, the user is adding an item to cart and before submitting the requisition, user is updating a line of the requisition. When the Currency field is changed, automatically the Exchange Rate Type, Exchange Rate Quote, Exchange
Rate Date and Exchange Rate comes up. However, the Unit Price of the item is still the same but having a different currency. As a result, the item price is incorrect.
Steps To Reproduce
The issue can be reproduced at will in a Vision Demo environment with the following steps:
1. Log in to Oracle Applications, using an iProcurement responsibility.
2. Add inventory item to cart. This is a master item not tied to any source document (BPA, req template, quotation, etc). Unit Price is 15.00 USD.
3. View Cart and Checkout
4. In the Shopping Cart pop-up window, the price is seen as 15.00 USD. Click the Edit icon.
5. On the Edit and Submit Requisition page, the page shows the following values:
Price = 15 USD
Amount = 15.00 USD
Amount (USD) = 15.00
6. Click the Update Line (pencil) icon for the item line.
7. In the Update Line pop-up window, use the drop-down LOV to change Currency from USD to EUR.
At this point, the Unit Price is still showing as 15.00 and is not editable, and the following values now appear in the window:
Exchange Rate Type = Corporate
Exchange Rate Date = 25-APR-2017
Exchange Rate = 0.9995
8. Click the Apply button.
9. Now back on the Edit and Submit Requisition page, the line now shows the following values:
Price = 14.9925 EUR (this is 15.00 USD x 0.9995 EUR exchange rate)
Amount = 14.9925 EUR
Amount (USD) = 14.99
This results in changing the item's price.
In Step 9, the user is expecting to see:
Price = 15.0075 EUR (this would be 15.00 USD divided by the 0.9995 exchange rate)
Amount = 15.0075 EUR
Amount (USD) = 15.00
Again, the "problem" seems to be that the original value of "15" was entered using the base currency "USD"; however when the currency value was changed from USD to EUR, the unit price value remained as 15, so the actual value of USD has changed to 14.99 even though it seems it should stay as 15.00.
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