Showing posts with label #DailyRates #CurrencyConversion #PR #PO. Show all posts
Showing posts with label #DailyRates #CurrencyConversion #PR #PO. Show all posts

Wednesday 14 September 2022

Oracle Fusion: Foreign Currency Purchase Requisitions Creation Issue due to the Daily Rate Conversion

Subject: Enter PR Line Currency Conversion Rate Issue.


Resolution:

Navigation: Setup and Maintenance > Finance Application > Search Manage Daily Rates.

Click on Daily Rates Tab.

Search From EUR to GBP Currency conversion details for the Sep22 period. We not found Spot Conversion Rate for the 15SEP2022. We need to create Conversion Rate for this date to resolve the issue.

 


Click on Spread Sheet Button.

If SpreadSheet not asking to connect with Oracle Application than Excel ADFDi Addins are missing.

User Need to Enable those Addins. Refer below link for enabling ADFDi Addin.


Oracle Fusion: ADFDI sheet is blank after opening


We need to connect spreadsheet with oracle instance. Click on Yes


Enter User Name and Password of Oracle Application and Login.



Enter the Spread Sheet Data For Conversion Rate. Click on Submit button from the Top Menu.


Click on Ok. It will Run Background Request.


It will process the data

 


It will show record successfully Inserted.


We can verify the data from Manage Daily Rate Screen. Now we can able to see the daily rates for 15SEP2022

 


Now we user try to create foreign currency requisition system will not through an error.