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 (Doc ID 1084141.1)

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

Symptoms

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.

Changes

We have modified the code so that the performance is improved while saving the PC_BUD_DETAIL page.

Cause

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