My Oracle Support Banner

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 to [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:

  1. Navigate to NPD > New Product Development > Projects.
  2. Verify "Team Leader(s)" is set as a search result column.
  3. Search for any project not currently set/configured with a Team Leader.
  4. 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

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