oracle.apps.fnd.framework.OAException: 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 ,restrict_subinventories_code ,msi.inventory_item_id ,lot_control_code, serial_number_control_code ,revision_qty_control_code ,eam_item_type ,msi.inventory_item_id as InventoryItem ,msi.padded_concatenated_segments item_code_segment1 ,msi.description item_description ,moh.subinventory_code sub_inventory_name ,moh.primary_transaction_quantity total_qoh ,SFI_EAM_tranqty(moh.organization_id,msi.inventory_item_id) Available_to_transact ,mil.segment1 LOCATOR ,mcr.cross_reference ,cst.item_cost FROM mtl_system_items_kfv msi, mtl_onhand_quantities_detail moh, apps.mtl_item_locations mil, apps.mtl_cross_references mcr, apps.cst_item_costs cst WHERE stock_enabled_flag = 'Y' AND bom_item_type = 4 AND (eam_item_type IS NULL OR eam_item_type = 3) AND moh.inventory_item_id(+) = msi.inventory_item_id AND moh.organization_id(+) = msi.organization_id AND moh.locator_id = mil.inventory_location_id(+) AND moh.organization_id = mcr.organization_id(+) AND mcr.cross_reference_type(+) = 'SFI_MRO_OLD_PART_NUM' AND moh.inventory_item_id = mcr.inventory_item_id(+) AND msi.inventory_item_status_code != 'Inactive' AND msi.item_type != 'AG' AND msi.item_type != 'AA' AND msi.item_type != 'OP' AND moh.inventory_item_id = cst.inventory_item_id AND moh.organization_id = cst.organization_id order by total_qoh desc) QRSLT WHERE (organization_id = (select distinct organization_id from wip_discrete_jobs where wip_entity_id = :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

Solutions on the web

via Oracle Community by PVF, 1 year ago
(moh.primary_transaction_quantity) total_qoh FROM mtl_system_items_kfv msi, mtl_onhand_quantities_detail moh, apps.mtl_item_locations mil, apps.mtl_cross_references mcr, apps.cst_item_costs cst WHERE stock_enabled_flag = 'Y' AND bom_item_type = 4 AND
via Oracle Community by PVF, 1 year ago
mtl_system_items_kfv msi, mtl_onhand_quantities_detail moh, apps.mtl_item_locations mil, apps.mtl_cross_references mcr, apps.cst_item_costs cst WHERE stock_enabled_flag = 'Y' AND bom_item_type = 4 AND (eam_item_type IS NULL OR eam_item_type = 3) AND
via Oracle Community by user633859, 1 year ago
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
via Oracle Community by mt1, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT task_number, indented_task_name, start_date, completion_date, task_id, project_id, task_organization, name org_unit FROM
via Oracle Community by 735001, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT CONTRACT_ID, SERIAL_NUM, SITE_NAME, MODEL_ID, MODEL_VER, PROCESS_STATUS, DECODE(PROCESS_STATUS,'ERRORED','OraErrorText
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
oracle.apps.fnd.framework.OAException: 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
,restrict_subinventories_code
,msi.inventory_item_id
,lot_control_code, serial_number_control_code
,revision_qty_control_code
,eam_item_type
,msi.inventory_item_id as InventoryItem
,msi.padded_concatenated_segments item_code_segment1
,msi.description item_description
,moh.subinventory_code sub_inventory_name
,moh.primary_transaction_quantity total_qoh
,SFI_EAM_tranqty(moh.organization_id,msi.inventory_item_id) Available_to_transact
,mil.segment1 LOCATOR
,mcr.cross_reference
,cst.item_cost
FROM mtl_system_items_kfv msi,
mtl_onhand_quantities_detail moh,
apps.mtl_item_locations mil,
apps.mtl_cross_references mcr,
apps.cst_item_costs cst
WHERE stock_enabled_flag = 'Y'
AND bom_item_type = 4
AND (eam_item_type IS NULL OR eam_item_type = 3)
AND moh.inventory_item_id(+) = msi.inventory_item_id
AND moh.organization_id(+) = msi.organization_id
AND moh.locator_id = mil.inventory_location_id(+)
AND moh.organization_id = mcr.organization_id(+)
AND mcr.cross_reference_type(+) = 'SFI_MRO_OLD_PART_NUM'
AND moh.inventory_item_id = mcr.inventory_item_id(+)
AND msi.inventory_item_status_code != 'Inactive'
AND msi.item_type != 'AG'
AND msi.item_type != 'AA'
AND msi.item_type != 'OP'
AND moh.inventory_item_id = cst.inventory_item_id
AND moh.organization_id = cst.organization_id
order by total_qoh desc) QRSLT WHERE (organization_id = (select distinct organization_id from wip_discrete_jobs where wip_entity_id = :1))	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:2704)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)	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:534)