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 1498181, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE
via Oracle Community by fred.jiang, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE
via Oracle Community by Mohammed Abdul Muqeet, 1 year ago
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.HR_PERF_MGMT_PLAN_INTERNAL", line 4828 ORA-06512: at "APPS.HR_PERF_MGMT_PLAN_INTERNAL", line 3617 ORA-06512: at line 1 ORA-06510 ORA-06512
via Oracle Community by sseth29, 1 year ago
oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 37 with java object of type java.lang.String due to java.sql.SQLException.
via Oracle Community by 878608, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition santos.oracle.apps.icx.icatalog.shopping.server.SantosAllSourcesVO of type View Definition not found
via Oracle Community by user5425941, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition xxsan.oracle.apps.icx.icatalog.shopping.server.xxSanAllSourcesVO of type View Definition not found
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID,
PoSystemParameterEO.ORG_ID,
PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE,
PoSystemParameterEO.REQ_CAN_AUTHORIZE,
PoSystemParameterEO.INSPECTION_REQUIRED_FLAG,
PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE,
PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE,
PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE,
PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE,
PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE,
PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE,
PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE,
PoSystemParameterEO.USER_DEFINED_PO_NUM_CODE,
PoSystemParameterEO.MANUAL_PO_NUM_TYPE,
PoSystemParameterEO.USER_DEFINED_REQ_NUM_CODE,
PoSystemParameterEO.MANUAL_REQ_NUM_TYPE,
PoSystemParameterEO.DEFAULT_QUOTE_WARNING_DELAY,
PoSystemParameterEO.ENFORCE_BUYER_AUTHORITY_FLAG,
PoSystemParameterEO.ENFORCE_BUYER_NAME_FLAG,
PoSystemParameterEO.ENFORCE_VENDOR_HOLD_FLAG,
PoSystemParameterEO.NOTIFY_IF_BLANKET_FLAG,
PoSystemParameterEO.RFQ_REQUIRED_FLAG,
PoSystemParameterEO.PO_DOCUMENT_REPORT_ID,
PoSystemParameterEO.PO_DOCUMENT_PRINT_FLAG,
PoSystemParameterEO.RFQ_DOCUMENT_REPORT_ID,
PoSystemParameterEO.RFQ_DOCUMENT_PRINT_FLAG,
PoSystemParameterEO.LINE_TYPE_ID,
PoSystemParameterEO.RECEIVING_FLAG,
PoSystemParameterEO.ALLOW_ITEM_DESC_UPDATE_FLAG,
PoSystemParameterEO.DISPOSITION_WARNING_FLAG,
PoSystemParameterEO.ENFORCE_FULL_LOT_QUANTITIES,
PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID,        PoSystemParameterEO.MIN_RELEASE_AMOUNT,
PoSystemParameterEO.PRICE_TYPE_LOOKUP_CODE,
PoSystemParameterEO.NOTIFICATION_WARNING_DELAY,
PoSystemParameterEO.PRICE_BREAK_LOOKUP_CODE,
PoSystemParameterEO.INVOICE_CLOSE_CODE,
PoSystemParameterEO.RECEIVE_CLOSE_CODE,
PoSystemParameterEO.INVOICE_CLOSE_TOLERANCE,
PoSystemParameterEO.RECEIVE_CLOSE_TOLERANCE,
PoSystemParameterEO.CANCEL_REQS_ON_PO_CANCEL_FLAG,
PoSystemParameterEO.REQIMPORT_GROUP_BY_CODE,
PoSystemParameterEO.EXPENSE_ACCRUAL_CODE,
PoSystemParameterEO.INVENTORY_ACCRUAL_CODE,
PoSystemParameterEO.ORDER_TYPE_ID,
PoSystemParameterEO.ORDER_SOURCE_ID,
PoSystemParameterEO.SALESREP_ID,
PoSystemParameterEO.TERM_ID,
PoSystemParameterEO.NEXT_APPROVER_LOOKUP_CODE,
PoSystemParameterEO.GLOBAL_ATTRIBUTE1,
PoSystemParameterEO.GLOBAL_ATTRIBUTE2,
PoSystemParameterEO.GLOBAL_ATTRIBUTE3,
PoSystemParameterEO.GLOBAL_ATTRIBUTE4,
PoSystemParameterEO.GLOBAL_ATTRIBUTE5,
PoSystemParameterEO.GLOBAL_ATTRIBUTE6,
PoSystemParameterEO.GLOBAL_ATTRIBUTE7,
PoSystemParameterEO.GLOBAL_ATTRIBUTE8,
PoSystemParameterEO.GLOBAL_ATTRIBUTE9,
PoSystemParameterEO.GLOBAL_ATTRIBUTE10,
PoSystemParameterEO.GLOBAL_ATTRIBUTE11,
PoSystemParameterEO.GLOBAL_ATTRIBUTE12,
PoSystemParameterEO.GLOBAL_ATTRIBUTE13,
PoSystemParameterEO.GLOBAL_ATTRIBUTE14,
PoSystemParameterEO.GLOBAL_ATTRIBUTE15,
PoSystemParameterEO.GLOBAL_ATTRIBUTE16,
PoSystemParameterEO.GLOBAL_ATTRIBUTE17,
PoSystemParameterEO.GLOBAL_ATTRIBUTE18,
PoSystemParameterEO.GLOBAL_ATTRIBUTE19,
PoSystemParameterEO.GLOBAL_ATTRIBUTE20,
PoSystemParameterEO.GLOBAL_ATTRIBUTE_CATEGORY,
PoSystemParameterEO.ENFORCE_PRICE_CHANGE_AMOUNT,        PoSystemParameterEO.PRICE_CHANGE_AMOUNT,
PoSystemParameterEO.AUTO_OFFSET_METHOD,
PoSystemParameterEO.PO_OUTPUT_FORMAT,
PoSystemParameterEO.BUYING_COMPANY_IDENTIFIER,
PoSystemParameterEO.GAPLESS_INV_NUM_FLAG,
PoSystemParameterEO.MAX_ATTACHMENT_SIZE,
PoSystemParameterEO.EMAIL_ATTACHMENT_FILENAME,
ot.name as order_type,
pltv.line_type,
pps.name as position_structure_name
FROM PO_SYSTEM_PARAMETERS_ALL PoSystemParameterEO,
oe_transaction_types ot, po_line_types_val_v pltv,
per_position_structures pps
where PoSystemParameterEO.org_id = :1
and  PoSystemParameterEO.ORDER_TYPE_ID = ot.transaction_type_id
and  nvl(ot.po_required_flag, 'N') = 'N'
and nvl(ot.agreement_required_flag, 'N') = 'N'
and  PoSystemParameterEO.LINE_TYPE_ID  = pltv.line_type_id
and PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID  = pps.position_structure_id	at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:980)	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)	at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)	at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)	at oracle.apps.po.setup.webui.PurchasingOptionsCO.processRequest(PurchasingOptionsCO.java:141)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:594)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1155)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:962)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:929)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:653)	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:962)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:929)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:653)	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:2490)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1888)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)	at _OA._jspService(_OA.java:216)	at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)	at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)	at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)	at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)	at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)	at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)	at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)	at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)	at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)	at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)	at _RF._jspService(_RF.java:225)	at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)	at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)	at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)	at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)	at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)	at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)	at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)	at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)	at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)	at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)	at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)	at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)	at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)	at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)	at java.lang.Thread.run(Thread.java:595)