My Oracle Support Banner

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 SEPTEMBER 26, 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

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
Symptoms
Cause
Solution
References


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