Custom Query Tab
AR Invoice (API) Wizard has our latest flexible downloading option available in a separate 'Custom Query' ribbon.
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:
Information on how to use these options to Create, Maintain, and Assign Query Sets, can be found on the More4apps website Common User Instructions: Custom Query Add-In
This functionality can be suppressed by setting the profile option ‘More4Apps: RIW 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’.
Refer to section: