ORA-00904: "DISCUSSION"."ID" Invalid Column Name When Running Advance Search to Query Tasks by the Field Name NotifyList of Discussion (Doc ID 2263748.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Agile Product Portfolio Management - Version 9.3.4.0 and later
Oracle Agile PLM Framework - Version 9.3.4.0 and later
Information in this document applies to any platform.

Symptoms

When running advance search to query tasks by the field name NotifyList of Discussion, below error occurs

Error

'ORA-00904: "DISCUSSION"."ID" invalid column name'


Steps

The issue can be reproduced at will with the following steps:

  1. Login to Web Client, and run Advanced search with below criteria:
    Projects | Task | Object Search
    Notify List | Contains Any | $USER
  2. Gets error ORA-00904




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms