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)