My Oracle Support Banner

E1: SEC: Application Query Security with the "Configured Fields" Option Not Considered When Changing Grid Format in Application P42101 (Doc ID 2988407.1)

Last updated on MARCH 25, 2024

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


When configuring Application Query Security with the "Configured Fields" option in Application P42101 to prevent "Open Find" queries, the system correctly throws an "OPEN FIND ERROR" when clicking the "Find" button. However, when changing the Grid Format in the same application, the find operation is automatically executed, bypassing Application Query Security.


The expected behavior is similar to the "Open Find" scenario, when changing the Grid Format in Application P42101, the system should trigger the App Query Security mechanism. It should throw the "Open Find" error, ensuring that the find operation is subject to the configured security settings.

Steps to Reproduce:

  1. Configure App Query Security with Configured Fields option using P00950 for the standard Application P42101
  2. Open, P42101 from fastpath
  3. Click on Open Find, (The expected result is- Throw an Error without displaying any Data)  It throws the "Open Find "Error as expected
  4. Enter a filter value for a specific field that is configured under "Configured Fields" in step 1 and press find. Data fetched as expected
  5. Remove the filter value entered in step 4 and switch to another grid format
  6. When the grid format is changed to another grid format the find is executed without checking the app query security and displays data.


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

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