My Oracle Support Banner

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

Last updated on AUGUST 29, 2022

Applies to:

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


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
sqlcaid: sqlabc: 0 sqlcode: -1654 sqlerrml: 70
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
ORA-01654: unable to extend index GL.GL_BALANCES_N2 by 8192 in tablesp
sqlerrp:   sqlerrd: 0 56254 0 0 0 538976288
sqlwarn:           sqltext:  


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.