To download records from Oracle, use the Custom Query ribbon.
Use the Download Form to specify search values:
Use Download from Sheet to specify search values on the sheet:
Use Manage Queries to add or modify custom queries if required:
The fields used in the download query for this loader are below:
Database Columns
Wizard Column
gl_daily_rates_interface.rowid
Row_ID
gl_daily_rates_interface.batch_number
Batch Number
gl_daily_rates_interface.from_currency
From Currency
gl_daily_rates_interface.to_currency
To Currency
gl_daily_rates_interface.from_conversion_date
Start Date
gl_daily_rates_interface.to_conversion_date
End Date
gl_daily_rates_interface.user_conversion_type
Rate Type
gl_daily_rates_interface.conversion_rate
Rate
For more information about downloading using Custom Query please see the user documentation.
When updating records from the interface table, please note that before uploading them again with new values, you need to delete the existing interface records first. Oracle prevents insertion of two identical records if the only difference is the rate i.e. there must be a unique From_Currency, To_Currency, From_Date, To_Date, Rate_Type combination.
To delete a record from the Interface table, download the specific record to the sheet. Once it is downloaded, make sure the Row_ID column has downloaded data. Click on the Concurrent Processing > Delete From Interface option and it will mark the record as deleted. If it doesn’t find any records matching with the Row_ID to delete, the status will be left blank.
