My Oracle Support Banner

Using Count Button in Query Mode on Classification List and Switching Between Views May Cause Wrong Results in Message Panel (Doc ID 2048861.1)

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Agile Engineering Data Management - Version and later
Information in this document applies to any platform.


On Oracle Agile e6.1.2.2
Find that the count button in query mode (calling userexit xatt_cnt_lis) in conjunction with different views returns incorrect number of results in the message window.

Expected Behavior:
The message window should display the exact number of records that are visible in the classification list mask depending on the view filters applied to it.

The issue can be reproduced at will with the following steps:
1. create a class e.g. Class Code & Name: CLASS1, Entity: EDB-ARTICLE, for all other fields the default entries can be taken.
2. create 2 items, ITEM1 and ITEM2
3. create a revision of ITEM1 with the following steps:
  a. change the status of ITEM1 to (120 -> 230 ->) 240 - In Change
  b. in the context menu choose Revisioning->Create New Revision-> Without Structure (give revision number 1)
  c. take Item1 (revision 1) in status Released (230)
4. Add ITEM1 and ITEM2 to the classification list tab of Class CLASS1
5. Check View Mode = Global
Enter Query mode (magnifying glass icon) and click on the count button (the 2nd button from left) - results as expected e.g.:
[12:00 PM] Number of records found = 2 !
6. Change to 'Released' View
And 'Refresh' the classification list =
Now only ITEM1 is visible (Quantity 1/1 on list)
Enter Query mode (magnifying glass icon) and click on the count button (the 2nd button from left) - results are not as expected / incorrect,
[12:00 PM] Number of records found = 2 ! but only 1 records is visible/displayed in the classification list.
Expected results= [12:00 PM] Number of records found = 1 !


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.