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, 2 years 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, 2 years 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)