"No entries found for List of Values" for the TAS/BETC Fields When Entering Federal Supplier Purchase Order
Last updated on AUGUST 17, 2017
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
When entering federal supplier purchase orders, the TAS/BETC fields give the error:
No entries found for List of Values (see screen shots).
Validation Failure: Trading Partner TAS and BETC must be provided for Federal/General Fund Suppliers
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. Oracle Purchasing
2. Purchase Orders
3. Enter a new PO with federal supplier At the distribution -> Save
The issue started to occur after a number of PO and FV patches have been applied.
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