The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Updating Budget with actuals

Highlighted
pdhawan
Super Collector

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
Honored 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
Super Collector

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
Honored 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?
//Add this to "OnDomLoad" event