My Oracle Support Banner

E1: SEC: Application Query Security To Prevent "Open Find" Queries In EnterpriseOne Applications And Data Browser. (Doc ID 1232653.1)

Last updated on JULY 06, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Check for relevance Jul-06-2020


This document describes the Application Query Security functionality to prevent "open find" queries in EnterpriseOne applications and Data Browser.

The functionality is available only on Web client starting with Tools Release in Application Release 8.11SP1 and above
Following ESUs are required based on Application Release level :


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 canceled
The error or warning generic message can be customized specific to the form within the application

The 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:


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!

In this Document
 Launch Application Query Security from Security Workbench
 Set up Application Query Security for Applications
 Application, Form, Subform Name
 Field Entry Requirements
 Message Type
 Menu Tools Option - Configure Fields
 Set up Application Query Security for DataBrowser
 Field Entry Requirements
 Menu Tools Option - Configure Fields
 Exclude Users from Application Query Security
 Work with Application Query Security
 Applications Secured View
 Excluded Users view
 Configure Error or Warning Message for a specific form within an application
 POFERR - Prevent Open Find Error
 POFWAR - Prevent Open Find Warning
 Steps to Configure the Message in P92001 Work with Data Dictionary Items
 Application Query Security Configuration Stored by Path Code in F98950
 OMW Project Promotion of Application Query Security Records
 Identify Application Query Security Configuration and Excluded Users records

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.