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 AlkaT., 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT quotelineeo.quote_line_id ,quotelineeo.quote_header_id ,quotelineeo.org_id ,quotelineeo.item_type_code
via Oracle Community by sreese, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select customer_name from ra_customers rc, ra_addresses_all raa where rownum < 2 and rc.customer_id = raa.customer_id and raa.attribute1 = :1
via Oracle Community by 452203, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select Header_id,Line_id from oe_order_lines_all where header_id = NVL(:1,1134)
via Oracle Community by 543071, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select EmpEO.EMPNO, EmpEO.ENAME, EmpEO.JOB, EmpEO.DEPTNO from EMP EmpEO
via Oracle Community by 543071, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select EmpEO.EMPNO, EmpEO.ENAME, EmpEO.JOB, EmpEO.DEPTNO from EMP EmpEO
via Oracle Community by 818948, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT GANTT_VIEW_ID ,NAME FROM PA_GANTT_VIEWS_VL where ENABLE_FLAG ='Y' and GANTT_VIEW_USAGE = ?
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT quotelineeo.quote_line_id
,quotelineeo.quote_header_id
,quotelineeo.org_id
,quotelineeo.item_type_code
,aso_line_num_int.ASO_QUOTE_LINE_NUMBER(p_quote_line_id => quotelineeo.quote_line_id
,p_item_type_code => quotelineeo.item_type_code
,p_serviceable_product_flag => quotelineeo.serviceable_product_flag
,p_service_item_flag => quotelineeo.service_item_flag
,p_service_ref_type_code => qte_line_det.service_ref_type_code
,p_config_header_id => qte_line_det.config_header_id
,p_config_revision_num => qte_line_det.config_revision_num) ui_line_number
,quotelineeo.organization_id
,quotelineeo.inventory_item_id
,quotelineeo.quantity
,quotelineeo.uom_code
,quotelineeo.currency_code
,quote_rollups.tot_list_prc line_list_price--round((quotelineeo.line_list_price * quotelineeo.quantity), 2) line_list_price
,round(quotelineeo.line_adjusted_amount, 2) line_adjusted_amount
,round(quotelineeo.line_adjusted_percent, 2) line_adjusted_percent
,quote_rollups.tot_sell_prc line_quote_price--round(quotelineeo.line_quote_price, 2) line_quote_price
,nvl(to_number(quotelineeo.attribute10)
,DECODE(items.ITEM_TYPE,'ATO'
,(SELECT SUM(nvl(cicd.item_cost, 0))
FROM cst_item_cost_details_v cicd
WHERE quotelineeo.inventory_item_id = cicd.inventory_item_id
AND NVL(quotelineeo.attribute11, 284) = cicd.organization_id
AND cicd.cost_type_id = 1
AND cicd.resource_id IN (28, 29))
,'PTO'
,NULL
,(SELECT to_char(round(nvl(cic.item_cost, 0), 2))
FROM cst_item_costs cic
WHERE cic.inventory_item_id = quotelineeo.inventory_item_id
AND cic.organization_id = nvl(quotelineeo.attribute11, 284)
AND cic.cost_type_id = 1))) att10_cost
,quotelineeo.attribute10
,quotelineeo.attribute11
,quotelineeo.attribute12
,quotelineeo.attribute13
,quotelineeo.attribute14
,quotelineeo.attribute15
,qte_line_det.ref_type_code
,qte_line_det.ref_line_id
,qte_line_det.top_model_line_id
,qte_line_det.ato_line_id
,items.concatenated_segments inventory_item
,items.description item_description
,items.long_description long_description
,round((quotelineeo.line_adjusted_amount * quotelineeo.quantity), 2) extended_adjusted_amount
,round((quotelineeo.line_list_price * quotelineeo.quantity), 2) extended_list_price
,round((quotelineeo.line_quote_price * quotelineeo.quantity), 2) extended_selling_price
,(CASE
WHEN (quotelineeo.item_type_code = 'MDL' AND
qte_line_det.complete_configuration_flag IS NOT NULL AND
nvl(items.config_model_type, 'XX') <> 'N') THEN
'TOTAL'
ELSE
'NOTOTAL'
END) description_switcher
,(CASE
WHEN (quotelineeo.item_type_code = 'MDL' AND
qte_line_det.complete_configuration_flag IS NOT NULL AND
nvl(items.config_model_type, 'XX') <> 'N') THEN
round(aso_quote_pub_w.get_model_rollup_quote_price(quotelineeo.quote_line_id), 2)
ELSE
0
END) rollup_price
,round((quotelineeo.quantity * quote_rollups.tot_sell_prc), 2) line_total_price
,decode(nvl(quotelineeo.line_list_price, 0), 0, 'A', 'P') line_discount_flag
--,NULL ui_line_number
,cat_lok.meaning line_category
,0 line_discount
,ottt.NAME line_type
,'LN_DET_IMAGE' line_det_image_switcher
,muv.UNIT_OF_MEASURE
--,to_char(round(nvl(cic.item_cost, 0), 2)) item_cost
,decode(item_type_code, 'MDL', 'ORG_UPDATE', 'STD', 'ORG_UPDATE', 'ORG_READONLY') org_switcher
,nvl(quotelineeo.attribute11, nvl(cic.organization_id, 284)) cost_org_id
,0 margin
,0 margin_percent
,decode((SELECT 'x'
FROM aso_quote_line_details
WHERE ref_line_id = quotelineeo.quote_line_id
AND rownum < 2)
,NULL
,'FALSE'
,'TRUE') leaf_node_yn
,DECODE(items.ITEM_TYPE, 'ATO', 'SHOWCOST', 'PTO', 'SHOWCOST', 'AOC', 'SHOWCOST', DECODE(quotelineeo.attribute10, NULL, 'UPDCOST', 0, 'UPDCOST', 'SHOWCOST')) item_cost_switcher
,'SHOWTYPE' adj_type_switcher
,'SHOWAMT' adj_amt_switcher
,'SHOWPER' adj_per_switcher
,'SHOWSP' selling_price_switcher
,'SHOWLP' list_price_switcher
,'SHOWMARGIN' margin_switcher
,'SHOWMARGINPER' margin_per_switcher
,'SHOWTOTAL' total_price_switcher
,qte_line_det.service_ref_type_code
,quotelineeo.serviceable_product_flag
,quotelineeo.service_item_flag
,NVL((SELECT SUM(quoteline.line_quote_price*quoteline.quantity)
FROM aso_quote_lines_all quoteline
,aso_quote_line_details quotedetail
WHERE quoteline.quote_line_id = quotedetail.quote_line_id
AND quotedetail.ref_line_id = quotelineeo.quote_line_id), (quotelineeo.line_quote_price*quotelineeo.quantity)) total_price
,SYSDATE creation_date
,fnd_global.USER_ID created_by
,SYSDATE last_update_date
,fnd_global.USER_ID last_updated_by
,fnd_global.LOGIN_ID last_update_login
,/*(SELECT SUM(NVL(to_number(qotline.attribute10), 0))
FROM aso_quote_lines_all qotline
,aso_quote_line_details qotdet
WHERE qotdet.ref_line_id = quotelineeo.quote_line_id
AND qotline.quote_line_id = qotdet.quote_line_id) rollup_cost--*/quote_rollups.tot_cost rollup_cost
FROM aso_oa_quote_lines_all_v quotelineeo
,aso_quote_line_details qte_line_det
,mtl_system_items_vl items
,mtl_units_of_measure_vl muv
,oe_transaction_types_tl ottt
,fnd_lookup_values cat_lok
,cst_item_costs cic
,cst_cost_types cct
,aso_quote_headers_all qoh
,(SELECT ql.quote_header_id
,ql.quote_line_id
,ref_line_id
,SUM(NVL(to_number(ql.attribute10), 0)) tot_cost
,SUM(NVL(ql.line_list_price, 0)) tot_list_prc
,SUM(NVL(ql.line_quote_price, 0)) tot_sell_prc
,GROUPING(ql.quote_line_id) AS qlid
,GROUPING(qld.ref_line_id) AS refid
FROM aso_oa_quote_lines_all_v ql
,aso_quote_line_details qld
WHERE ql.quote_line_id = qld.quote_line_id(+)
AND ql.quote_header_id = 120318
AND (NOT regexp_like(ql.attribute10,'[^0-9.]+') OR ql.attribute10 IS NULL)
GROUP BY CUBE (ql.quote_header_id, ql.quote_line_id, qld.ref_line_id)) quote_rollups
WHERE quotelineeo.quote_header_id = :1
AND quotelineeo.quote_line_id = qte_line_det.quote_line_id(+)
AND quotelineeo.inventory_item_id = items.inventory_item_id
AND quotelineeo.organization_id = items.organization_id
AND quotelineeo.line_category_code = cat_lok.lookup_code(+)
AND quotelineeo.uom_code = muv.uom_code
AND cat_lok.lookup_type(+) = 'LINE_CATEGORY'
AND cat_lok.LANGUAGE(+) = userenv('LANG')
AND quotelineeo.order_line_type_id = ottt.transaction_type_id(+)
AND ottt.LANGUAGE(+) = userenv('LANG')
AND cic.inventory_item_id(+) = quotelineeo.inventory_item_id
AND cic.cost_type_id(+) = 1 --default cost type
AND cic.organization_id(+) = nvl(quotelineeo.attribute11, 284) --quotelineeo.organization_id
AND cct.cost_type_id(+) = cic.cost_type_id
AND quotelineeo.quote_header_id = qoh.quote_header_id
AND ((items.ITEM_TYPE NOT IN ('PTO', 'ATO', 'AOC')
AND quote_rollups.quote_header_id = quotelineeo.quote_header_id
AND quote_rollups.quote_line_id = quotelineeo.quote_line_id
AND quote_rollups.ref_line_id IS NULL
AND quote_rollups.refid = 1)
OR(items.ITEM_TYPE IN ('ATO', 'AOC')
AND quote_rollups.quote_header_id = quotelineeo.quote_header_id
AND quote_rollups.ref_line_id = quotelineeo.quote_line_id
AND quote_rollups.quote_line_id IS NULL
AND quote_rollups.refid = 0)
OR(items.ITEM_TYPE = 'PTO'
AND quote_rollups.quote_header_id = quotelineeo.quote_header_id
AND quote_rollups.ref_line_id IS NULL
AND quote_rollups.qlid = 1
AND quote_rollups.refid = 1))
ORDER BY LINE_NUMBER) QRSLT WHERE REF_LINE_ID = :1	at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)