oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'N' AS select_flag, mtrh.request_number, mtrl.line_number, msibkfv.concatenated_segments, mmtt.primary_quantity, mtr.reason_name reason, mmtt.transaction_reference REFERENCE, we.wip_entity_name work_order_name, wro.operation_seq_num, mmtt.subinventory_code source_subinventory, mitkfv1.concatenated_segments source_locator, wro.date_required,fu.user_name created_by, we.wip_entity_id wip_entity_id,we.entity_type, mmtt.organization_id,mmtt.transaction_temp_id transaction_temp_id, mmtt.transaction_header_id, mmtt.move_order_line_id,mmtt.reason_id reason_id, wro.inventory_item_id inventory_item_id, msibkfv.lot_control_code, msibkfv.serial_number_control_code, mmtt.locator_id, mmtt.primary_quantity AS issue_quantity, DECODE (msibkfv.eam_item_type, 3, 'Rebuild', 'Disabled' ) AS enter_rebuild, mmtt.rebuild_item_id, mmtt.rebuild_serial_number, mmtt.rebuild_activity_id, mmtt.rebuild_job_name, NULL AS rebuild_item, NULL AS rebuild_activity, msibkfv.description description, TO_CHAR ('N') AS warning_shown, ( wro.required_quantity - NVL (wro.quantity_issued, 0) - (eam_material_allocqty_pkg.allocated_quantity (wro.wip_entity_id, wro.operation_seq_num, wro.organization_id, wro.inventory_item_id ) ) ) open_quantity, wro.released_quantity, (wip.department_code) AS departmentcode FROM mtl_item_locations_kfv mitkfv1, mtl_txn_request_headers mtrh, mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl, fnd_user fu, mtl_system_items_b_kfv msibkfv, wip_requirement_operations wro, wip_entities we, mtl_transaction_reasons mtr, wip_discrete_jobs wdj, wip_operations_v wip WHERE wro.wip_entity_id = mtrl.txn_source_id AND wro.operation_seq_num = mtrl.txn_source_line_id AND wro.organization_id = mtrl.organization_id AND wro.inventory_item_id = mtrl.inventory_item_id AND we.wip_entity_id = wro.wip_entity_id AND we.organization_id = wro.organization_id AND wdj.organization_id = we.organization_id AND wdj.wip_entity_id = we.wip_entity_id AND wdj.status_type IN (3, 4) AND msibkfv.inventory_item_id = mmtt.inventory_item_id AND msibkfv.organization_id = mmtt.organization_id AND fu.user_id(+) = mtrl.created_by AND mtrh.header_id = mtrl.header_id AND mtrl.line_id = mmtt.move_order_line_id AND mmtt.locator_id = mitkfv1.inventory_location_id(+) AND mmtt.organization_id = mitkfv1.organization_id(+) AND mmtt.reason_id = mtr.reason_id(+) AND we.entity_type = 6 AND mmtt.primary_quantity > 0 AND mtrh.move_order_type = 5 AND mtrl.line_status = 7 AND (mmtt.transaction_mode IS NULL OR mmtt.transaction_mode = 1) AND mmtt.organization_id = :1 AND ( ( msibkfv.serial_number_control_code = 1 AND msibkfv.lot_control_code = 1 AND :2 IS NULL ) OR ( ( msibkfv.serial_number_control_code > 1 OR msibkfv.lot_control_code > 1 ) AND :3 IS NOT NULL ) ) AND wip.wip_entity_id = we.wip_entity_id AND wip.organization_id = we.organization_id AND wro.operation_seq_num = wip.operation_seq_num) QRSLT WHERE (( UPPER(WORK_ORDER_NAME) like :4 AND (WORK_ORDER_NAME like :5 OR WORK_ORDER_NAME like :6 OR WORK_ORDER_NAME like :7 OR WORK_ORDER_NAME like :8)))

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 822827, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'N' AS select_flag, mtrh.request_number, mtrl.line_number, msibkfv.concatenated_segments, mmtt.primary_quantity, mtr.reason_name reason
via Oracle Community by user5425941, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0
via Oracle Community by 881169, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0
via Oracle Community by 868733, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select customer_id from XXCUR_TRADE_CONSOL_SUMMARY
via Oracle Community by 667099, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select msi.secondary_inventory_name as SubInventoryName, msi.description as Description, msi.locator_type, msi.organization_id
via Oracle Community by 541412, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: /* Formatted on 2008/05/22 13:19 (Formatter Plus v4.8.8) */ SELECT transaction_source, batch_name, expenditure_ending_date, employee_number, organization_name
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'N' AS select_flag, mtrh.request_number, mtrl.line_number, msibkfv.concatenated_segments, mmtt.primary_quantity, mtr.reason_name reason, mmtt.transaction_reference REFERENCE, we.wip_entity_name work_order_name, wro.operation_seq_num, mmtt.subinventory_code source_subinventory, mitkfv1.concatenated_segments source_locator, wro.date_required,fu.user_name created_by, we.wip_entity_id wip_entity_id,we.entity_type, mmtt.organization_id,mmtt.transaction_temp_id transaction_temp_id, mmtt.transaction_header_id, mmtt.move_order_line_id,mmtt.reason_id reason_id, wro.inventory_item_id inventory_item_id, msibkfv.lot_control_code, msibkfv.serial_number_control_code, mmtt.locator_id, mmtt.primary_quantity AS issue_quantity, DECODE (msibkfv.eam_item_type, 3, 'Rebuild', 'Disabled' ) AS enter_rebuild, mmtt.rebuild_item_id, mmtt.rebuild_serial_number, mmtt.rebuild_activity_id, mmtt.rebuild_job_name, NULL AS rebuild_item, NULL AS rebuild_activity, msibkfv.description description, TO_CHAR ('N') AS warning_shown, ( wro.required_quantity - NVL (wro.quantity_issued, 0) - (eam_material_allocqty_pkg.allocated_quantity (wro.wip_entity_id, wro.operation_seq_num, wro.organization_id, wro.inventory_item_id ) ) ) open_quantity, wro.released_quantity, (wip.department_code) AS departmentcode FROM mtl_item_locations_kfv mitkfv1, mtl_txn_request_headers mtrh, mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl, fnd_user fu, mtl_system_items_b_kfv msibkfv, wip_requirement_operations wro, wip_entities we, mtl_transaction_reasons mtr, wip_discrete_jobs wdj, wip_operations_v wip WHERE wro.wip_entity_id = mtrl.txn_source_id AND wro.operation_seq_num = mtrl.txn_source_line_id AND wro.organization_id = mtrl.organization_id AND wro.inventory_item_id = mtrl.inventory_item_id AND we.wip_entity_id = wro.wip_entity_id AND we.organization_id = wro.organization_id AND wdj.organization_id = we.organization_id AND wdj.wip_entity_id = we.wip_entity_id AND wdj.status_type IN (3, 4) AND msibkfv.inventory_item_id = mmtt.inventory_item_id AND msibkfv.organization_id = mmtt.organization_id AND fu.user_id(+) = mtrl.created_by AND mtrh.header_id = mtrl.header_id AND mtrl.line_id = mmtt.move_order_line_id AND mmtt.locator_id = mitkfv1.inventory_location_id(+) AND mmtt.organization_id = mitkfv1.organization_id(+) AND mmtt.reason_id = mtr.reason_id(+) AND we.entity_type = 6 AND mmtt.primary_quantity > 0 AND mtrh.move_order_type = 5 AND mtrl.line_status = 7 AND (mmtt.transaction_mode IS NULL OR mmtt.transaction_mode = 1) AND mmtt.organization_id = :1 AND ( ( msibkfv.serial_number_control_code = 1 AND msibkfv.lot_control_code = 1 AND :2 IS NULL ) OR ( ( msibkfv.serial_number_control_code > 1 OR msibkfv.lot_control_code > 1 ) AND :3 IS NOT NULL ) ) AND wip.wip_entity_id = we.wip_entity_id AND wip.organization_id = we.organization_id AND wro.operation_seq_num = wip.operation_seq_num) QRSLT WHERE (( UPPER(WORK_ORDER_NAME) like :4 AND (WORK_ORDER_NAME like :5 OR WORK_ORDER_NAME like :6 OR WORK_ORDER_NAME like :7 OR WORK_ORDER_NAME like :8)))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2850)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1838)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 6 days 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.