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)

Oracle Community | user11921947 | 6 years ago
  1. 0

    repeated bind parameters in where clause of ViewLink in OAF in R12 insta

    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_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)
  2. 0

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

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 5.06::error exception unknown 3d

    hivmr.com | 11 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  6. 0

    db:: 4.21::Exception from "Unknown Source" using swing component, any debug tip ? p7

    hivmr.com | 8 months 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_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()
    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