Project and Portfolio Management Practitioners Forum
cancel

Updating Budget with actuals

Highlighted
pdhawan
Trusted Contributor.

Updating Budget with actuals

Hi,

I know we shouldn't be doing this by database updates, but there is a requirement to update the PPM 7.1 budgets with actuals.

When we update the budget tables, it is shown correctly everywhere except the Project overview page. This doesn't get reflected automatically even after a few hours but is triggered once we open the budget> click Modify Budget> and just Save it.

The Overview page is immediately reflected.

If someone has any idea if we could trigger this particular functionality(of save) ourselves, please advice .


Many thanks in advances
3 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Updating Budget with actuals

Are you updating the LAST_UPDATE_DATE in the tables you're hitting? Usually this is necessary to make PPM show the new data instead of cached data.
pdhawan
Trusted Contributor.

Re: Updating Budget with actuals

Yes, I am. I also updated the fields in almost all of the linked tables I could think off. Even the request tables from where the budget was created...
:(
Erik Cole
Acclaimed Contributor.

Re: Updating Budget with actuals

If you make your updates and flush the Budget cache via Cache Manager (option 14 I think) do they show up then?