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)

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 Business Intelligence Publisher Stuck
    via by user13333117,
  • db:: 5.06::error exception unknown 3d
    via by Unknown author,
  • db:: 5.33::JUnit Help Please. sc
    via by Unknown author,
  • Session and Cache
    via by 391981,
  • Advanced Tutorial
    via by 393488,
    • 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.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:305) at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:613) at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:467)
    No Bugmate found.