My Oracle Support Banner

Program GLLEZL: Journal Import failing with errors - ORA-01000, ORA-06512, Program exited with status 1 (Doc ID 2774427.1)

Last updated on JUNE 15, 2021

Applies to:

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

Symptoms

When attempting to run the Program: Journal Import (GLLEZL) ,following errors occurs in the log file

Errors
======
Error in: glutbe
Function return status: 0
Function Err Message: call to glutbe failed
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01000: maximum open cursors exceeded
ORA-06512: at "APPS.WF_EVENT"
ORACLE error 1000 in AFPRSR-Resubmit_Time
Cause: AFPRSR-Resubmit_Time failed due to ORA-01000: maximum open cursors exceeded
The SQL statement being executed at the time of the error was: begin fnd_file.close; end;
Program exited with status 1

Steps to reproduce the issue
1. Log into subledger responsibility
2. Navigate to submit new request
3. Run the program create accounting with Final option
4. Journal import triggered by create accounting fails with error

 



 

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.