My Oracle Support Banner

E1: GRID: Advanced Query Created With Blank Version Application Visible Across All Application Versions (Doc ID 2984814.1)

Last updated on NOVEMBER 02, 2023

Applies to:

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

Symptoms

With Tools Release 9.2.4.5, after creating Advanced Query for a blank version (i.e. P07136 is having no default versions), the Advanced Query is visible for all newly created versions.
Whereas, after upgrading to Tools Release 9.2.7.3, newly created Advanced Query is NOT visible across all versions.

NOTE:  Advanced Query is version specific. Advanced Query created for one version should NOT be available for all other versions.


The difference between two scenarios can be seen by the following steps.
1. Login into instance with Tools Release 9.2.4.5
2. Open application P07136 (One View Tax History Inquiry)
3. Create an Advanced Query (i.e. named ‘Test_Query_9246’) and share it from application P98220U (Work with User Defined Objects)

 

4. ‘Version’ column within P98220U application will be blank as application P07136 is having no version by default

 

5. Re-login, open application P07136 and check ‘Query’ drop-down records. Newly created Advanced Query will be visible under Shared section.

 

6. Even after creating a new version for P07136, the same Advanced Query will be visible for version specific P07136
7. Now login into instance with Tools Release 9.2.7.3
8. Open application P07136 (One View Tax History Inquiry)
9. Create an Advanced Query (i.e. named ‘Test_Query_9273’) and share it from application P98220U (Work with User Defined Objects)

 

10. ‘Version’ column within P98220U application will be blank as application P07136 is having no version by default

 

11. Re-login, open application P07136 and check ‘Query’ drop-down records. Newly created Advanced Query will NOT be visible under Shared section. Also it will NOT be visible for any other newly created versions.

 

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.