oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select vr.receipt_num Rcpt_Num, vr.quantity Qty, vr.quantity_ordered Qty_Ordered, vr.WAYBILL_AIRBILL_NUM Waybill, vr.packing_slip Packing_Slip, comments Comments, vr.PO_DISTRIBUTION_ID Po_Distrib_Id, vr.item_id Item_Id, vr.po_line_id Po_Line_Id, vr.po_line_location_id Po_Line_Location_Id, vr.req_number Req_Num, vr.item_description Item_Desc, vr.unit_of_measure Uom, vr.net_delivered_quantity Qty_Rcvd, vr.creation_date RcptDate, vr.vendor supplier, look.meaning Order_Type, vr.po_number Order_Num, 'IMAGE' View_Details, nvl((select 'EnableBlueDot' from dual where exists ( select '1' from rcv_transactions rcv where rcv.parent_transaction_id = vr.rcv_transaction_id)), 'Disable') Bluedot, vr.rcv_transaction_id Rcv_Txn_Id, vr.req_header_id Req_Header_Id, decode(vr.req_header_id, null, 'HideReq', 'ShowReq') Req_Link, vr.transaction_date Txn_Date, vr.po_release_number Po_Release_Number, vr.po_no_release_number Po_No_Release_Number, vr.so_number So_Number, vr.employee_id Employee_Id, vr.person Requestor, po_header_id, po_release_id, to_number(null) order_id, shipment_header_id, VENDOR_ID, vr.REQ_LINE_ID Req_Line_Id, OPERATING_UNIT from por_rcv_purchase_receipts_v vr, fnd_lookup_values_vl look WHERE look.lookup_type = 'POR_RCV_ORDER_TYPE' AND look.lookup_code = vr.source_document_code AND 'N'= (select xx_check_req_receipt(req_header_id) from dual) UNION ALL select vr.receipt_num Rcpt_Num, vr.quantity Qty, vr.quantity_ordered Qty_Ordered, vr.WAYBILL_AIRBILL_NUM Waybill, vr.packing_slip Packing_Slip, comments Comments, vr.PO_DISTRIBUTION_ID Po_Distrib_Id, vr.item_id Item_Id, vr.po_line_id Po_Line_Id, vr.po_line_location_id Po_Line_Location_Id, vr.req_number Req_Num, vr.item_description Item_Desc, vr.unit_of_measure Uom, vr.net_delivered_quantity Qty_Rcvd, vr.creation_date RcptDate, vr.vendor supplier, look.meaning Order_Type, vr.po_number Order_Num, 'IMAGE' View_Details, nvl((select 'EnableBlueDot' from dual where exists ( select '1' from rcv_transactions rcv where rcv.parent_transaction_id = vr.rcv_transaction_id)), 'Disable') Bluedot, vr.rcv_transaction_id Rcv_Txn_Id, vr.req_header_id Req_Header_Id, decode(vr.req_header_id, null, 'HideReq', 'ShowReq') Req_Link, vr.transaction_date Txn_Date, vr.po_release_number Po_Release_Number, vr.po_no_release_number Po_No_Release_Number, vr.so_number So_Number, vr.employee_id Employee_Id, vr.person Requestor, to_number(null) po_header_id, to_number(null) po_release_id, order_id, shipment_header_id, to_number(NULL) VENDOR_ID, vr.REQ_LINE_ID ReqLineId, OPERATING_UNIT from por_rcv_internal_receipts_v vr, fnd_lookup_values_vl look WHERE look.lookup_type = 'POR_RCV_ORDER_TYPE' AND look.lookup_code = vr.source_document_code AND 'N'= (select xx_check_req_receipt(req_header_id) from dual)) QRSLT WHERE (Employee_Id = :0 and Txn_Date >= trunc(sysdate - 8) and Txn_Date <= trunc(sysdate + 1))

Solutions on the web1119

  • via Oracle Community by 927149, 11 months ago
    Qty_Rcvd, vr.creation_date RcptDate, vr.vendor supplier, look.meaning Order_Type, vr.po_number Order_Num, 'IMAGE' View_Details, nvl((select 'EnableBlueDot' from dual where exists ( select '1' from rcv_transactions rcv where rcv.parent_transaction_id
  • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER
  • via Oracle Community by 594196, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select vr.receipt_num Rcpt_Num, vr.quantity Qty, vr.quantity_ordered Qty_Ordered, vr.WAYBILL_AIRBILL_NUM Waybill, vr.packing_slip Packing_Slip, comments Comments, vr.PO_DISTRIBUTION_ID Po_Distrib_Id, vr.item_id Item_Id, vr.po_line_id Po_Line_Id, vr.po_line_location_id Po_Line_Location_Id, vr.req_number Req_Num, vr.item_description Item_Desc, vr.unit_of_measure Uom, vr.net_delivered_quantity Qty_Rcvd, vr.creation_date RcptDate, vr.vendor supplier, look.meaning Order_Type, vr.po_number Order_Num, 'IMAGE' View_Details, nvl((select 'EnableBlueDot' from dual where exists ( select '1' from rcv_transactions rcv where rcv.parent_transaction_id = vr.rcv_transaction_id)), 'Disable') Bluedot, vr.rcv_transaction_id Rcv_Txn_Id, vr.req_header_id Req_Header_Id, decode(vr.req_header_id, null, 'HideReq', 'ShowReq') Req_Link, vr.transaction_date Txn_Date, vr.po_release_number Po_Release_Number, vr.po_no_release_number Po_No_Release_Number, vr.so_number So_Number, vr.employee_id Employee_Id, vr.person Requestor, po_header_id, po_release_id, to_number(null) order_id, shipment_header_id, VENDOR_ID, vr.REQ_LINE_ID Req_Line_Id, OPERATING_UNIT from por_rcv_purchase_receipts_v vr, fnd_lookup_values_vl look WHERE look.lookup_type = 'POR_RCV_ORDER_TYPE' AND look.lookup_code = vr.source_document_code AND 'N'= (select xx_check_req_receipt(req_header_id) from dual) UNION ALL select vr.receipt_num Rcpt_Num, vr.quantity Qty, vr.quantity_ordered Qty_Ordered, vr.WAYBILL_AIRBILL_NUM Waybill, vr.packing_slip Packing_Slip, comments Comments, vr.PO_DISTRIBUTION_ID Po_Distrib_Id, vr.item_id Item_Id, vr.po_line_id Po_Line_Id, vr.po_line_location_id Po_Line_Location_Id, vr.req_number Req_Num, vr.item_description Item_Desc, vr.unit_of_measure Uom, vr.net_delivered_quantity Qty_Rcvd, vr.creation_date RcptDate, vr.vendor supplier, look.meaning Order_Type, vr.po_number Order_Num, 'IMAGE' View_Details, nvl((select 'EnableBlueDot' from dual where exists ( select '1' from rcv_transactions rcv where rcv.parent_transaction_id = vr.rcv_transaction_id)), 'Disable') Bluedot, vr.rcv_transaction_id Rcv_Txn_Id, vr.req_header_id Req_Header_Id, decode(vr.req_header_id, null, 'HideReq', 'ShowReq') Req_Link, vr.transaction_date Txn_Date, vr.po_release_number Po_Release_Number, vr.po_no_release_number Po_No_Release_Number, vr.so_number So_Number, vr.employee_id Employee_Id, vr.person Requestor, to_number(null) po_header_id, to_number(null) po_release_id, order_id, shipment_header_id, to_number(NULL) VENDOR_ID, vr.REQ_LINE_ID ReqLineId, OPERATING_UNIT from por_rcv_internal_receipts_v vr, fnd_lookup_values_vl look WHERE look.lookup_type = 'POR_RCV_ORDER_TYPE' AND look.lookup_code = vr.source_document_code AND 'N'= (select xx_check_req_receipt(req_header_id) from dual)) QRSLT WHERE (Employee_Id = :0 and Txn_Date >= trunc(sysdate - 8) and Txn_Date <= trunc(sysdate + 1)) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720) at oracle.apps.icx.por.rcv.webui.VrcSrchCO.processRequest(VrcSrchCO.java:236) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2496) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1892) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)

    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
    10 more bugmates