EGL8.9: GLPCLOSE Cobol Program Error on Stored Stmt GLPCPROC_S_BUOPTN (Doc ID 657584.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201052539
****Checked for Relevance on 01-13-2014****
****Checked for Relevance on 07-27-2015****

Symptoms

GLPCLOSE Cobol Program Error on Stored Stmt GLPCPROC_S_BUOPTN
PTPSQLRT - ERROR IN SELECT SETUP/DATA
STATEMENT=GLPCPROC_S_BUOPTN
VARIABLE#=008
DATA TYPE=001
DATA LEN =0010
SCALE    =000
 
Application Program Failed
 Action Type     : SQL SELECT
 In Pgm Section  : SQLRT: PROCESS-SETUP(SELECT)                         
 With Return Code: 08095
 Error Message   : A SELECT item number is outside valid range for query
 Stored Stmt     : GLPCPROC_S_BUOPTN
 SQL Statement   : SELECT B.CALENDAR_ID ,B.ADB_REPORTING ,B.SEPARATE_DRCR ,B.JR
                    NL_FOREIGN_OPTN ,B.ALTACCT_OPTN ,B.ACCT_ALT_SUSPENSE ,B.ALT_
                    ACCT_SUSPENSE FROM PS_BU_LED_GRP_TBL B WHERE B.BUSINESS_UNIT
                    =:1 AND B.LEDGER_GROUP=:2

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