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
via Oracle Community by user10702579, 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
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
via Oracle Community by user11921947, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT hzpartieseo.party_id AS party_id, hzpartieseo.party_name AS party_name, hzpartieseo.hq_branch_ind AS party_type
via Oracle Community by user11921947, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT hzpartieseo.party_id AS party_id, hzpartieseo.party_name AS party_name, hzpartieseo.hq_branch_ind AS party_type
via Oracle Community by sseth29, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT lookup_code, meaning FROM fnd_lookup_values WHERE trunc(nvl(start_date_active, SYSDATE)) <= trunc(SYSDATE) AND trunc(nvl(end_date_active, SYSDATE
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)