E1: GRID : Enhancement Request on How to Modify a Published Advance Query?

(Doc ID 2363942.1)

Last updated on FEBRUARY 21, 2018

Applies to:

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

Goal

On : 9.2 version,
Tools Release 9.2

Client has restricted access to create, modify and publish access for UDO Adv. Queries their PD environments. When published/shared advance queries are in PD, users want to change some of the filter criteria based of different needs.
For example, date ranges, as they will be running the same queries but on different dates.

Currently, when you try to give only modify access through UDO action security, it enables create/publish options as well. Therefore looking for solution, how can a user be able to change the parameters within already published queries?

Business Case: They want a solution were user should be able to adjust the filter ranges
(Like date between 1 Jan - 10 Jan) etc which is not possible in QBE filters.

 

Solution

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