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

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1658

  • via Unknown by 822827,
  • via Unknown by 610323,
  • Stack trace

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

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    14 more bugmates