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 SEPTEMBER 15, 2022

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

On : 12.1.3 version or above 
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 

ERROR
-----------------------
ORA-00979: not a GROUP BY expression in Package PJI_FM_PLAN_MAINT_T_PVT Procedure CREATE_WBSRLP
ORA-00979: not a GROUP BY expression in Package PJI_FM_PLAN_MAINT Procedure PRI_SLICE_CREATE_T
ORA-00979: not a GROUP BY expression in Package PJI_FM_PLAN_MAINT Procedure UPDATE_PRIMARY_PVT
ORA-00979: not a GROUP BY expression in Package PJI_FM_XBS_ACCUM_MAINT Procedure PLAN_UPDATE_PVT
ORA-00979: not a GROUP BY expression in Package PJI_FM_XBS_ACCUM_MAINT Procedure PLAN_UPDATE
ORA-00979: not a GROUP BY expression in Package PA_FP_PJI_INTG_PKG Procedure update_reporting_lines

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go into the Project 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.
6. Migrate the solution as appropriate to other environments.



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.