oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)

Oracle Community | kkrm333 | 5 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Unable to logon to iProcurement

    Oracle Community | 5 years ago | kkrm333
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)

      at com.orionserver.http.OrionHttpJspPage.service()
    2. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    3. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    5. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    6. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    7. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    8. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    9. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    10. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    11. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame