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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1176

  • via Oracle Community by user11921947, 11 months ago
    || '' = 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
  • 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 Pradeep Navin Kumar, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Offer.OFFER_ID, Offer.OFFER_VERSION, Offer.LAST_UPDATE_DATE, Offer.CREATION_DATE, Vac.VACANCY_ID, Vac.NAME
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates