"No entries found for List of Values" Error in SOE Information form

(Doc ID 2353972.1)

Last updated on JANUARY 27, 2018

Applies to:

Oracle Payroll - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

When attempting to open "Elements 1" LOV in SOE Information form, following error occurs.

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

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Login with HRMS Responsibility.
  2.  Go to SOE Information form.
      (N) Work Structures > Organization > Description > Search for organization > Select Business Group Information and click Others button
       > select SOE Information
  3.  Open "Elements 1" LOV.
  4.  Error occurs.

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