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 and later
Information in this document applies to any platform.


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

Getting the below error 

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.




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

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