PeopleSoft Enterprise Project Costing: page PC_BUD_DETAIL timing out when Budget Plan has more than 200 activities and budget items using "Spread Even" option
Last updated on SEPTEMBER 15, 2016
Applies to:PeopleSoft Enterprise FIN Project Costing - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
Checked for relevance on 05-Sep-2013
Create a project with 100 activities. Create a budget plan and add a budget item to the first activity. Enter a budget adjustment amount and use the option "Spread Even". Click on OK and click on "Spread Even". Save the page.
Then repeat the above steps for 9 activities. So you will have 10 activities with each one budget item associated to it. Save the page. The page takes around 45 seconds to save. Add a budget item to activity 11, and save the page. The page now takes around 50 seconds to save.
In the trace, notice that the system is calling the method "HGRID:HGrid_Row.GetChildren" and internal call "BudgetItemAmountUpdate" and "AmountLabel". The system is doing this for every budget item having spread amounts. So the more budget items you have added to the Budget Detail Page, the longer it will take to save the page.
When you have a Budget Plan with more than 200 activities and all of these activities have Budget Items added with spread amounts, then while saving the page will time out after 300 seconds.
We have modified the code so that the performance is improved while saving the PC_BUD_DETAIL page.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms