Functionality Security
During the login process the Custom Query downloader checks if the user has access to modify system profile values function (FND_FNDPOMPV).
If the user has access to the 'Profile System Values' function, the user will be able to use the 'Manage Queries' functionality described in this document. Alternatively, System Administrators can grant access to this functionality to other users by setting the appropriate Wizard Profile Option e.g. to enable a non-System Administrator access to this in General Ledge Wizard, set the ‘More4Apps: GLW Custom Query Manager’ (previously ‘More4Apps: GLW Downloader Manager) value to ‘Yes’. This profile allows customers to nominate a user to manage download queries. This is useful if the user lacks sysadmin access and cannot be granted sysadmin. The profile is set up at the user level.
The user’s ribbon will be similar to the image below if they are able to use the ‘Manage Queries’ functionality:
Note - If the user doesn't have access to the above functionality, check the appropriate Wizard profile option has not been set e.g. General Ledger Wizard ‘More4Apps: GLW Suppress Manage Queries functionality’.
If the user doesn’t have access to the ‘Profile System Values’ function, they will only be able to select and run queries already created and assigned to the responsibility they have chosen during login. Their ribbon will only contain a few buttons, similar to the image below:
Refer to section: