1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

JBO-25005: Object name for type View Object is invalid in OAF

Discussion in 'Oracle Apps Technical' started by jagadekara, Mar 10, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    In OAF I Created one Search Page. It is working fine. In that I added one Export Button. Then this error occured. So please help on this....

    Error Page
    Exception Details.
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at _OA._jspService(_OA.java:71)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    at java.lang.Thread.run(Thread.java:595)
    ## Detail 0 ##
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
    at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at _OA._jspService(_OA.java:71)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    at java.lang.Thread.run(Thread.java:595)
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
    at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
    at _OA._jspService(_OA.java:71)
    at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
    at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
    at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    at java.lang.Thread.run(Thread.java:595)
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Got it! I just attach the View Instance to that exportbutton item, Now another error coming...

    java.sql.SQLException: Invalid column type

    For this error just right click on our VO (View Object) and select Edit. Then click on SQL Statement. Here we can see the Binding Style: Oracle Named at bottom. So we need to change that to Oracle Positional and click on Apply. Now save it run again. Then it will solve