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 user11921947, 1 year ago
object_table_name = 'HZ_PARTIES' AND object_type || '' = 'ORGANIZATION' AND direction_code = 'C' AND relationship_type = 'CISCO_PARENT_SUB' AND status = 'A' AND NVL (end_date, SYSDATE) >= SYSDATE CONNECT BY object_id = PRIOR subject_id AND object_type
via Oracle Community by user11921947, 1 year ago
hzpartieseo, ((SELECT xxccr_rs_read_api.get_global_ultimate (:1) AS party_id, 0 lvl FROM DUAL) UNION ALL (SELECT subject_id party_id, LEVEL lvl FROM hz_relationships START WITH object_id = xxccr_rs_read_api.get_global_ultimate (:2) AND object_table_name
via Oracle Community by user3715462, 1 year ago
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
via Oracle Community by user10702579, 1 year ago
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
via Oracle Community by user630804, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PE.PROJ_ELEMENT_ID AS SEARCH_VALUE, PE.NAME AS DISPLAY_TEXT, OBJECT_CLASSIFICATION_CODE AS CATALOG_GROUP_ID FROM EGO_OBJ_TYPE_LIFECYCLES OLC
via Oracle Community by 1008289, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select template_name, template_code,application_short_name, template_type_code from xdo_templates_vl where ds_app_short_name = :1 and data_source_code = :2 and template_status= 'E' and sysdate between start_date and nvl(end_date,sysdate)
oracle.apps.fnd.framework.OAException: 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,
apps.xxccr_cpam_cust_acct_srv_pkg.get_imm_parent_party
(hzpartieseo.party_id)
AS parent_party,
apps.xxccr_cpam_cust_acct_srv_pkg.get_party_level
(hzpartieseo.party_id)
AS hier_level,
'View Customer Account(s)' AS view_link
FROM (WITH temp AS
(SELECT :1 party_id
FROM DUAL)
SELECT xxccr_rs_read_api.get_global_ultimate (party_id) AS party_id,
0 lvl
FROM temp
UNION ALL
(SELECT subject_id party_id, LEVEL lvl
FROM hz_relationships, temp
START WITH object_id =
xxccr_rs_read_api.get_global_ultimate (temp.party_id)
AND object_table_name = 'HZ_PARTIES'
AND object_type || '' = 'ORGANIZATION'
AND direction_code = 'C'
AND relationship_type = 'CISCO_PARENT_SUB'
AND status = 'A'
AND NVL (end_date, SYSDATE) >= SYSDATE
CONNECT BY object_id = PRIOR subject_id
AND object_type || '' = PRIOR subject_type
AND object_table_name = PRIOR subject_table_name
AND direction_code = 'C'
AND relationship_type = 'CISCO_PARENT_SUB'
AND status = 'A'
AND NVL (end_date, SYSDATE) >= SYSDATE)) hz_rel,
hz_parties hzpartieseo
WHERE hz_rel.party_id = hzpartieseo.party_id) QRSLT WHERE PARTY_ID = :Bind_PartyId	at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)