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

Oracle Community | user3715462 | 4 years ago
  1. 0

    Unable to login

    Oracle Community | 4 years ago | user10702579
    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
  2. 0

    fnd_preference.put not working

    Oracle Community | 4 years ago | user3715462
    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
  3. 0

    db:: 5.87::oracle.jbo.NoDefException JBO-25058 1k

    hivmr.com | 5 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition DESCRIPTION of type Attribute not found in PreviousEmployment
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    "Unknown Source" Errors

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 16

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3247)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)
      4 frames