Application Query Security prevents users from running "open find" queries when no search criteria has been entered in at least one of the form filter or QBE fields. When users attempt to perform such queries, a pop-up error or warning generic message is displayed alerting the users that the query search has been cancelled. The error or warning generic message can be customized specific to the form within the application.
Application Query security is designed to execute upon clicking Find. When applications have 'Automatically Find On Entry' selected in Grid Properties|Options, Application Query security is not applied on auto-find invoked upon entry into the form. Per Bug 32453927 OPEN FIND SECURITY NOT RESPECTED FOR AUTO FIND ON ENTRY FORMS it is functioning as designed.
Application Query security is set up at the form level by application. Applications include DataBrowser and any Find "enabled" application type (Find/Browse, Headerless Detail, Header/Detail). The security set up can be enabled or disabled for a specific form.
By default, Application Query security applies to ALL users (*PUBLIC). For users with a business need to run "open find" queries, there is an option to exclude these users by application from Application Query security.
Following are the topics discussed in document:
Launch Application Query Security from Security Workbench
Set up Application Query Security for Applications
Set up Application Query Security for DataBrowser
Exclude Users from Application Query Security
Work with Application Query Security
Configure Error or Warning Message for a specific form within an application
Application Query Security Configuration Stored by Path Code in F98950
OMW Project Promotion of Application Query Security Records
This document is intended for the EnterpriseOne system administrator to set up Application Query Security for selected EnterpriseOne applications and Data Browser in order to prevent users from initiating a query for data without specifying a search criteria.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!