EGL: Multicurrency program FSPCCURR Returns PSPSQLRT error: FSPCCURR-BB000 SELECT.- Invalid SELECT item number On Stored Stmt : FSPCCURR_S_INSTALL.
(Doc ID 1284068.1)
Last updated on JANUARY 04, 2024
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 8.4 to 9.1 [Release 8.4 to 9]Information in this document applies to any platform.
Symptoms
Error occurred while running the FSPCCURR process
Error:
------
PTPSQLRT - ERROR IN SELECT SETUP/DATA
STATEMENT=FSPCCURR_S_INSTALL
VARIABLE#=00006
DATA TYPE=00001
DATA LEN =00003
SCALE =00000
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: PROCESS-SETUP(SELECT)
With Return Code: 08003
Error Message : Invalid SELECT item number
Stored Stmt : FSPCCURR_S_INSTALL
SQL Statement : SELECT AM ,AP ,AR ,GL ,ALTACCT_OPTN FROM PS_INSTALLATION
at pos 00024
at pos 00024
SEVERE ERROR IN PGM:(5870,5) PI() Program(FSPCCURR)
PSPSQLRT error in GL MultiCurrency Processing: FSPCCURR-BB000 SELECT.
STATEMENT=FSPCCURR_S_INSTALL
VARIABLE#=00006
DATA TYPE=00001
DATA LEN =00003
SCALE =00000
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: PROCESS-SETUP(SELECT)
With Return Code: 08003
Error Message : Invalid SELECT item number
Stored Stmt : FSPCCURR_S_INSTALL
SQL Statement : SELECT AM ,AP ,AR ,GL ,ALTACCT_OPTN FROM PS_INSTALLATION
at pos 00024
at pos 00024
SEVERE ERROR IN PGM:(5870,5) PI() Program(FSPCCURR)
PSPSQLRT error in GL MultiCurrency Processing: FSPCCURR-BB000 SELECT.
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 |