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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by kkrm333, 1 year ago
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
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(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:662)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.