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 MAY 08, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.