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 JUNE 22, 2016

Applies to:

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

Symptoms

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
or
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms