My Oracle Support Banner

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

Last updated on JANUARY 16, 2020

Applies to:

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


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(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(
at _OA._jspService(
at com.orionserver.http.OrionHttpJspPage.service(


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.