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 your 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 ribbon buttons in the 'Custom Query' ribbon section are only available to users with System Administrator access:
d)Manage Queries– Where queries can be built and modified. Note that security access and profile options may be required in order to use the functionality from this option. To set this up please refer to ourFunctionality Securitydocumentation.
e)Load From File– Used to import queries from other instances.
This functionality can be suppressed by setting the profile option ‘More4Apps: TW 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’.
