After Upgrading to E-Business Suite R12.2.4, Cannot Switch User Due to Error JBO-27122: SQL (Doc ID 2026601.1)

Last updated on DECEMBER 07, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, Workflow Administration

When attempting to click on the switch user icon after upgrading from 12.1.3 to 12.2.4,
the following error occurs.

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 'XX%'
  AND g.start_date   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)))) QRSLT ORDER BY display_name
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3483)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Manage Proxies through the Settings icon at the top of the Home page
2. switching user through the Switch User icon at the top of the Home page.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot approve notifications on behalf of other person

Changes

 The problem only happens for existing people having existing worklist grants

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