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 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)