Ledger LOV Does Not Show In "Program - Import Journals" APP-FND-01436 (Doc ID 1280104.1)

Last updated on DECEMBER 29, 2016

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
Program - Journal Import


Symptoms

When attempting to to run Program - Import Journals (GLLEZLSRS) >Select specific source > The following error occurs on the Ledger LOV - List of Values:

Sometimes it works without any error for others sources.

ERROR
-----------------------
No Entries found for List Of Value.

APP-FND-01436: List of Values cannot find any values for you to choose

Cause: The List of Values execution failed to find any values.

Cause: The SQL statement specified to fdlfch() failed to return any values.

Action: Check the message stack for any SQL statement failure messages. Check to make sure your
SQL statement works in SQL*Plus. (ROUTINE=fdlfch)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. View > Requests  > Submit new request (FNDRSRUN)
2. Program - Journal Import(GLLEZLSRS)
3. Select specific source
4. See the error thrown afterwards

Changes

None

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