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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1631

  • via Oracle Community by user10702579, 11 months ago
    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
  • via Oracle Community by user3715462, 11 months ago
    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
  • via Oracle Community by amit.kochar-Oracle, 1 year ago
    , fnd_lookup_values fl WHERE fl.lookup_type = :1 AND fl.lookup_code = csm.ship_method_code AND fl.view_application_id = :2 AND nvl(fl.start_date_active, sysdate) <= sysdate AND nvl(fl.end_date_active, sysdate) >= sysdate AND fl.language = USERENV('LANG') AND fl.enabled_flag = :3 AND csm.enabled_flag = :4 AND csm.organization_id = :5) QRSLT ORDER BY meaning
  • Stack trace

    • 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:3247) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates