oracle.apps.fnd.framework.OAException

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, QRSLT.PO_RELEASE_ID, QRSLT.ORDER_ID, QRSLT.PO_NUMBER, QRSLT.PO_LINE_ID, QRSLT.PO_LINE_LOCATION_ID, QRSLT.PO_RELEASE_NUMBER, QRSLT.PO_LINE_NUMBER, QRSLT.PO_SHIPMENT_NUMBER, QRSLT.TO_ORGANIZATION_ID, QRSLT.ITEM_ID, QRSLT.PRIMARY_UOM, QRSLT.PRIMARY_UOM_CLASS, QRSLT.QUANTITY_DELIVERED, QRSLT.EXPECTED_RECEIPT_QTY, QRSLT.ITEM_DESCRIPTION, QRSLT.SHIP_TO_LOCATION_ID, QRSLT.VENDOR_ID, QRSLT.SOURCE, QRSLT.VENDOR_SITE_ID, QRSLT.SUPPLIER_SITE, QRSLT.NEED_BY_DATE, QRSLT.PROMISED_DATE, QRSLT.EXPECTED_RECEIPT_DATE, QRSLT.ORDERED_QTY, QRSLT.ORDERED_UOM, QRSLT.USSGL_TRANSACTION_CODE, QRSLT.PO_DISTRIBUTION_ID, QRSLT.PO_NUM_REL_NUM, QRSLT.UNIT, QRSLT.RECEIPT_QUANTITY, QRSLT.REQ_DISTRIBUTION_ID, QRSLT.DELIVER_TO_LOCATION_ID, QRSLT.REQ_HEADER_ID, QRSLT.REQUISITION_NUMBER, QRSLT.ORDER_TYPE, QRSLT.PO_DISTRIBUTION_NUM, QRSLT.VENDOR_PRODUCT_NUM, QRSLT.ORDER_NUMBER, QRSLT.MATCHING_BASIS, QRSLT.REQ_LINK, QRSLT.SHIPMENT_HEADER_ID , QRSLT.MANUFACTURER_PART_NUMBER, QRSLT.OPERATING_UNIT, PORD.PROJECT_ID, PAPA.SEGMENT1 PROJECT_NUMBER, papa.name PROJECT_NAME, PORL.LINE_NUM REQ_LINE_NUM, PAT.TASK_NUMBER, PAT.TASK_NAME, pord.Expenditure_Type, NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE FROM (SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_my_purchase_items_v rcv UNION ALL SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv1.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_internal_items_v rcv1 ) QRSLT ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER

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 web1253

  • via Oracle Community by 594196, 11 months ago
    ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER
  • ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER
  • 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
  • Stack trace

    • oracle.apps.fnd.framework.OAException: 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, QRSLT.PO_RELEASE_ID, QRSLT.ORDER_ID, QRSLT.PO_NUMBER, QRSLT.PO_LINE_ID, QRSLT.PO_LINE_LOCATION_ID, QRSLT.PO_RELEASE_NUMBER, QRSLT.PO_LINE_NUMBER, QRSLT.PO_SHIPMENT_NUMBER, QRSLT.TO_ORGANIZATION_ID, QRSLT.ITEM_ID, QRSLT.PRIMARY_UOM, QRSLT.PRIMARY_UOM_CLASS, QRSLT.QUANTITY_DELIVERED, QRSLT.EXPECTED_RECEIPT_QTY, QRSLT.ITEM_DESCRIPTION, QRSLT.SHIP_TO_LOCATION_ID, QRSLT.VENDOR_ID, QRSLT.SOURCE, QRSLT.VENDOR_SITE_ID, QRSLT.SUPPLIER_SITE, QRSLT.NEED_BY_DATE, QRSLT.PROMISED_DATE, QRSLT.EXPECTED_RECEIPT_DATE, QRSLT.ORDERED_QTY, QRSLT.ORDERED_UOM, QRSLT.USSGL_TRANSACTION_CODE, QRSLT.PO_DISTRIBUTION_ID, QRSLT.PO_NUM_REL_NUM, QRSLT.UNIT, QRSLT.RECEIPT_QUANTITY, QRSLT.REQ_DISTRIBUTION_ID, QRSLT.DELIVER_TO_LOCATION_ID, QRSLT.REQ_HEADER_ID, QRSLT.REQUISITION_NUMBER, QRSLT.ORDER_TYPE, QRSLT.PO_DISTRIBUTION_NUM, QRSLT.VENDOR_PRODUCT_NUM, QRSLT.ORDER_NUMBER, QRSLT.MATCHING_BASIS, QRSLT.REQ_LINK, QRSLT.SHIPMENT_HEADER_ID , QRSLT.MANUFACTURER_PART_NUMBER, QRSLT.OPERATING_UNIT, PORD.PROJECT_ID, PAPA.SEGMENT1 PROJECT_NUMBER, papa.name PROJECT_NAME, PORL.LINE_NUM REQ_LINE_NUM, PAT.TASK_NUMBER, PAT.TASK_NAME, pord.Expenditure_Type, NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE FROM (SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_my_purchase_items_v rcv UNION ALL SELECT REQ_LINE_ID, RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, USSGL_TRANSACTION_CODE, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv1.order_type_code AND lookup.lookup_type ='POR_RCV_ORDER_TYPE' ) ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, matching_basis, DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(NULL) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT FROM por_rcv_internal_items_v rcv1 ) QRSLT ,PO.PO_REQ_DISTRIBUTIONS_ALL pord ,PO.PO_REQUISITION_LINES_ALL porl ,PA.PA_PROJECTS_ALL PAPA ,PA.PA_TASKS PAT WHERE pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID AND pord.requisition_line_id = porl.requisition_line_id AND pord.PROJECT_ID = papa.PROJECT_ID AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708) at oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:458) at oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:67) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432) at oa_html._OA._jspService(_OA.java:84) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162) at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187) at oa_html._OA._jspService(_OA.java:94) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162) at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187) at oa_html._OA._jspService(_OA.java:94) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnection.java:294) at java.lang.Thread.run(Thread.java:534)

    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