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

Last updated on DECEMBER 16, 2020

Applies to:

Goal

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"

STEPS

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

Solution

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