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

Oracle Community | user11921947 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    HGrid not working in R12   using jdeveloper 10.1.3.3

    Oracle Community | 6 years ago | user11921947
    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
  2. 0

    Unknown Macro: "Existsroute" (File: Drivers\Kinetis\Sdhc_Ldd.Rgi)

    wpthm.com | 2 years ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  3. 0

    db:: 3.71::I have an issue with an unknown User Account on the computer. 3d

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Users Getting "Unknown User" In Pre-Boot Despite Log/Epo Showing Otherwise

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  6. 0

    db:: 5.06::error exception unknown 3d

    hivmr.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      4 frames