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.

  • Migration issue in OAF-urgent
    via by user5425941,
  • Bind Variable in oaf
    via by 839403,
  • handling escape characters in R12 versus 11i
    via by Asmirnov-Oracle,
  • Error when i create a resourse
    via by 882688,
  • How To Caluclate The SIT Date Caluclation.?
    via by Srini-999,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0) as amount, poh.ACCEPTANCE_DUE_DATE, poh.vendor_id, poh.po_header_id, poh.agent_id, poh.type_lookup_code, poh.type_name, poh.vendor_contact_id, poh.vendor_site_id, poh.acceptance_required_flag, poh.approved_date, poh.revision_num, to_char(null) PO_STATUS_CODE , to_char(null) PO_STATUS_DISP , poh.org_name, poh.attribute1, poh.attribute2, poh.attribute3, poh.attribute4, poh.attribute5, poh.attribute6, poh.attribute7, poh.attribute8, poh.attribute9, poh.attribute10, poh.attribute11, poh.attribute12, poh.attribute13, poh.attribute14, poh.attribute15, poh.attribute_category, decode(poh.po_release_id,null,'PosHdrAttach','PosRelAttach') as SwitchAttach, 'N' as retrieve_flag, poh.CANCEL_FLAG, poh.CLOSED_CODE, poh.FROZEN_FLAG, poh.USER_HOLD_FLAG, poh.global_agreement_flag, to_char(null) consigned_consumption_flag, poh.vendor_name, poh.vendor_site_code, poh.po_release_id po_release_id2, poh.vendor_number , poh.vendor_id vendor_id2, org_id, poh.segment1, poh.release_num, to_char(null) business_document_type, to_char(null) business_document_id, to_char(null) business_document_version, 0 as ship_to_location_id, security_level_code, access_level_code from spos_view_po_summary_v poh) QRSLT WHERE (VENDOR_ID in (:1) AND VENDOR_CONTACT_ID in (:2) AND ((VENDOR_SITE_ID in (:3) AND NVL(global_agreement_flag, 'N') = 'N') OR (PO_RELEASE_ID is null AND PO_HEADER_ID in ( select PGA.po_header_id from PO_GA_ORG_ASSIGNMENTS PGA, PO_HEADERS_ALL POH where PGA.po_header_id = POH.po_header_id and PGA.enabled_flag = 'Y' and POH.global_agreement_flag = 'Y' and PGA.vendor_site_id in (:4))))) ORDER BY APPROVED_DATE DESC at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    14 more bugmates