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

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)