My Oracle Support Banner

PC_SUM_RFSH Process is Not Refreshing CA_PR_SUMM Table. (Doc ID 2270377.1)

Last updated on MARCH 29, 2021

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.