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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web1695

  • via Oracle Community by AlkaT., 11 months ago
    (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
  • via Oracle Community by 2712224, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT prl.requisition_header_id, prl.requisition_line_id, prl.line_num AS LINE, msi.concatenated_segments AS ITEM_NUMBER, prl.item_revision
  • via Oracle Community by Bipin Behari Sethy, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE
  • Stack trace

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

    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 user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates