My Oracle Support Banner

E1: GRID: UDO Shared Query No longer Default After "Save As" Personal Query Is Set As Default (Doc ID 2738802.1)

Last updated on APRIL 11, 2022

Applies to:

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


Shared Query is set as Default.
In Query Manager the Shared Query is "Save As" to create a Personal Query.
After the Personal Query is set as Default and saved, the Shared Query is no longer a Default Shared Query.


1. P0014 Add Query P0014QY01. PayTerms=CTD. Check [Set As Default].


2. P98220U Approve/Share P0014QY01. Note UDOName QRY0014B_2012210001CUST.

3. Log out and back into E1.  P0014 Default Shared Query is P0014QY01.


4. Databrowser F952460 Default UDO Detail.  Find ObjectName P0014.
    UDOName QRY0014B_2012210001CUST    * PUBLIC    DefaultUDOFlag=1.


5. P0014 Open Query Manager. "Save As" P0014QY02.
    Click Name_dropdown. Note Shared P0014QY01 is Default.


6. Check [Set As Default], Save.  Click Name_dropdown. Shared P0014QY01 is no longer Default (no * besides QueryName).


7. P98220U. Personal P0014QY02 UDO Name is QRY0014B_2012210002CUST.


8. Databrowser F952460 Default UDO Detail.
    Find ObjectName P0014.
    Default Shared QRY0014B_2012210001CUST is incorrectly updated to Personal QRY0014B_2012210002CUST.
    Expected new entry for Personal QRY0014B_2012210002CUST.





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.