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

orafaq.com | 5 months ago
  1. 0

    OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Getting unexpected error when clicking View Select Button in HR Views

    orafaq.com | 5 months ago
    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
  2. 0

    Thalai Muthu Oracle Apps DBA: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.;

    blogspot.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.;
  3. 0

    Oracle Apps Technology: oracle.apps.fnd.framework.OAException

    blogspot.com | 3 months ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/fnd/framework/navigate/webui/HomePG;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    FND_USER表encrypted_user_password为INVALID表示什么?_remen-ChinaUnix博客

    chinaunix.net | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException; (Could not lookup message because there is no database connection)
  6. 0

    Oracle Apps Technology: May 2008

    blogspot.com | 3 months ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/fnd/framework/navigate/webui/HomePG;

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:603)
      3. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      9. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      14. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
      15. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      18. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      19. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      20. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      23. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      24. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      25. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      26. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2335)
      27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1734)
      28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
      29. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
      29 frames
    3. _oa__html
      _OA._jspService
      1. _oa__html._OA._jspService(_OA.java:85)
      1 frame
    4. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    5. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    6. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    8. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame