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 orafaq.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select pa.address_id ,pa.primary_flag ,pa.address_type ,pa.style ,pa.address_line1 ,pa.address_line2
via Oracle Community by user635152, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NOTIFICATION_ID , COMPANY , PAYGROUP , SOURCE , INITIATOR , SUPPLIER_NAME , TRX_DATE FROM LMG_NOTIFICATION_V WHERE COMPANY = NVL(:1,COMPANY) AND INITIATOR = NVL(:2,INITIATOR) AND PAYGROUP = NVL(:3,PAYGROUP) AND SOURCE = NVL(:4,SOURCE) AND SUPPLIER_NAME = NVL(:4,SUPPLIER_NAME)
via Oracle Community by Srini-999, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PCE.COMPETENCE_ELEMENT_ID, PCE.BUSINESS_GROUP_ID, PCE.COMPETENCE_ID, PCE.PROFICIENCY_LEVEL_ID, PCE.HIGH_PROFICIENCY_LEVEL_ID, PCE.WEIGHTING_LEVEL_ID
via Oracle Community by Praveen.oatc, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select rowid ,null select_checkbox ,resource_name person ,resource_id resource_id ,person_id person_id ,to_char(optional_competence_match
via Oracle Community by 964558, 1 year ago
oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 23 with java object of type java.lang.String due to java.sql.SQLException.
via Oracle Community by binny2106, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT lookup_code, meaning, view_application_id, lookup_type FROM fnd_lookup_values WHERE trunc(nvl(start_date_active, sysdate)) <= trunc
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (select   pa.address_id
        ,pa.primary_flag
        ,pa.address_type
        ,pa.style
        ,pa.address_line1
        ,pa.address_line2
        ,pa.address_line3
        ,pa.country
        ,pa.postal_code
        ,pa.region_1
        ,pa.region_2
        ,pa.region_3
        ,pa.town_or_city
        ,pa.object_version_number  primary_address_ovn
        ,h1.meaning                primary_flag_meaning
        ,h2.meaning                address_type_meaning
        ,pa.date_from
        ,pa.date_to
        ,pa.person_id
        ,pa.addr_attribute_category
        ,pa.addr_attribute1
        ,pa.addr_attribute2
        ,pa.addr_attribute3
        ,pa.addr_attribute4
        ,pa.addr_attribute5
        ,pa.addr_attribute6
        ,pa.addr_attribute7
        ,pa.addr_attribute8
        ,pa.addr_attribute9
        ,pa.addr_attribute10
        ,pa.addr_attribute11
        ,pa.addr_attribute12
        ,pa.addr_attribute13
        ,pa.addr_attribute14
        ,pa.addr_attribute15
        ,pa.addr_attribute16
        ,pa.addr_attribute17
        ,pa.addr_attribute18
        ,pa.addr_attribute19
        ,pa.addr_attribute20
        ,pa.add_information17  
        ,pa.add_information18  
        ,pa.add_information19  
        ,pa.add_information20
        ,pa.telephone_number_1
        ,pa.telephone_number_2
        ,pa.telephone_number_3
        ,pa.date_to+1 check_end_date  
        ,to_char(null) user_action
        ,ft.territory_short_name country_meaning
        ,pa.add_information16
        ,pa.add_information13
        ,pa.add_information14
        ,pa.add_information15
from     per_addresses    pa
        ,hr_lookups       h1
        ,hr_lookups       h2
       ,fnd_territories_vl  ft 
where    pa.person_id = :1
and      :2 between pa.date_from
         and nvl(pa.date_to, :3)
and      pa.primary_flag = :4
and      pa.primary_flag = h1.lookup_code
and      h1.lookup_type = 'YES_NO'
and      nvl(pa.address_type, '$Sys_Def$') = h2.lookup_code (+)
and      h2.lookup_type (+) = 'ADDRESS_TYPE'
and      pa.country = ft.territory_code) QRSLT  ORDER BY address_id	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:603)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2335)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1734)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)	at _oa__html._OA._jspService(_OA.java:85)	at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)	at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)	at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)	at oracle.jsp.JspServlet.internalService(JspServlet.java:186)	at oracle.jsp.JspServlet.service(JspServlet.java:156)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)	at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)	at org.apache.jserv.JServConnection.run(JServConnection.java:294)	at java.lang.Thread.run(Thread.java:595)