My Oracle Support Banner

Abend at CA_LIMITS.TempTbls.LMT1CRD When Running Multiple Processes. (Doc ID 750932.1)

Last updated on MARCH 21, 2019

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 8.9 to 9 [Release 8.9 to 9]
All Platforms
***Checked for relevance on 16-Sep-2010***
***Checked for relevance on 19-Sep-2012***

Symptoms

Listing of PC_AP_TO_PC Error Messages and Troubleshooting Tips to Resolve each Error > Note 750932.1

When attempting to run PC_PRICING and PC_AP_TO_PC at the same time, the CA_LIMIT application engine abends with following error occurs:

ERROR
-----------------------
CA_LIMITS abends ABENDED at Step CA_LIMITS.TempTbls.LMT1CRD (SQL) -- RC = 805 (108,524)

STEPS
-----------------------
By following these steps the issue can be reproduced. But this can be reproducible only under certain circumstances which could result either because of timing or abended processes.
1. Have a contract associated with a activity with limit amount
2. Run integration processes that calls CA_LIMITS.
3. Timings should be such that one process leaves data in PS_PROJ_RES_TMP while the other process access the data in PS_PROJ_RES_TMP for processing

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
 Listing of PC_AP_TO_PC Error Messages and Troubleshooting Tips to Resolve each Error > Note 750932.1
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.