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

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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.