How to Avoid the Error ORA-01654: Unable To Extend Index in General Ledger (Doc ID 743950.1)

Last updated on SEPTEMBER 10, 2014

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:GLBOYR - Open Budget Year
Executable:GLPPOS - Posting

Goal

Occasionally General Ledger programs will error with the ORA-01654 error. This document explains how to avoid this error.

Examples of the Error
-------------------
<x glpipi() 16-OCT-2008 11:33:13
Error in ROUTINE: glpipi, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: -1654 sqlerrml: 70
sqlerrmc:
ORA-01654: unable to extend index GL.GL_POSTING_INTERIM_32239_N1 by 26
sqlerrp: sqlerrd: 0 0 0 0 19 0
sqlwarn: W W sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...



SHRD0075: Error in glbinp: errexit().
<x glbinp() 11-AUG-2014 08:49:05
*****************************************************
sqlcaid:   sqlabc: 0  sqlcode: -1654  sqlerrml: 70
sqlerrmc:
ORA-01654: unable to extend index GL.GL_BALANCES_N2 by 8192 in tablesp
sqlerrp:   sqlerrd: 0 56254 0 0 0 538976288
sqlwarn:           sqltext:  
*****************************************************

Solution

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