My Oracle Support Banner

Format LOV Does not Return Any Value When Attempting to Submit State Periodic Wage Listings (SPWL) (Doc ID 2514207.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle HRMS (US) - Version 12.2 and later
Information in this document applies to any platform.


Problem Statement:

When attempting to submit the "State Periodic Wage Listing (Enhanced) and open the LOV of Format parameter, 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.
No entries found for List of Values



Steps to Reproduce:

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

  1.  Login as US HRMS Manager responsibility
  2.  Go to Submit Request form
     (N) Processes and Reports > Submit Processes and Report > Single Request
  3.  Enter name: State Periodic Wage Listing (Enhanced).
  4.  Select State, Period and then open Format LOV in the parameters form
  5.  Error occurs



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.