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 , lot_control_code , serial_number_control_code , revision_qty_control_code , eam_item_type , msi.inventory_item_id , msi.padded_concatenated_segments item_code_segment1 , msi.description item_description , mOH.LOCATOR_ID , cst.item_cost , moh.subinventory_code sub_inventory_name , mil.segment1 LOCATOR , mcr.cross_reference , xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) Available_to_transact , sum(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 (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 --and moh.organization_id =3159 -- and moh.INVENTORY_ITEM_ID = 8073 group by moh.subinventory_code ,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 , msi.padded_concatenated_segments , msi.description , MOH.LOCATOR_ID, mil.segment1 , mcr.cross_reference, cst.item_cost, xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_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

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 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 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 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
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 , lot_control_code , serial_number_control_code , revision_qty_control_code , eam_item_type , msi.inventory_item_id , msi.padded_concatenated_segments item_code_segment1 , msi.description item_description , mOH.LOCATOR_ID , cst.item_cost , moh.subinventory_code sub_inventory_name , mil.segment1 LOCATOR , mcr.cross_reference , xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) Available_to_transact , sum(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 (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 --and moh.organization_id =3159 -- and moh.INVENTORY_ITEM_ID = 8073 group by moh.subinventory_code ,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 , msi.padded_concatenated_segments , msi.description , MOH.LOCATOR_ID, mil.segment1 , mcr.cross_reference, cst.item_cost, xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_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)

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, 1 year ago

Write tip

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