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 SEPTEMBER 14, 2016

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.
****Checked for Currency on Apr-4-2013****

Symptoms


Environment
==============
FSCM 9.1


Issue
=================
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.

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