oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Oracle Apps Technology: May 2008
    via by Unknown author,
  • Forum - For Oracle Apps Customization and Extensions
    via by Unknown author,
    • 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

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    14 more bugmates