PC: PC_SUM_RFSH Performance (Doc ID 1075401.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 8.8 SP1 to 8.8 SP1 [Release 8.8]
Information in this document applies to any platform.

Symptoms

On : 8.8 SP1 version, Budget Integration

When running the process PC SUM Refresh, it shows warning errors in the process message log. It processes for a long time (over 6 hours). Process message log shows the following error occurs.

ERROR
-----------------------
-- 7:37:34AM WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR PC_SUM_U_TAO1

-- 8:12:48AM WARNING: UNABLE TO PERFORM COMMIT - FORCING USE OF BASE TABLE FOR PC_BUD_RS_TA1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Project Costing > Utilities > Refresh Summary Tables >
a.Add a new Run Control ID
2.Program Name: PC_SUM_RFSH
3.Process Frequency: Always
4.Click on Run
5.Once completed running, check the message log


BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this performance issue, users have to wait for a long time to move onto next steps.

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