R12.2:UMX - 'Switch User' Functionality Fails with oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation (Doc ID 2019112.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Workflow - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

After upgrade to 12.2.4 patchset,

When attempting to use  'Switch User' functionality for user created on  pre upgrade instance .The following exception is raised :

ERROR
-----------------------
Error: 
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: 
 JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM 
 ((SELECT DISTINCT m.menu_name as name, 
        m.user_menu_name as display_name 
 FROM fnd_menus_vl m, fnd_grants g 
 WHERE m.menu_id = g.menu_id 
       AND m.menu_name LIKE 'SESG%' 
       AND g.start_date <= SYSDATE 
       AND NVL(g.end_date, SYSDATE) >= SYSDATE 
       AND (g.grantee_type='GLOBAL' OR 
            g.grantee_key IN 
              (SELECT WUR.role_name 
                 FROM WF_USER_ROLES WUR 
                  WHERE WUR.user_name = :1 
                     AND WUR.user_orig_system = :2 
                     AND WUR.user_orig_system_id= :3) OR 
            g.grantee_orig_system_id IN 
              (select jrgv.group_id 
                 from jtf_rs_groups_vl jrgv, 
                 jtf_rs_resource_extns_vl jrrev, 
                 jtf_rs_group_members_vl jrgmv 
                   where jrgmv.resource_id=jrrev.resource_id 
                     and jrgmv.group_id=jrgv.group_id 
                     and jrrev.user_name = :4)))) 

CURRENT BEHAVIOR
---------------------------
The functionality of Switch User no more works after 12.2.4 patch set.It works only for new users added to proxy list.
The old uses added to this list after upgrade can no more switch. 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as user who already has pre existing proxy user grant
2. Select on Switch User link.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the functionality of Switch User in 12.2.4 patch set.It works only for new users added to proxy list.

Changes

Upgrade to 12.2.4 patchset 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms