Wednesday, 2 May 2012

APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter (R12 12.1.3)


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(11.5.10.2) 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 11.5.10.2 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]