GLLEZLSRS Program Import Journals Cannot Use All Group ID Option (Doc ID 316515.1)

Last updated on JANUARY 09, 2015

Applies to:

Oracle General Ledger - Version: 11.5.10.1 to 12.1.3 - Release: 11.5.10 to 12.1
Information in this document applies to any platform.
Executable:GLLEZLSRS - Executable to allow submission of Journal Import through the Standard Request Submission

Symptoms

When submitting  'Program- Import Journals' (GLLEZLSRS) there is no parameter available to select All Groups IDs.  The only available options are to enter a specific Group ID number or leave it null.  Leaving it null will cause Journal Import to only select data from the GL_INTERFACE table with a null Group ID.

This creates a problem when trying to use this program to schedule imports from Oracle subledgers as they usually populate the Group ID field in the GL_INTERFACE table.  If the Group ID parameter is left blank and the program is submitted to import from a subledger the following warning may be seen:

If no GROUP_ID is specified, then only data with no GROUP_ID will be retrieved.   Note that most data from the Oracle sub-ledgers has a GROUP_ID, and will not be retrieved if no GROUP_ID is specified.

Changes

The GLLEZLSRS program is new to 11.5.10.

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