R12: AP: Not Able to Access the DFF Defined In Invoice Distribution Block
(Doc ID 2858714.1)
Last updated on APRIL 21, 2023
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Invoice Issues
When attempting to use DFF in invoice distribution page, the following error occurs.
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)
-------------------------------------------------------
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)
-------------------------------------------------------
No entries found for List of Values
STEPS TO REPRODUCE THE ISSUE:
---------------------------------------
The issue can be reproduced at will with the following steps:
1. Goto Payables responsibility--> Invoice workbench--> Distribution block
2. Try to access Descriptive flex fields and above error will be observed.
Changes
12.2.x migration
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |