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:

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

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