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 961553, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT item_number, item_description, inventory_item_id, billing_type, mtl_transactions_enabled_flag, recovered_part_disp_code
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 784264, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT organization_id,name FROM hr_organization_units where COST_ALLOCATION_KEYFLEX_ID in(SELECT pcak.COST_ALLOCATION_KEYFLEX_ID FROM pay_cost_allocation_keyflex pcak WHERE pcak.segment2 like :1)
via Oracle Community by HaroonAfridi, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EmpTestEO.EMPNO, EmpTestEO.ENAME, EmpTestEO.JOB, EmpTestEO.MGR, EmpTestEO.HIREDATE, EmpTestEO.SAL, EmpTestEO.COMM, EmpTestEO.DEPTNO FROM EMP_TEST EmpTestEO WHERE EMPNO = :1
via Oracle Community by 784264, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT hou.organization_id,hou.name org_name,hou.cost_allocation_keyflex_id cost_allocation_keyflex_id FROM hr_organization_units hou where cost_allocation_keyflex_id = (SELECT distinct pcak.cost_allocation_keyflex_id FROM pay_cost_allocation_keyflex pcak WHERE pcak.segment2=:1)
via Oracle Community by Asmirnov-Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT *
FROM (SELECT item_number, item_description, inventory_item_id, billing_type, mtl_transactions_enabled_flag, recovered_part_disp_code,
primary_uom_code, recovered_part_disp, transaction_type_id, qrslt.organization_id, restrict_locators_code, update_ib_flag,
ib_trackable, location_control_code, lot_control_code, revision_qty_control_code, serial_number_control_code,
restrict_subinventories_code, onhand_qty, csp_inv_loc_assignment_id, subinventory_code, resource_type,
resource_id, revision, available_qty
FROM (SELECT msibk.concatenated_segments item_number, msibk.description item_description,
msibk.inventory_item_id, msibk.material_billable_flag billing_type,
msibk.mtl_transactions_enabled_flag, msibk.recovered_part_disp_code,
msibk.primary_uom_code, fl.meaning recovered_part_disp,
DECODE (:1, 'NO_CTBT', -1, ctbt.transaction_type_id) transaction_type_id,
msibk.organization_id, msibk.restrict_locators_code,
NVL (msibk.comms_nl_trackable_flag, 'N' ) update_ib_flag,
NVL (msibk.comms_nl_trackable_flag, 'N') ib_trackable, msibk.location_control_code,
msibk.lot_control_code, msibk.revision_qty_control_code,
csf_debrief_pvt.serial_number_control_code
(msibk.organization_id,msibk.inventory_item_id, 93 ) serial_number_control_code,
msibk.restrict_subinventories_code, mosv.total_qoh onhand_qty,
cila.csp_inv_loc_assignment_id, cila.subinventory_code, cila.resource_type,
cila.resource_id, TO_CHAR (NULL) revision,
csp_validate_pub.get_avail_qty (mosv.organization_id,mosv.subinventory_code,NULL,mosv.inventory_item_id, mosv.revision ) available_qty
FROM mtl_onhand_sub_v mosv,
csp_inv_loc_assignments cila,
csp_sec_inventories csi,
mtl_parameters mp,
mtl_system_items_b_kfv msibk,
fnd_lookups fl,
(SELECT transaction_type_id, billing_type
FROM cs_txn_billing_types
WHERE ROWNUM = DECODE (:2, 'NO_CTBT', 1, ROWNUM)) ctbt,
cs_billing_type_categories cbtc
WHERE mosv.organization_id = cila.organization_id
AND mosv.subinventory_code = cila.subinventory_code
AND msibk.organization_id = mosv.organization_id
AND msibk.inventory_item_id = mosv.inventory_item_id
AND mp.organization_id = cila.organization_id
AND csi.organization_id = cila.organization_id
AND csi.secondary_inventory_name = cila.subinventory_code
AND csi.condition_type = 'G'
AND msibk.mtl_transactions_enabled_flag = 'Y'
AND msibk.recovered_part_disp_code = fl.lookup_code(+)
AND fl.lookup_type(+) = 'CSP_RECOVERED_PART_DISP_CODE'
AND DECODE (:3,
'NO_CTBT', cbtc.billing_type,
ctbt.billing_type
) = cbtc.billing_type
AND cbtc.billing_category = 'M'
AND cbtc.billing_type = msibk.material_billable_flag
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (msibk.start_date_active, SYSDATE ) )
AND TRUNC (NVL (msibk.end_date_active, SYSDATE))
AND ( ( mp.negative_inv_receipt_code 1 AND mosv.total_qoh > 0 )
OR mp.negative_inv_receipt_code = 1)
UNION ALL
SELECT msibk.concatenated_segments item_number,
msibk.description item_description,
msibk.inventory_item_id,
msibk.material_billable_flag billing_type,
msibk.mtl_transactions_enabled_flag,
msibk.recovered_part_disp_code,
msibk.primary_uom_code,
fl.meaning recovered_part_disp,
DECODE (:4,'NO_CTBT', -1, ctbt.transaction_type_id) transaction_type_id,
msibk.organization_id, msibk.restrict_locators_code,
NVL (msibk.comms_nl_trackable_flag, 'N' ) update_ib_flag,
NVL (msibk.comms_nl_trackable_flag, 'N') ib_trackable, msibk.location_control_code,
msibk.lot_control_code,
msibk.revision_qty_control_code,
csf_debrief_pvt.serial_number_control_code
(msibk.organization_id, msibk.inventory_item_id, 93 ) serial_number_control_code,
msibk.restrict_subinventories_code, 0 onhand_qty,
cila.csp_inv_loc_assignment_id,
cila.subinventory_code, cila.resource_type,
cila.resource_id, TO_CHAR (NULL) revision,
0 available_qty
FROM mtl_system_items_b_kfv msibk,
csp_inv_loc_assignments cila,
csp_sec_inventories csi,
mtl_parameters mp,
fnd_lookups fl,
(SELECT transaction_type_id, billing_type
FROM cs_txn_billing_types
WHERE ROWNUM = DECODE (:5, 'NO_CTBT', 1, ROWNUM)) ctbt,
cs_billing_type_categories cbtc
WHERE mp.organization_id = cila.organization_id
AND mp.negative_inv_receipt_code = 1
AND msibk.organization_id = cila.organization_id
AND csi.organization_id = cila.organization_id
AND csi.secondary_inventory_name = cila.subinventory_code
AND csi.condition_type = 'G'
AND msibk.mtl_transactions_enabled_flag = 'Y'
AND msibk.recovered_part_disp_code = fl.lookup_code(+)
AND fl.lookup_type(+) = 'CSP_RECOVERED_PART_DISP_CODE'
AND DECODE (:6,
'NO_CTBT', cbtc.billing_type,
ctbt.billing_type
) = cbtc.billing_type
AND cbtc.billing_category = 'M'
AND cbtc.billing_type = msibk.material_billable_flag
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (msibk.start_date_active,
SYSDATE ) )
AND TRUNC (NVL (msibk.end_date_active, SYSDATE) )
AND NOT EXISTS (
SELECT 'x'
FROM mtl_onhand_quantities_detail moqd
WHERE moqd.organization_id = msibk.organization_id
AND moqd.inventory_item_id = msibk.inventory_item_id
AND moqd.subinventory_code = cila.subinventory_code)
ORDER BY item_number) qrslt,
c_csd_global_temp_sbom_items sbom
WHERE qrslt.resource_type = :7
AND qrslt.resource_id = :8
AND qrslt.organization_id IN (418)
AND qrslt.csp_inv_loc_assignment_id IN (10060)
AND qrslt.transaction_type_id = :9
AND qrslt.update_ib_flag = DECODE (:10, 'N', 'N', qrslt.update_ib_flag )
AND qrslt.organization_id = sbom.organization_id
AND qrslt.inventory_item_id = sbom.component_item_id) qrslt
WHERE ((UPPER (item_number) LIKE UPPER (:11)))	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	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:2978)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)