EGL: GLS1003 - Closing Trial Balance Fails With "Error (SQR 4038) Out Of Space While Processing Expression; Use -Mfile To Increase EXPRESSIONSPACE" (Doc ID 1526657.1)

Last updated on JUNE 30, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
------------------------
FIN/SCM 8.9, Reports
Tools 8.52.08
Oracle 11.2.0.2
AIX 6.1

When attempting to run GLS1003.sqr - Closing Trial Balance, the following error occurs.

ERROR
-----------------------
Error on line 434:
  (SQR 4038) Out of space while processing expression; Use -Mfile to increase EXPRESSIONSPACE.
 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run General Ledger, Close Ledgers, Closing Trial Balance

2. Request report with high volume of data

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