PC_SUM_RFSH Process is Not Refreshing CA_PR_SUMM Table.

(Doc ID 2270377.1)

Last updated on JUNE 20, 2017

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On :  9.2 version, Limit Processing

ACTUAL BEHAVIOR  
---------------
We have OLT rows in CA_PR_SUMM and not in PROJ_RESOURCE. Running Full PC_SUM_RFSH is not correcting the summary table inline with PROJ_RESOURCE.

EXPECTED BEHAVIOR
-----------------------
Running Full PC_SUM_RFSH should correct the CA_PR_SUMM and PC_SUMMARY_TBL to be in sync with PROJ_RESOURCE

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  During upgrade from 9.1 to 9.2, there are some orphan rows in  CA_PR_SUMM with respect to OLT rows
2.  Running PC_SUM_RFSH  is not refreshing the CA_PR_SUMM and deleting these orphan rows.

a. Make sure the PROJ_RES_TMP is blank assuming all processes cleaned up this table after they are successfully completed.

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