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.
This powerful download option enables the simple mapping of Oracle E-Business Suite data directly into the appropriate Wizard columns, making subsequent uploading a breeze.
The pre-defined queries can include run-time filters, or you can add you own additional filters before downloading the data.
There are three main user buttons available on the Custom Query ribbon:
a)Download Form- Where additional filters can be added using a form.
b)Download from Sheet- Where sheet criteria is used for additional download filters.
c)Print Column Headers- Where the column headers are printed to the worksheet.
Note- The other two buttons in the 'Manage Queries' section on the ribbon are only available to users with System Administrator access:
This functionality can be suppressed by setting the profile option ‘More4Apps: SW Suppress Custom Query Functionality’ to ‘Yes’ at the user, responsibility or site level.
When this profile option is set (at the appropriate level) selection of any custom query icon will produce a message of ‘The custom query functionality has been disabled by your System Administrator. Please contact your System Administrator’.
