My Oracle Support Banner

R12: No Entries Found for List of Values on Journal Entry Screen (Doc ID 2179447.1)

Last updated on DECEMBER 16, 2020

Applies to:

Oracle General Ledger - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


We are getting the issue on security rule, if we have assigned the security
rule system is showing the error "No entries found for the list of value"


1. Set Security Rule and Hierarchical Security is in Use.

2. Open the following Journal entry screen but not be able to select the segment value.

    RESP: General Ledger
    (N)Journals -> Enter

3. When create Journal Lines and then enter the one of the AFF segments.

4. The following error occurred.

    No entrires found for List of Values

    No entries found for List of Values
    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)
    No entries found for List of Values


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

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