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

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

    Automated exception search integrated into your IDE

  5. 0

    Extending ReqLineNotificationVO with New Columns gives Error

    Oracle Community | 5 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
  6. 0

    Custom OAF page runs on PC but errors on Server.

    Oracle Community | 2 years ago | 2736568
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    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(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

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:775)
      6 frames
    3. oracle.apps.icx
      ReqLinesNotificationsCO.processRequest
      1. oracle.apps.icx.por.wf.webui.ReqLinesNotificationsCO.processRequest(ReqLinesNotificationsCO.java:120)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      18. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      22. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      23. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
      24. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      27. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      28. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1295)
      29. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      33. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      34. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
      36. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
      37. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
      38. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:267)
      39. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      40. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2771)
      41. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1991)
      42. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567)
      43. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455)
      43 frames
    5. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:233)
      1 frame
    6. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    7. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      5 frames
    8. oracle.apps.fnd
      WLFilter.doFilter
      1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
      1 frame
    9. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    10. oracle.apps.jtf
      JTFWrapperFilter.doFilter
      1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
      1 frame
    11. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    12. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
      1 frame
    13. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    14. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
      1 frame
    15. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    16. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
      1 frame
    17. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    18. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      5 frames
    19. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    20. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
      1 frame
    21. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3739)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3705)
      3 frames
    22. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    23. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    24. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2282)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2181)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
      3 frames
    25. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      2 frames