My Oracle Support Banner

Performance Problem With PC_PRICING/CA_LIMITS Process At PC_MULTI_CUR.Signoff.DelTmp - %TruncateTable Is Not Translating To TRUNCATE Statement In PC_MULTI_CUR.Signoff.DelTmp (Doc ID 2286704.1)

Last updated on AUGUST 02, 2020

Applies to:

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

Symptoms

On : 9.2 version, Limit Processing

ACTUAL BEHAVIOR
---------------
No multicurrency environment. Performance of PC_PRICING/CA_LIMITS because of not getting the truncate statement executed at below step.

PC_MULTI_CUR.Signoff.DelTmp

Below is the DELETE statement timings when PC_MULTI_CUR called from CA_LMITS.

-- 55 min for DELETE

DELETE FROM PS_CA_LMTMP_TAO11
WHERE
PROCESS_INSTANCE >= 0


EXPECTED BEHAVIOR
-----------------------
Performance of PC_PRICING/CA_LIMITS can be improved if the truncate statement gets executed as intended at PC_MULTI_CUR.Signoff.DelTmp

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


Changes

 

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
Changes
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.