oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)

Oracle Community | kkrm333 | 5 years ago
  1. 0

    Unable to logon to iProcurement

    Oracle Community | 5 years ago | kkrm333
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)
  2. 0

    Invalid number error when extended VO from 12.1.3 to 12.2.5

    Oracle Community | 7 months ago | 2712224
    oracle.apps.fnd.framework.OAException: 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, prl.item_description AS DESCRIPTION, por_apprv_wf_util_grp.get_cost_center(prl.requisition_line_id) AS COST_CENTER, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'AMOUNT', NULL, nvl(muom.unit_of_measure_tl, prl.unit_meas_lookup_code)) AS UOM, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'AMOUNT', TO_NUMBER(NULL), prl.quantity) AS QUANTITY, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'AMOUNT', TO_NUMBER(NULL), prl.unit_price) AS UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) AS LINE_AMOUNT, lkup.meaning as contractor_status, PO_POAPPROVAL_INIT1.Get_Formatted_Full_Name(prl.candidate_first_name, prl.candidate_last_name) AS CONTRACTOR_NAME, prl.assignment_start_date AS START_DATE, prl.assignment_end_date AS END_DATE, prl.need_by_date AS NEED_BY, hrt.location_code AS LOCATION, per.full_name AS REQUESTOR, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code,'VENDOR', prl.suggested_vendor_name, org.organization_code ||' - '|| org.organization_name)) AS SUGG_SUPPLIER, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code, 'VENDOR',prl.suggested_vendor_location,'')) AS SUGG_SITE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'AMOUNT', NULL, nvl(prl.currency_code, :1)) AS TXN_CURRENCY_CODE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'AMOUNT', TO_NUMBER(NULL), nvl(prl.currency_unit_price, prl.unit_price)) AS CURRENCY_UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', nvl(prl.currency_amount, prl.amount), 'RATE', nvl(prl.currency_amount, prl.amount), prl.quantity * nvl(prl.currency_unit_price, prl.unit_price)) AS CURRENCY_LINE_AMOUNT, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', 0, decode(prl.currency_unit_price, null, 0, 1)) AS CURR_UNIT_PRICE_DISPLAY_FLAG, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', decode(prl.currency_amount, null, 0, 1), decode(prl.currency_unit_price, null, 0, 1)) AS CURR_AMOUNT_DISPLAY_FLAG, prl.amendment_type, prl.amendment_status, prl.line_num_display Line_Num_Display, base.line_num_display Clm_Base_Line_Num, prl.Clm_Option_Num Clm_Option_Num, prl.Clm_Option_To_Date Clm_Option_To_Date, prl.Clm_Option_From_Date Clm_Option_From_Date, prl.Clm_Funded_Flag Clm_Funded_Flag, prl.Clm_Info_Flag Clm_Info_Flag, prl.Contract_Type Contract_Type, prl.Group_Line_Id Group_Line_Id, prl.CLM_PERIOD_PERF_START_DATE Clm_Period_Perf_Start_Date, prl.CLM_PERIOD_PERF_END_DATE Clm_Period_Perf_End_Date, decode(prh.federal_flag, 'Y', 1, 0) IS_CLINSLIN_ENABLED, decode(prh.federal_flag, 'Y', 1, 0) IS_OPTION_ENABLED, decode(prh.federal_flag, 'Y', 0, 1) IS_COMMERCIAL_ENABLED, prl.fund_source_not_known fund_source_not_known, decode(prl.UNIT_PRICE,null,null,To_Char(prl.UNIT_PRICE,fnd_currency.get_format_mask(fc.currency_code,30)) || ' ' || :4) || decode ( prl.CURRENCY_UNIT_PRICE,NULL,NULL, (' (' ||To_Char(prl.CURRENCY_UNIT_PRICE,fnd_currency.get_format_mask(prl.currency_code,30)) || ' ' || prl.currency_code ||')')) AS RATE_CONSOLIDATE, To_Char(Decode(FC.minimum_accountable_unit,NULL, Round(decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price),FC.PRECISION), Round(decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price)/FC.minimum_accountable_unit)*FC.minimum_accountable_unit), fnd_currency.get_format_mask(fc.currency_code,30))||' '|| :5 AS LINE_AMT_CONSOLIDATE, prl.ORDER_TYPE_LOOKUP_CODE, prh.ORG_ID, decode(nvl(to_char(prl.amendment_type), 'NONE'), 'CHANGED', 'ReviewEnabled', 'ReviewDisabled') AS REVIEW_SWITCHER, prh.conformed_header_id, xxehc_pr_wf_notification_pkg.get_cc_code(prl.requisition_header_id,prl.requisition_line_id) cc_code, xxehc_pr_wf_notification_pkg.get_cc_code(prl.requisition_header_id,prl.requisition_line_id) cc_des, xxehc_pr_wf_notification_pkg.get_fund_available(prl.requisition_header_id,prl.requisition_line_id) fund, xxehc_pr_wf_notification_pkg.get_pr_info_1(prl.requisition_header_id,prl.requisition_line_id) info1, xxehc_pr_wf_notification_pkg.get_pr_info_2(prl.requisition_header_id,prl.requisition_line_id) info2 FROM po_requisition_lines_all prl, po_requisition_lines_all base, po_requisition_headers_all prh, mtl_system_items_kfv msi, hr_locations_all hrt, per_all_people_f per, mtl_units_of_measure muom, org_organization_definitions org, fnd_lookup_values lkup, fnd_currencies FC WHERE prl.requisition_header_id = :2 AND prl.requisition_header_id = prh.requisition_header_id AND NVL(prl.cancel_flag,'N') = 'N' AND NVL(prl.modified_by_agent_flag, 'N') = 'N' AND NVL(prl.closed_code, 'OPEN') != 'FINALLY CLOSED' AND hrt.location_id = prl.deliver_to_location_id AND prl.item_id = msi.inventory_item_id(+) AND nvl(prl.destination_organization_id,'-99') = msi.organization_id(+) AND prl.to_person_id = per.person_id(+) AND per.effective_start_date(+) <= trunc(sysdate) AND per.effective_end_date(+) >= trunc(sysdate) AND prl.source_organization_id = org.organization_id AND muom.unit_of_measure(+) = prl.unit_meas_lookup_code AND lkup.lookup_type(+) ='ICX_POR_CONTRACTOR_STATUS' AND lkup.lookup_code(+) = prl.contractor_status AND lkup.language(+) = :3 AND fc.currency_code = :6 AND (prh.revision_num IS NULL OR (prl.AMENDMENT_TYPE IN ('CHANGED','ADDED', 'CANCELLED'))) AND prl.clm_base_line_num = base.requisition_line_id(+) ORDER BY prl.line_num_display, prl.line_num ASC
  3. 0

    Add VO Extension R12.2.4 ReqLinesNotificationsVO Error

    Oracle Community | 2 years ago | user554920
    oracle.apps.fnd.framework.OAException: 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, prl.item_description AS DESCRIPTION, por_apprv_wf_util_grp.get_cost_center(prl.requisition_line_id) AS COST_CENTER, nvl(muom.unit_of_measure_tl, prl.unit_meas_lookup_code) AS UOM, prl.quantity AS QUANTITY, prl.unit_price AS UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) AS LINE_AMOUNT, lkup.meaning as contractor_status, PO_POAPPROVAL_INIT1.Get_Formatted_Full_Name(prl.candidate_first_name, prl.candidate_last_name) AS CONTRACTOR_NAME, prl.assignment_start_date AS START_DATE, prl.assignment_end_date AS END_DATE, prl.need_by_date AS NEED_BY, hrt.location_code AS LOCATION, per.full_name AS REQUESTOR, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code,'VENDOR', prl.suggested_vendor_name, org.organization_code ||' - '|| org.organization_name)) AS SUGG_SUPPLIER, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code, 'VENDOR',prl.suggested_vendor_location,'')) AS SUGG_SITE, nvl(prl.currency_code, :1) AS TXN_CURRENCY_CODE, nvl(prl.currency_unit_price, prl.unit_price) AS CURRENCY_UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', nvl(prl.currency_amount, prl.amount), 'RATE', nvl(prl.currency_amount, prl.amount), prl.quantity * nvl(prl.currency_unit_price, prl.unit_price)) AS CURRENCY_LINE_AMOUNT, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', 0, decode(prl.currency_unit_price, null, 0, 1)) AS CURR_UNIT_PRICE_DISPLAY_FLAG, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', decode(prl.currency_amount, null, 0, 1), decode(prl.currency_unit_price, null, 0, 1)) AS CURR_AMOUNT_DISPLAY_FLAG, prl.amendment_type, prl.amendment_status, prl.line_num_display Line_Num_Display, base.line_num_display Clm_Base_Line_Num, prl.Clm_Option_Num Clm_Option_Num, prl.Clm_Option_To_Date Clm_Option_To_Date, prl.Clm_Option_From_Date Clm_Option_From_Date, prl.Clm_Funded_Flag Clm_Funded_Flag, prl.Clm_Info_Flag Clm_Info_Flag, prl.Contract_Type Contract_Type, prl.Group_Line_Id Group_Line_Id, prl.CLM_PERIOD_PERF_START_DATE Clm_Period_Perf_Start_Date, prl.CLM_PERIOD_PERF_END_DATE Clm_Period_Perf_End_Date, prl.fund_source_not_known fund_source_not_known, prl.BASE_UNIT_PRICE || ' ' || :4 || decode ( prl.CURRENCY_UNIT_PRICE,NULL,NULL, (' (' ||prl.CURRENCY_UNIT_PRICE || ' ' || prl.currency_code ||')')) AS RATE_CONSOLIDATE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) || ' '|| :5 AS LINE_AMT_CONSOLIDATE, xxpo_utilities.GET_ACCOUNT_CODE(prl.requisition_line_id) as POR_DIS_ACC_CODE FROM po_requisition_lines_all prl, po_requisition_lines_all base, po_requisition_headers_all prh, mtl_system_items_kfv msi, hr_locations_all hrt, per_all_people_f per, mtl_units_of_measure muom, org_organization_definitions org, fnd_lookup_values lkup WHERE prl.requisition_header_id = :2 AND prl.requisition_header_id = prh.requisition_header_id AND NVL(prl.cancel_flag,'N') = 'N' AND NVL(prl.modified_by_agent_flag, 'N') = 'N' AND NVL(prl.closed_code, 'OPEN') != 'FINALLY CLOSED' AND hrt.location_id = prl.deliver_to_location_id AND prl.item_id = msi.inventory_item_id(+) AND nvl(msi.organization_id, nvl(prl.destination_organization_id,'-99')) = nvl(prl.destination_organization_id,'-99') AND prl.to_person_id = per.person_id(+) AND per.effective_start_date(+) = trunc(sysdate) AND prl.source_organization_id = org.organization_id AND muom.unit_of_measure(+) = prl.unit_meas_lookup_code AND lkup.lookup_type(+) ='ICX_POR_CONTRACTOR_STATUS' AND lkup.lookup_code(+) = prl.contractor_status AND lkup.language(+) = :3 AND (prh.revision_num IS NULL OR (prl.AMENDMENT_TYPE IN ('CHANGED','ADDED'))) AND prl.clm_base_line_num = base.requisition_line_id(+) ORDER BY prl.line_num_display, prl.line_num ASC
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Add VO Extension R12.2.4 ReqLinesNotificationsVO Error

    Oracle Community | 2 years ago | user554920
    oracle.apps.fnd.framework.OAException: 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, prl.item_description AS DESCRIPTION, por_apprv_wf_util_grp.get_cost_center(prl.requisition_line_id) AS COST_CENTER, nvl(muom.unit_of_measure_tl, prl.unit_meas_lookup_code) AS UOM, prl.quantity AS QUANTITY, prl.unit_price AS UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) AS LINE_AMOUNT, lkup.meaning as contractor_status, PO_POAPPROVAL_INIT1.Get_Formatted_Full_Name(prl.candidate_first_name, prl.candidate_last_name) AS CONTRACTOR_NAME, prl.assignment_start_date AS START_DATE, prl.assignment_end_date AS END_DATE, prl.need_by_date AS NEED_BY, hrt.location_code AS LOCATION, per.full_name AS REQUESTOR, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code,'VENDOR', prl.suggested_vendor_name, org.organization_code ||' - '|| org.organization_name)) AS SUGG_SUPPLIER, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code, 'VENDOR',prl.suggested_vendor_location,'')) AS SUGG_SITE, nvl(prl.currency_code, :1) AS TXN_CURRENCY_CODE, nvl(prl.currency_unit_price, prl.unit_price) AS CURRENCY_UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', nvl(prl.currency_amount, prl.amount), 'RATE', nvl(prl.currency_amount, prl.amount), prl.quantity * nvl(prl.currency_unit_price, prl.unit_price)) AS CURRENCY_LINE_AMOUNT, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', 0, decode(prl.currency_unit_price, null, 0, 1)) AS CURR_UNIT_PRICE_DISPLAY_FLAG, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', decode(prl.currency_amount, null, 0, 1), decode(prl.currency_unit_price, null, 0, 1)) AS CURR_AMOUNT_DISPLAY_FLAG, prl.amendment_type, prl.amendment_status, prl.line_num_display Line_Num_Display, base.line_num_display Clm_Base_Line_Num, prl.Clm_Option_Num Clm_Option_Num, prl.Clm_Option_To_Date Clm_Option_To_Date, prl.Clm_Option_From_Date Clm_Option_From_Date, prl.Clm_Funded_Flag Clm_Funded_Flag, prl.Clm_Info_Flag Clm_Info_Flag, prl.Contract_Type Contract_Type, prl.Group_Line_Id Group_Line_Id, prl.CLM_PERIOD_PERF_START_DATE Clm_Period_Perf_Start_Date, prl.CLM_PERIOD_PERF_END_DATE Clm_Period_Perf_End_Date, prl.fund_source_not_known fund_source_not_known, prl.BASE_UNIT_PRICE || ' ' || :4 || decode ( prl.CURRENCY_UNIT_PRICE,NULL,NULL, (' (' ||prl.CURRENCY_UNIT_PRICE || ' ' || prl.currency_code ||')')) AS RATE_CONSOLIDATE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) || ' '|| :5 AS LINE_AMT_CONSOLIDATE, xxpo_utilities.GET_ACCOUNT_CODE(prl.requisition_line_id) as POR_DIS_ACC_CODE FROM po_requisition_lines_all prl, po_requisition_lines_all base, po_requisition_headers_all prh, mtl_system_items_kfv msi, hr_locations_all hrt, per_all_people_f per, mtl_units_of_measure muom, org_organization_definitions org, fnd_lookup_values lkup WHERE prl.requisition_header_id = :2 AND prl.requisition_header_id = prh.requisition_header_id AND NVL(prl.cancel_flag,'N') = 'N' AND NVL(prl.modified_by_agent_flag, 'N') = 'N' AND NVL(prl.closed_code, 'OPEN') != 'FINALLY CLOSED' AND hrt.location_id = prl.deliver_to_location_id AND prl.item_id = msi.inventory_item_id(+) AND nvl(msi.organization_id, nvl(prl.destination_organization_id,'-99')) = nvl(prl.destination_organization_id,'-99') AND prl.to_person_id = per.person_id(+) AND per.effective_start_date(+) = trunc(sysdate) AND prl.source_organization_id = org.organization_id AND muom.unit_of_measure(+) = prl.unit_meas_lookup_code AND lkup.lookup_type(+) ='ICX_POR_CONTRACTOR_STATUS' AND lkup.lookup_code(+) = prl.contractor_status AND lkup.language(+) = :3 AND (prh.revision_num IS NULL OR (prl.AMENDMENT_TYPE IN ('CHANGED','ADDED'))) AND prl.clm_base_line_num = base.requisition_line_id(+) ORDER BY prl.line_num_display, prl.line_num ASC
  6. 0

    VO EXTENSION IN OAF R12.2.3

    Oracle Community | 1 year ago | Syed Abdul Wahab
    oracle.apps.fnd.framework.OAException: 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, prl.item_description AS DESCRIPTION, por_apprv_wf_util_grp.get_cost_center(prl.requisition_line_id) AS COST_CENTER, nvl(muom.unit_of_measure_tl, prl.unit_meas_lookup_code) AS UOM, prl.quantity AS QUANTITY, prl.unit_price AS UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) AS LINE_AMOUNT, lkup.meaning as contractor_status, PO_POAPPROVAL_INIT1.Get_Formatted_Full_Name(prl.candidate_first_name, prl.candidate_last_name) AS CONTRACTOR_NAME, prl.assignment_start_date AS START_DATE, prl.assignment_end_date AS END_DATE, prl.need_by_date AS NEED_BY, hrt.location_code AS LOCATION, per.full_name AS REQUESTOR, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code,'VENDOR', prl.suggested_vendor_name, org.organization_code ||' - '|| org.organization_name)) AS SUGG_SUPPLIER, decode(nvl(prl.contractor_status, 'NULL'), 'PENDING', fnd_message.get_string('ICX', 'ICX_POR_SEE_DETAILS'), decode(prl.source_type_code, 'VENDOR',prl.suggested_vendor_location,'')) AS SUGG_SITE, nvl(prl.currency_code, :1) AS TXN_CURRENCY_CODE, nvl(prl.currency_unit_price, prl.unit_price) AS CURRENCY_UNIT_PRICE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', nvl(prl.currency_amount, prl.amount), 'RATE', nvl(prl.currency_amount, prl.amount), prl.quantity * nvl(prl.currency_unit_price, prl.unit_price)) AS CURRENCY_LINE_AMOUNT, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', 0, decode(prl.currency_unit_price, null, 0, 1)) AS CURR_UNIT_PRICE_DISPLAY_FLAG, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', decode(prl.currency_amount, null, 0, 1), decode(prl.currency_unit_price, null, 0, 1)) AS CURR_AMOUNT_DISPLAY_FLAG, prl.amendment_type, prl.amendment_status, prl.line_num_display Line_Num_Display, base.line_num_display Clm_Base_Line_Num, prl.Clm_Option_Num Clm_Option_Num, prl.Clm_Option_To_Date Clm_Option_To_Date, prl.Clm_Option_From_Date Clm_Option_From_Date, prl.Clm_Funded_Flag Clm_Funded_Flag, prl.Clm_Info_Flag Clm_Info_Flag, prl.Contract_Type Contract_Type, prl.Group_Line_Id Group_Line_Id, prl.CLM_PERIOD_PERF_START_DATE Clm_Period_Perf_Start_Date, prl.CLM_PERIOD_PERF_END_DATE Clm_Period_Perf_End_Date, prl.fund_source_not_known fund_source_not_known, prl.BASE_UNIT_PRICE || ' ' || :4 || decode ( prl.CURRENCY_UNIT_PRICE,NULL,NULL, (' (' ||prl.CURRENCY_UNIT_PRICE || ' ' || prl.currency_code ||')')) AS RATE_CONSOLIDATE, decode(nvl(prl.order_type_lookup_code, 'QUANTITY'), 'FIXED PRICE', prl.amount, 'RATE', prl.amount, prl.quantity * prl.unit_price) || ' '|| :5 AS LINE_AMT_CONSOLIDATE ,prl.attribute1 test_case_att1,prl.attribute2 test_case_att2 FROM po_requisition_lines_all prl, po_requisition_lines_all base, po_requisition_headers_all prh, mtl_system_items_kfv msi, hr_locations_all hrt, per_all_people_f per, mtl_units_of_measure muom, org_organization_definitions org, fnd_lookup_values lkup WHERE prl.requisition_header_id = :2 AND prl.requisition_header_id = prh.requisition_header_id AND NVL(prl.cancel_flag,'N') = 'N' AND NVL(prl.modified_by_agent_flag, 'N') = 'N' AND NVL(prl.closed_code, 'OPEN') != 'FINALLY CLOSED' AND hrt.location_id = prl.deliver_to_location_id AND prl.item_id = msi.inventory_item_id(+) AND nvl(msi.organization_id, nvl(prl.destination_organization_id,'-99')) = nvl(prl.destination_organization_id,'-99') AND prl.to_person_id = per.person_id(+) AND per.effective_start_date(+) = trunc(sysdate) AND prl.source_organization_id = org.organization_id AND muom.unit_of_measure(+) = prl.unit_meas_lookup_code AND lkup.lookup_type(+) ='ICX_POR_CONTRACTOR_STATUS' AND lkup.lookup_code(+) = prl.contractor_status AND lkup.language(+) = :3 AND (prh.revision_num IS NULL OR (prl.AMENDMENT_TYPE IN ('CHANGED','ADDED'))) AND prl.clm_base_line_num = base.requisition_line_id(+) ORDER BY prl.line_num_display, prl.line_num ASC

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)

      at com.orionserver.http.OrionHttpJspPage.service()
    2. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    3. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    5. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    6. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    7. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    8. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    9. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    10. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    11. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame