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 JULY 17, 2017

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.


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