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 OCTOBER 12, 2023
Applies to:
Oracle Project Planning and Control - Version 12.1.3 and laterInformation 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 |