Respected Contributor.. burakkaya28 Respected Contributor..
Respected Contributor..
377 views

Deleting Approve Budget Details from a Project

Jump to solution

Hi everybody,

Is there any way to delete Approve Budget Details?
This is the production environment of PPM 9.22

Best Regards,

0 Likes
1 Solution

Accepted Solutions
Respected Contributor.. burakkaya28 Respected Contributor..
Respected Contributor..

Re: Deleting Approve Budget Details from a Project

Jump to solution

Hi everybody,

 

I found a solution to delete Approved Budget Details.

 

DELETE FROM FM_APPROVED_BUDGETS WHERE FINANCIAL_SUMMARY_ID = 
(SELECT PRJ_FINANCIAL_SUMMARY_ID FROM KCRT_FG_PFM_PROJECT WHERE REQUEST_ID = [YOUR_REQUEST_ID]);
COMMIT;

 

I fixed with the SQL Query above. But as I know, HP does not suggest this method.

 

For your informations,

Burak Kaya

0 Likes
3 Replies
Absent Member.. alex-h Absent Member..
Absent Member..

Re: Deleting Approve Budget Details from a Project

Jump to solution

There are no function to delete an approved budget

 

Tip : You can approve a negative value.

 

0 Likes
Respected Contributor.. burakkaya28 Respected Contributor..
Respected Contributor..

Re: Deleting Approve Budget Details from a Project

Jump to solution

Hi,

 

I have known already that there are no function to delete an approved budget. I thought that someone has a method to delete it.

 

This is an deficiency of tool.

 

Thanks your comment,

Burak Kaya

0 Likes
Respected Contributor.. burakkaya28 Respected Contributor..
Respected Contributor..

Re: Deleting Approve Budget Details from a Project

Jump to solution

Hi everybody,

 

I found a solution to delete Approved Budget Details.

 

DELETE FROM FM_APPROVED_BUDGETS WHERE FINANCIAL_SUMMARY_ID = 
(SELECT PRJ_FINANCIAL_SUMMARY_ID FROM KCRT_FG_PFM_PROJECT WHERE REQUEST_ID = [YOUR_REQUEST_ID]);
COMMIT;

 

I fixed with the SQL Query above. But as I know, HP does not suggest this method.

 

For your informations,

Burak Kaya

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.