oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select a.inventory_item_id,a.segment1,a.description ,b.OPERAND unit_price from mtl_system_items_b a, qp_list_lines_v b, (select msi.inventory_item_id from Bom_structures_b bbm , Bom_components_b bic , mtl_system_items msi where bbm.bill_Sequence_id = bic.bill_sequence_id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbm.organization_id and ( msi.description like '%Inplan%' or msi.description like '%Overage%') and bbm.organization_id = 1406 start with bbm.assembly_item_id = :1 connect by prior bic.component_item_id = bbm.assembly_item_id minus select INVENTORY_ITEM_ID from CL_ADD_PROD_CONT where chr_id = :2 ) c where a.inventory_item_id = c.inventory_item_id and to_char(a.inventory_item_id) = b.PRODUCT_ATTR_VALUE and b.list_header_id =7007) QRSLT WHERE (( UPPER(SEGMENT1) like :1 AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))

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 user633859, 1 year ago
like '%Inplan%' or msi.description like '%Overage%') and bbm.organization_id = 1406 start with bbm.assembly_item_id = :1 connect by prior bic.component_item_id = bbm.assembly_item_id minus select INVENTORY_ITEM_ID from CL_ADD_PROD_CONT where chr_id = :2
via Oracle Community by 55166, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation SELECT .... AND NOT EXISTS (SELECT 1 FROM XXDAV.XXDAV_INVOICE_IMPORT_LINES_STG STG WHERE APCC.TRX_ID = STG.TRX_ID)) QRSLT WHERE (( UPPER(EMPLOYEE_NAME) = :1 AND
via Oracle Community by mt1, 1 year ago
pa_tasks_expend_v, hr_organization_units WHERE task_organization = organization_id) QRSLT WHERE (( PROJECT_ID = :1 AND UPPER(TASK_NUMBER) like :2 AND (TASK_NUMBER like :3 OR TASK_NUMBER like :4 OR TASK_NUMBER like :5 OR TASK_NUMBER like :6)))
via Oracle Community by user525275, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select fnd_number.number_to_canonical(BUILDING_ID) FLEX_ID , NAME FLEX_VALUE , NAME FLEX_DISPLAY from BIO_BUILD_INFO_TAB where ( $FLEX
via Oracle Community by PVF, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT concatenated_segments , msi.description , msi.organization_id , primary_uom_code , location_control_code , restrict_locators_code
via Oracle Community by PVF, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT concatenated_segments ,msi.description ,msi.organization_id ,primary_uom_code ,location_control_code ,restrict_locators_code
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select a.inventory_item_id,a.segment1,a.description ,b.OPERAND unit_price from mtl_system_items_b a, qp_list_lines_v b, (select msi.inventory_item_id from Bom_structures_b bbm , Bom_components_b bic , mtl_system_items msi where bbm.bill_Sequence_id = bic.bill_sequence_id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbm.organization_id and ( msi.description like '%Inplan%' or msi.description like '%Overage%') and bbm.organization_id = 1406 start with bbm.assembly_item_id = :1 connect by prior bic.component_item_id = bbm.assembly_item_id minus select INVENTORY_ITEM_ID from CL_ADD_PROD_CONT where chr_id = :2 ) c where a.inventory_item_id = c.inventory_item_id and to_char(a.inventory_item_id) = b.PRODUCT_ATTR_VALUE and b.list_header_id =7007) QRSLT WHERE (( UPPER(SEGMENT1) like :1 AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2680)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1683)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
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 org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:619)

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, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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