My Oracle Support Banner

When Attempting To Run Search Or Report including User.Preferences Include Inactive List Value Receive Error ORA-00904: "AGILEUSER_P2"."INCLUDEINACTIVEVL": Invalid Identifier (Doc ID 1936226.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Agile Product Collaboration - Version 9.3.1.2 and later
Information in this document applies to any platform.

Symptoms

When Attempting To Run Search Or Report including User.Preferences Include Inactive List Value Receive Error ORA-00904: "AGILEUSER_P2"."INCLUDEINACTIVEVL": Invalid Identifier


The issue can be reproduced at will with the following steps:
1. Run advanced search for users | user .id prompt , Format: include User.Preferences: Include Inactive List Value
2. Search fails with error 904
3. Same error when running report including this field
  
The issue has the following business impact:
Due to this issue, users cannot run report/searches on User Preferences tab, field Include Inactive List Value

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.