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 11.5.10.2 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
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

In this Document

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com . � Oracle | Contact and Chat | Support | Communities | Connect with us |

| Legal Notices | Terms of Use