"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:

Symptoms

When entering federal supplier purchase orders, the TAS/BETC fields give the error:

ERROR

No entries found for List of Values (see screen shots).  


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

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

Changes

The issue started to occur after a number of PO and FV patches have been applied.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.