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

Oracle Community | 822827 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Problem in VO Extension

    Oracle Community | 6 years ago | 822827
    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)))
  2. 0

    OA Exception: NullPointerException

    Oracle Community | 8 years ago | 610323
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  3. 0

    Getting Error when run the custom page in Jdeveloper 10.1.3

    Oracle Community | 8 years ago | bmn
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.apps.fnd.framework.webui.beans.OARawTextBean
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Controller Extension Problem

    Oracle Community | 8 years ago | bmn
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.apps.fnd.framework.webui.beans.OARawTextBean
  6. 0

    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at

    Oracle Community | 7 years ago | 779216
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2850)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1838)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
      7 frames