Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by user10185501, 1 year 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 user554920, 1 year 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, 1 year 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 2712224, 1 year ago
, 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
via Oracle Community by Gaurav Bhardwaj, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NVL(paa.date_start,paa.date_projected_start) start_date ,NVL(paa.date_end,paa.date_projected_end) end_date ,paattl.name absence_type
via Oracle Community by 837397, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT OPMTL.ORG_PAYMENT_METHOD_NAME , OPM.ORG_PAYMENT_METHOD_ID , OPM.CURRENCY_CODE , OPM.DEFINED_BALANCE_ID , PTTL.PAYMENT_TYPE_NAME
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)