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

Samebug tips0

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

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

Solutions on the web1257

  • via Oracle Community by user10185501, 11 months ago
    , 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
  • via Oracle Community by user554920, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT prl.requisition_header_id, prl.requisition_line_id, prl.line_num AS LINE, msi.concatenated_segments AS ITEM_NUMBER, prl.item_revision
  • via Oracle Community by Syed Abdul Wahab, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT prl.requisition_header_id, prl.requisition_line_id, prl.line_num AS LINE, msi.concatenated_segments AS ITEM_NUMBER, prl.item_revision
  • Stack trace

    • 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(OAException.java:896) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:765) at oracle.apps.icx.por.wf.webui.ReqLinesNotificationsCO.processRequest(ReqLinesNotificationsCO.java:84) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    10 more bugmates