E1: GRID: Databrowser Cannot Have More Than 100 Advanced Queries AND Personal Queries Disappearing While Number of Shared Queries Are Increasing
Last updated on MARCH 15, 2018
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
Symptom 1: Customer has been creating more and more shared queries for Databrowser recently, but as the number of shared queries increases, the number of personal queries available on the query selection screen has dropped. Looking through a trace of the HTML server, there seems to be a limit on the number of queries that will be presented on the query selection screen, and the limit is 100.
Found these lines in the HTML logs in DEBUG mode:
Requesting to allow more than 100 queries for Databrowser.
Symptom 2: User's personal queries are not visible in data browser. But the same query visible if user search "By Table"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms