EGL9.1:Multicurrency Process (FSPCCURR) Fails After 4 Successful Requests (Doc ID 1286756.1)

Last updated on AUGUST 26, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.
Checked for relevance on 03-DEC-2012
Checked for relevance on 10-NOV-2014

Symptoms

After installing 9.1 bundles 6 & 7, When attempting to process FSPCCURR, it ran successfully for the first 4 times.
On the 5th and all subsequent requests the process fails on temp table number assignment on CURR_WRK_TBL, CURR_WRK_RT or CUR_WRK1_TBL.
The following error occurs.

ERROR
-----------------------

Process log shows below below:
"PSPSQLRT error in GL MultiCurrency Processing".

COBOL trace shows below error:
INSERT INTO PS_TEMP_TBL_STATS ( TEMP_TBL_NAME , PROCESS_INSTANCE , DATE_ASSIGNED) VALUES ( :1 , :2 , TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD'), 'YYYY-MM-DD'))
Bind-1, type=SQLPBUF, length=12, value=CUR_WRK1_TBL
Bind-2, type=SQLPSPD, precision=11, scale=0, value=2238800
RC=0 EXE
RC=0 Rollback

 

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