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]




Comments

  1. Suresh17 January 2013 at 20:39

    Thanks Yoona it's helped me for same issue .

    ReplyDelete
    Replies
    1. Yoonas18 January 2013 at 22:40

      You are welcome, glad to know its helpful :)

      Delete
    2. Unknown28 March 2013 at 02:05

      I did the changes in system admin responsibility but I am getting the same error... help me out..

      Delete
    3. Yoonas5 April 2013 at 23:17

      Are you having issues even after logging out and logging back in? Please make sure you have done the changes correctly (sometimes we happened to change wrong concurrent programmes )

      Delete
  2. Ramz Receipe's31 May 2017 at 08:02

    Thank you this helped

    ReplyDelete

Post a Comment

Popular posts from this blog

WEB ADI - issues encountered during initial access

Image
On accessing create document link under Desktop Integrator responsibility browser was showing following error Set BNE UIX Physical Directory profile value to proper directory at site level Location = $COMMON_TOP/html/cabo/  (11i) Location = $COMMON_TOP/webapps/oacore/html/cabo/  (R12) As this was a cloned instance the value of this profile setting was pointing to a wrong location. set as BNE UIX Physical Directory /u03/oracle/prodcomn/html/cabo/ Access to functions are controlled by function security so to access and work with web adi the user should have proper access. You should have access to particular integrator to access and work with it Find out responsibility which is created to work with web adi check the main menu for this responsibility. Modify the responsibility or Menu if default is not fitting to your needs. For instance Desktop Integration Menu has create document, Define Lay out, Define Mapping, Manage Documents, Setup options Note : you...
Read more

Error processing request - Contact your application administrator apex 20.1

Image
After upgrading 11.2.0.4 to 19c with apex 20.1 accessing apex_admin/apex pages was throwing “Error processing request” Contact your application administrator. There were three invalid objects for APEX_200100 WWV_FLOW_SESSION_RAS WWV_FLOW_WIZARD_API WWV_FLOW_DATA_LOADER Tried compiling these objects but compile was completing with PL/SQL: ORA-00942: table or view does not exist To resolve the issue following rant needs to be given then compile (ran both grant and compile as sysdba) grant select on SYS.DBA_XS_DYNAMIC_ROLES to APEX_200100; grant select on SYS.DBA_TAB_IDENTITY_COLS to APEX_200100; alter package APEX_200100.WWV_FLOW_SESSION_RAS compile body; alter package APEX_200100.WWV_FLOW_WIZARD_API compile body; alter package APEX_200100.WWV_FLOW_DATA_LOADER compile body; Returned 0 invalid object for APEX_200100  select * from dba_objects where status = 'INVALID' and owner = 'APEX_200100' ; Now both admin and apex pages ar...
Read more