My Oracle Support Banner

Alternate Search Error: Java.sql.SQLSyntaxErrorException: ORA-00904: "STATUS_TYPES"."PER_SYSTEM_STATUS": Invalid Identifier (Doc ID 2238041.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Project Planning and Control - Version 12.2.4 and later
Information in this document applies to any platform.
ORA-00904, ALTERNATE SEARCH

Symptoms

When user tries to search for a project, through Alternate Search option, using as search criteria "Project Manager" the following error is displayed:

ERROR
-----------------------
java.sql.SQLSyntaxErrorException: ORA-00904: "STATUS_TYPES"."PER_SYSTEM_STATUS": invalid identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Project Super User responsibility
2. Navigation -> Project Delivery ->Project Search
3. Click on Alternative search
4. Available criteria: Project Manager
5. Click on LOV (list of values) field "Value"
6, Click GO
Error occurs

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.