oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT MS.SEGMENT1 FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MS WHERE CII.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID And cii.LAST_VLD_ORGANIZATION_ID = :1) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER( :1) ))

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by MAHA REDDY, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT MS.SEGMENT1 FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MS WHERE CII.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID And cii.LAST_VLD_ORGANIZATION_ID = :1) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER( :1) ))
via Oracle Community by Hemant Garg, 1 year ago
oracle.jbo.CustomClassNotFoundException: JBO-26022: Could not find and load the custom class who.oracle.apps.xxtrl.travelrequest.lov.server.XXTRL_TRTravellerLOVVOImpl
via Oracle Community by 2718604, 1 year ago
oracle.jbo.RowCreateException: JBO-25017: Error while creating a new entity row for InsertEO.
via Oracle Community by 552232, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select Order_Number,Header_Id,sold_to_org_id CustomerId from oe_order_headers_all oeoh,Ra_Customers rca where oeoh.sold_to_org_id = rca.customer_id and oeoh.flow_status_code not in ('CANCELLED','CLOSED')) QRSLT WHERE (( ORDER_NUMBER like :1 AND SOLD_TO_ORG_ID = :2 ))
via Oracle Community by 818606, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select invoice_number,supplier_number,supplier_site,invoice_amount,null invoice_date,null Source,'Invoices' record_location from audit_invoices
via Oracle Community by 648384, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PoVendors.VENDOR_ID AS SUPPLIER_ID, PoVendorSitesAll.VENDOR_SITE_ID AS SUPPLIER_SITE_ID, PoVendorContacts.VENDOR_CONTACT_ID AS
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT MS.SEGMENT1 FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MS WHERE CII.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID And cii.LAST_VLD_ORGANIZATION_ID = :1) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER( :1) ))
at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormData(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at undefined._OA._jspService(_OA.java:71)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
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.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

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