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 2712224, 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 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 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 646534, 1 year ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.IllegalAccessError, msg=oracle/jdbc/driver/OracleCallableStatement
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') ASREVIEW_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) info2FROM 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 FCWHERE prl.requisition_header_id = :2AND prl.requisition_header_id = prh.requisition_header_idAND 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_idAND 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_idAND muom.unit_of_measure(+) = prl.unit_meas_lookup_codeAND lkup.lookup_type(+) ='ICX_POR_CONTRACTOR_STATUS'AND lkup.lookup_code(+) = prl.contractor_statusAND lkup.language(+) = :3AND fc.currency_code = :6AND (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 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:783) at oracle.apps.icx.por.wf.webui.ReqLinesNotificationsCO.processRequest(ReqLinesNotificationsCO.java:164) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1386) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2883) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2060) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:582) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:470) at _pages.__oa._jspService(__oa.java:233) at weblogic.servlet.jsp.JspBase.service(JspBase.java:34) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184) at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526) at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253) at weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159) at _pages.__oa._jspService(__oa.java:246) at weblogic.servlet.jsp.JspBase.service(JspBase.java:34) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138) at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)