oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • db:: 5.06::error exception unknown 3d
    via by Unknown author,
  • JBO-29000 error
    via by 63000,
  • Running NotificationsPG on local machine
    via by Amit Goyal,
  • Error in the LOV window.
    via by 662449,
    • 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

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    9 more bugmates