APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter
After upgrading oracle application 11i(18.104.22.168) to R12(12.1.3) running concurrent program request caused this issue
When concurrent program is run for a concurrent request after upgrading to R12 12.1.3 the lov, which is attached to a parameter, gives APP-FND-01436: “List of Values cannot find any values for you to choose”. When the same request is run from oracle applications 11i 22.214.171.124 the same value set is working fine. The value set is based on a table. If you go and test the value set query from the value set definition screen it returns complete successful message yet if you go to the parameter of the concurrent request program form where the particular value set is used it gives you the above error.
After searching google and oracle support I found metalink note 1400963.1, EBS R12.1: Parameter for Concurrent Request Using Table Based LOV Gives Error: No Entries Found For List Of Values, which describes the cause of the issue is due to a difference in both the concurrent programs' definitions for "Operating Unit Mode" field. So we have to set this to a proper value.
operating unit mode can be set only from OA Framework pages
To set operating unit mode for concurrent programmes go to (log in to system administration responsibility)
System Administrator > System Administration > Concurrent > Programs
search for the particular program you want to update
Click on the update button
Then go to Request Tab
Right side of the request page you can see operating unit Mode list box, set this value. Now go to the SRS form and submit the same report again
Reference Support docs
EBS R12.1: Parameter for Concurrent Request Using Table Based LOV Gives Error: No Entries Found For List Of Values [ID 1400963.1]
Where To Set The "Operating Unit Mode" When Defining A Concurrent Program [ID 847094.1]