EAM-BOMFDBOM List Of Values For Item Field Is Empty APP-FND-01436 (Doc ID 231417.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Enterprise Asset Management - Version 11.5.7 and later
Information in this document applies to any platform.
.
***Checked for relevance on 15-Sep-2013***


Goal

Why in BOMFDBOM - Define Bill of Material  The list of values for the item field is empty
and see error:
APP-FND-01436: List Of Value Cannot Find any values for you to choose
Cause: The List of Value execution failed to find any values
Cause: The SQL statement specified to fdlfch() failed to return any value
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 to reproduce :
1.create new item, such as :
/Entreprise Asset Manager/Assets/Asset Group ITEM-EAM (created with template=Asset Group)
2. Go to /Entreprise Asset Manager/Assets/asset Bom
3. query on LOV of field item - see error

Solution

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