Performance Issue With PC_BI_TO_PC Process At Steps PC_BI_TO_PC.COUNT.LAST_RES AND PC_BI_TO_PC.UPDATE.PAYROWS (Doc ID 2083764.1)

Last updated on DECEMBER 07, 2015

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.0 version, Project Budgeting

ACTUAL BEHAVIOR
---------------
PC_BI_TO_PC process is taking long time to finish. Performance issues were identified at steps PC_BI_TO_PC.COUNT.LAST_RES AND PC_BI_TO_PC.UPDATE.PAYROWS

EXPECTED BEHAVIOR
-----------------------
PC_BI_TO_PC process should complete in reasonable time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PC_BI_TO_PC process

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