Incorrect Result When Searching by Lock User Is Not Null
(Doc ID 2436348.1)
Last updated on MAY 13, 2020
Applies to:Oracle Agile PLM Framework - Version 18.104.22.168 and later
Oracle Agile Product Portfolio Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
Query with General Information.Lock User Is Not Null returns unexpected result.
It will return both projects those are locked and not locked.
Query with General Information.Lock User Is Not Null to return only locked project
The issue can be reproduced at will with the following steps:
- Login to Web Client, and create several projects, PROJ001, PROJ002, PROJ003
- Open PROJ002, and open Gantt Chart in Full Lock mode, and keep it opened
- Login to Web Client as user1, and configure Advanced Search for Project with below criteria:
General Information.Lock User Is Not Null
- Click Format, and add General Information.Lock User attribute
- Run Advanced Search
Result: It returns unlocked project as well (General Information.Lock User attribute is null for some projects)
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