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_pkg.get_immediate_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 ar.hz_parties 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 = '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 WHERE hzpartieseo.party_id = hz_rel.party_id) QRSLT WHERE :Bind_PartyId =xxcc_cust_acct_pkg.get_immediate_parent_party(PARTY_ID)

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
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 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 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_pkg.get_immediate_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 ar.hz_parties 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 = '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 WHERE hzpartieseo.party_id = hz_rel.party_id) QRSLT WHERE :Bind_PartyId =xxcc_cust_acct_pkg.get_immediate_parent_party(PARTY_ID)
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
9 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.