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 | 5 years ago
  1. 0

    Problem in VO Extension

    Oracle Community | 5 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 | 7 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 | 7 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 | 7 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 | 6 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