Download Query functionality is included as standard in each Loader: this tool enables the user to download existing data from the Oracle EBS Application using their own defined queries. This can be used via the Download option in the Loader ribbon.
Some Loaders may be provided with one or more pre-defined Download Queries which have been specifically tailored to that Loader. In such cases, an additional XML file is provided within the Loader zip file. Such files can be easily identified as the file name begins with the “DOWNLOAD_” or “download_” prefix.
Example:
Records uploaded via AIW for the GL Daily Rates Loader are inserted into the standard Oracle GL Interface table: a concurrent request then processes the records and moves them to the base GL tables.
Therefore, the uploaded data can reside in two locations:
i. Unprocessed data will be in the interface table.
ii. Processed data will be in the base table.
For this Loader, the default Download Query downloads data from the interface table and the additional Download Query downloads previous rates from the base table. Below is the screenshot of the GL Daily Rates Loader zip file content.
