Rate Interface Design Idea for Oracle Apps
Reuters, Bloomberg are vendors who provide currency rates. Many applications in the business world fetches the daily rates from them and import them into the applications. The same can also be done in oracle EBS by following the design steps below,
1. Generate a rate request file according the guide provided by the vendor. Can be produced by running a concurrent program which will write the rate request file in the form of a CP output file.
2. A shell script can be called from EBS to encrypt the out file and send it to the vendor through FTP or any other suitable media.
3. Send the encrypted request file to the vendor through ftp or any other media.
4. Obtain the response file from the vendor and decrypt it.
5. Again use a shell program to load the data into GL_DAILY_RATES_INTERFACE table.
6. Call the concurrent program “Program - Daily Rates Import and Calculation”.
7. Follow the standard oracle apps processes for rate import until the end.
This article can also be helpful.
http://realworldoracleapps.blogspot.se/2008/02/currency-exchange-rate-interface.html
Reuters, Bloomberg are vendors who provide currency rates. Many applications in the business world fetches the daily rates from them and import them into the applications. The same can also be done in oracle EBS by following the design steps below,
1. Generate a rate request file according the guide provided by the vendor. Can be produced by running a concurrent program which will write the rate request file in the form of a CP output file.
2. A shell script can be called from EBS to encrypt the out file and send it to the vendor through FTP or any other suitable media.
3. Send the encrypted request file to the vendor through ftp or any other media.
4. Obtain the response file from the vendor and decrypt it.
5. Again use a shell program to load the data into GL_DAILY_RATES_INTERFACE table.
6. Call the concurrent program “Program - Daily Rates Import and Calculation”.
7. Follow the standard oracle apps processes for rate import until the end.
This article can also be helpful.
http://realworldoracleapps.blogspot.se/2008/02/currency-exchange-rate-interface.html
No comments:
Post a Comment