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 (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 (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, plc.meaning AS DESTINATION_TYPE, XXX_APPR_NOTIF_VO_PKG.GET_REQ_HDR_DFF_PROMT (prl.requisition_header_id, prl.org_id) AS HDR_PROMPT, XXX_APPR_NOTIF_VO_PKG.GET_REQ_HDR_DFF_VALUE (prl.requisition_header_id, prl.org_id) AS HDR_DFF, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 1) AS HDR_DFF1, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 2) AS HDR_DFF2, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 3) AS HDR_DFF3, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 4) AS HDR_DFF4, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 5) AS HDR_DFF5 FROM po_requisition_lines_all prl, 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_lookup_values plc WHERE prl.requisition_header_id = :2 AND NVL (prl.cancel_flag, 'N') = 'N' AND NVL (prl.modified_by_agent_flag, 'N') = 'N' AND NVL (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, prl.destination_organization_id) = prl.destination_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 plc.lookup_type(+) = 'DESTINATION TYPE' AND plc.lookup_code(+) = prl.destination_type_code ORDER BY prl.line_num

Oracle Community | user10185501 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Extending ReqLineNotificationVO with New Columns gives Error

    Oracle Community | 6 years ago | user10185501
    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 (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 (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, plc.meaning AS DESTINATION_TYPE, XXX_APPR_NOTIF_VO_PKG.GET_REQ_HDR_DFF_PROMT (prl.requisition_header_id, prl.org_id) AS HDR_PROMPT, XXX_APPR_NOTIF_VO_PKG.GET_REQ_HDR_DFF_VALUE (prl.requisition_header_id, prl.org_id) AS HDR_DFF, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 1) AS HDR_DFF1, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 2) AS HDR_DFF2, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 3) AS HDR_DFF3, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 4) AS HDR_DFF4, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 5) AS HDR_DFF5 FROM po_requisition_lines_all prl, 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_lookup_values plc WHERE prl.requisition_header_id = :2 AND NVL (prl.cancel_flag, 'N') = 'N' AND NVL (prl.modified_by_agent_flag, 'N') = 'N' AND NVL (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, prl.destination_organization_id) = prl.destination_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 plc.lookup_type(+) = 'DESTINATION TYPE' AND plc.lookup_code(+) = prl.destination_type_code ORDER BY prl.line_num
  2. 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
  3. 0

    VO EXTENSION IN OAF R12.2.3

    Oracle Community | 2 years 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid number error when extended VO from 12.1.3 to 12.2.5

    Oracle Community | 10 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

    2 unregistered visitors
    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 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 (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 (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, plc.meaning AS DESTINATION_TYPE, XXX_APPR_NOTIF_VO_PKG.GET_REQ_HDR_DFF_PROMT (prl.requisition_header_id, prl.org_id) AS HDR_PROMPT, XXX_APPR_NOTIF_VO_PKG.GET_REQ_HDR_DFF_VALUE (prl.requisition_header_id, prl.org_id) AS HDR_DFF, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 1) AS HDR_DFF1, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 2) AS HDR_DFF2, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 3) AS HDR_DFF3, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 4) AS HDR_DFF4, XXX_APPR_NOTIF_VO_PKG.get_req_hdr_dff_value_seq (prl.requisition_header_id, prl.org_id, 5) AS HDR_DFF5 FROM po_requisition_lines_all prl, 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_lookup_values plc WHERE prl.requisition_header_id = :2 AND NVL (prl.cancel_flag, 'N') = 'N' AND NVL (prl.modified_by_agent_flag, 'N') = 'N' AND NVL (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, prl.destination_organization_id) = prl.destination_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 plc.lookup_type(+) = 'DESTINATION TYPE' AND plc.lookup_code(+) = prl.destination_type_code ORDER BY prl.line_num

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:765)
      6 frames
    3. oracle.apps.icx
      ReqLinesNotificationsCO.processRequest
      1. oracle.apps.icx.por.wf.webui.ReqLinesNotificationsCO.processRequest(ReqLinesNotificationsCO.java:84)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      18. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      22. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      23. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      24. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      27. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      28. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
      29. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      33. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      34. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      36. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      37. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      38. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      39. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      40. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513)
      41. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894)
      42. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
      43. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)
      43 frames