After Login, exception oracle.jbo.SQLStmtException: JBO-27122 (Doc ID 1587461.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

After login, application page is not coming up.  The following exception occurs:

Exception Details.  
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM ((SELECT 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)))union (select 'All','All' from dual)) 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:3260)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3055)
at _OA._jspService(_OA.java:220)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)


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