java.sql.SQLException

ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput)

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web3

  • via Unknown by user13333117,
  • via Unknown by 641812,
  • Stack trace

    • java.sql.SQLException: ORA-00942: table or view does not exi st Error Code: 942 Call: SELECT t0.OUTPUT_ID, t0.MESSAGE, t0.DELETED, t0.STATUS, t0.DOCUMENT_DATA_A VAILABLE, t0.STATUS_DETAIL, t0.DOCUMENT_DATA_CONTENT_TYPE, t0.XML_DATA, t0.CREAT ED, t0.XML_DATA_AVAILABLE, t0.DOCUMENT_DATA_COMPRESSED, t0.XML_DATA_COMPRESSED, t0.DOCUMENT_DATA, t0.XML_DATA_CONTENT_TYPE, t0.LAST_UPDATED, t0.JOB_ID FROM XMLP _SCHED_OUTPUT t0 WHERE ((t0.DELETED = 'N') AND EXISTS (SELECT t1.SUBSCRIPTION_ID FROM XMLP_SCHED_JOB t3, XMLP_SCHED_JOB t2, XMLP_SCHED_SUBSCRIPTION t1 WHERE ((( t1.SUBSCRIBER = '025_teller01') AND (t2.JOB_ID = t3.JOB_ID)) AND ((t2.JOB_ID = t 1.JOB_ID) AND (t3.JOB_ID = t0.JOB_ID)))) ) ORDER BY t0.CREATED DESC Query: ReadAllQuery(oracle.apps.xdo.servlet.scheduler.toplink.XmlpSchedOutput) at oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.queryOutput(ToplinkDataHandler.java:2128) at oracle.apps.xdo.servlet.scheduler.toplink.ToplinkDataHandler.getOutput(ToplinkDataHandler.java:1724) at oracle.apps.xdo.servlet.ui.scheduler.HistoryTableUtil.getHistoryTableData(HistoryTableUtil.java:133) at oracle.apps.xdo.servlet.ui.scheduler.HistoryTableUtil.getHistoryTable(HistoryTableUtil.java:514) at oracle.apps.xdo.servlet.ui.scheduler.MyHistoryServlet.doPost(MyHistoryServlet.java:243) at oracle.apps.xdo.servlet.ui.scheduler.MyHistoryServlet.doGet(MyHistoryServlet.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:86) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110) 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:619)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    We couldn't find other users who have seen this exception.