My Oracle Support Banner

R12: Cannot Select Ledger When Submit Close Process - Create Income Statement Closing Journals Program (Doc ID 1377677.1)

Last updated on AUGUST 06, 2020

Applies to:

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


On : 12.1.1 version, Other Issues

When attempting to select value of parameter 'Ledger/Ledger Set' for request Close Process - Create Income Statement Closing Journals in new responsibility,
the 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)

The issue can be reproduced at will with the following steps:
1. Login as General Ledger responsibility
2. Navigate to Reports > Request > Standard
3. Select request 'Close Process - Create Income Statement Closing Journals'
4. Call the LOV of parameter 'Ledger/Ledger Set'




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.