"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 AUGUST 17, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

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

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