Integrating bank currency daily rate file with your Oracle GL Daily Currency rate file
Dear GL Guru,
We are currently in EBS release 12.1.3 running GL, AP, AP, FA, CE , PO, XTR, iExp, iProcure, iSupplier.
We Just implemented our AP application with multi currencyfunctionality.
Now we are in a process of implementing the daily currency rates.
I have the following questions regrading integrations approach in order to obtain and download Daily Currency Rate file from bank:
1- Work with a bank or financial currency rate file provider to connect to their bank server and pull the daily currency rate file via a batch process over SFTP connection. Then
run the Oracle GL batch process to upload the bank file into GL currency rate interface table and finally to GL Currency base table so Oracle subledgers like AP be able to use the