GLXJIRUN Journal Import Gives LEZL0021: Journal Import can process at most 20 source/group id combinations at once ORA-1403 no data found in GLLCNT (Doc ID 104305.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:GLLEZL - Journal Import
Form:GLXJIRUN.FMB - Import Journals

Symptoms

You are running Journal Import in Oracle General Ledger as follows:

Responsibility = General Ledger Super User
GUI Navigation = Journal/Import/Run
GUI Form Name  = GLXJIRUN (Journal Import)

     1.  Enter a Source and Group ID. You are trying to import more than 20 Source/Group ID's at one time.

     2.  Select Run Options and Import Descriptive Flexfields Option.

     3.  Enter a Date Range.

     4.  Click on the [Import] button.

This spawns a concurrent request.  You view your request (Navigation:  Help/View My Request).  You see the process completed with a status of "Error."

You click on the [Request Log] button to review the log.  
You see the following errors in the log file:

   LEZL0021: Journal Import can process at most 20 source/group id combinations at once.
   LEZL0022: Please reduce the number of source/group id combinations processed in one Journal Import run.
   <x gllcnt() 26-JUL-1999 15:15:01
   Error in: gllcnt
   Function return status: 0
   Function Err Message: more than 20 sources
   Function warning number: -1
   *****************************************************
   sqlcaid:   sqlabc: 0  sqlcode:  0  sqlerrml: 0
   sqlerrmc:
   ORA-1403: no data found
   sqlerrp:        sqlerrd: 0 24 0 0 0 538976288
   sqlwarn:           sqltext:
   *****************************************************
   SHRD0044: Process logging off database and exiting ...

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