My Oracle Support Banner

Updating Budget or Project is Giving Error ORA-00979: Not A GROUP BY Expression In Package PJI_FM_PLAN_MAINT_T_P (Doc ID 2774657.1)

Last updated on SEPTEMBER 25, 2021

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to create draft budget using pa_budget_pub.create_draft_budget API or  from editing update from application getting error:
Note: Issue can occur during project creation or modification too.



STEPS
-----------
 From Project Super User Responsibility
 Navigate to Projects: Delivery> Search Projects
 Search project and click on project number to open project
 Navigate to Financial tab.
 Select Maintain Budget versions icon
 Edit Budget. And try to add budget lines or update budget.
 Click Save Button. Then click Submit button.


Changes

 Upgraded to Database Version: 19.0.X

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.