0 Replies Latest reply: Sep 26, 2013 12:34 PM by BillC RSS

    EBS to APEX ORA-20002: 3402: No valid session exists for this user

    BillC

      Hi,

            ORA-20002: 3402: No valid session exists for this user. Please establish a new session through the login page


      I am getting the above error when using an EBS to APEX setup modeled after Rod West's example, that works in 4 other installations.

            Same DDL, same APP, same EBS function, menu, user, resp


            Going crazy!

       

      it is happening at the call to Wfa_sec.Getsession()

           

            Any ideas? Has anyone else had this error?


      Already tried this before the call to get session

      l_icx_val := fnd_profile.value( 'ICX_DATE_FORMAT_MASK');
      IF l_icx_val IS NOT NULL
      THEN
      execute immediate 'alter session set nls_date_format = ''' || l_icx_val || '''';
      END IF;