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

Last updated on NOVEMBER 23, 2015

Applies to:

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

Symptoms

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.

ERROR
-----------------------
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)


STEPS
-----------------------
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'

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