My Oracle Support Banner

Period Close: How to Reduce the Volumne of Data Processed by Transfer Journal Entries to GL ( XLAGLTRN ) Program (Doc ID 1553386.1)

Last updated on FEBRUARY 14, 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 TEMP2.




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.