Abend at CA_LIMITS.TempTbls.LMT1CRD When Running Multiple Processes.

(Doc ID 750932.1)

Last updated on SEPTEMBER 16, 2014

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

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