My Oracle Support Banner

Period Close: "Oracle error detected in glpipi" in Transfer Journal Entries to GL ( XLAGLTRN ) Program Due to Data Volume (Doc ID 1553386.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


You run Subledger Period Close Exception Report and it shows numerous items with status: Final.

In order to remove these items from the Subledger Period Close Exception Report and transfer them to GL, you will have to run the Transfer Journal Entries to GL ( XLAGLTRN ) program. 
However, it causes one of two problems:

1. Transfer Journal Entries to GL program - fails due to space error
2. Spawned Child Program: Posting: Single Ledger (GLPPOSS) - fails with space error

Here is an example of a space error with the Posting program:

The Request “Posting: Single Ledger” is running in error with the following message:
“PERF0005: Oracle error detected in glpipi() - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP3”

The same thing applies for other tablespace names.


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.