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 DECEMBER 24, 2020

Applies to:

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

Symptoms

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.

STEPS TO REPRODUCE

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.

   

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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