My Oracle Support Banner

"No entries found for List of Values" for the TAS/BETC Fields When Entering Federal Supplier Purchase Order (Doc ID 2115077.1)

Last updated on MARCH 02, 2023

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.


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.