My Oracle Support Banner

After Upgrading RDBMS to 19C, Select Query Failed With ORA-00979 When Creating the Project or Creating the Budget (Doc ID 2873374.1)

Last updated on MARCH 14, 2023

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Oracle Project Foundation - Version 12.1.3 and later
Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to create the project through Application or API
                               or
When attempting to create the Budget through Application or API

Getting the below error 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go into the Projects responsibility
2. Navigate to Project or Budget
3. Create the Project or Budget
4. The issue can be reproduced by creating the Project or Budget through API
5. Retest the issue.




Changes

 

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
Changes
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.