Period Close: How to Reduce the Volumne of Data Processed by Transfer Journal Entries to GL ( XLAGLTRN ) Program
Last updated on JUNE 22, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms