Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by user3715462, 1 year 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
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_nameFROM fnd_menus_vl m, fnd_grants gWHERE m.menu_id = g.menu_idAND m.menu_name LIKE 'SESG%'AND g.start_date <= SYSDATEAND NVL(g.end_date, SYSDATE) >= SYSDATEAND (g.grantee_type='GLOBAL' ORg.grantee_key IN(SELECT WUR.role_nameFROM WF_USER_ROLES WURWHERE WUR.user_name = :1AND WUR.user_orig_system = :2AND WUR.user_orig_system_id= :3) ORg.grantee_orig_system_id IN(select jrgv.group_idfrom jtf_rs_groups_vl jrgv,jtf_rs_resource_extns_vl jrrev,jtf_rs_group_members_vl jrgmvwhere jrgmv.resource_id=jrrev.resource_idand jrgmv.group_id=jrgv.group_idand 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)