One of the most powerful features of Application Interface Wizard is the ability to extract/download information from Oracle and use it as the basis for new information.
There are three methods provided to download existing information into your worksheet from Oracle:
•Method 1 - Use theDownload using Sheet Data option and enter multiple criteria into your worksheet to download based on the data entered.
•Method 2 – Use aDownload Formwhich provides multiple criteria for you to target the required customer lists.
•Method 3 – Use theCustom Query Tab. This feature allows users to run pre-defined queries created by their Administrators where they are assigned to the same Oracle Responsibility being used in the Wizard/Loader.
Each method will return data depending on the criteria entered. This provides the ability to download existing information into the worksheet. Information can then be modified to create or update existing records.
A download is a fast and effective way to illustrate what data goes in what column. Consequently, it is a good idea to use an existing record as a template for new data.
