Error With NPD Project Search Results, Search fails to Return Results for Projects Without a Team Leader
(Doc ID 2484064.1)
Last updated on FEBRUARY 24, 2019
Applies to:Oracle Agile Product Lifecycle Management for Process - Version 220.127.116.11 to 18.104.22.168 [Release 6.2.0]
Information in this document applies to any platform.
using 6.2.2, in the NPD module, the search for NPD projects fails to return results for projects without a team leader when the team leader column is used in the search results display.
SQL Profiler shows that P4P is doing an inner join instead of a left join on team leader when there is none and it's not a required field.
Steps to reproduce:
- Navigate to NPD > New Product Development > Projects.
- Verify "Team Leader(s)" is set as a search result column.
- Search for any project not currently set/configured with a Team Leader.
- Notice that Project will fail to show up in search results
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