Solved: Re: Deleting Approve Budget Details from a Project - Micro Focus Community

burakkaya28 · ‎2015-09-15

Hi everybody,

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

Best Regards,

burakkaya28 · ‎2015-09-16

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

View solution in original post

alex-h · ‎2015-09-15

There are no function to delete an approved budget

Tip : You can approve a negative value.

burakkaya28 · ‎2015-09-16

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

burakkaya28 · ‎2015-09-16

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

View solution in original post