Exception 300 (): table or view does not exist

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:


Checking again the first files rwEng-0.trc from the zip Reports Upload1
======================================================
Error 1
=========
[2011/1/24 10:4:31:692] (rwfdt:rwfdtgcf_GenCachefile) Cache file is D:\oracle\FR_AS\reports\cache\FN_R7011597774.pdf
..
...
[2011/1/24 10:4:31:723] Error 50103 (C Engine): 10:04:31 ERR ORA-00942: table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtprint): 10:04:31 ERR Error occurred sending Job output to cache
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): running
[2011/1/24 10:4:31:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): quit
[2011/1/24 10:4:31:739] Debug 50103 (EngineImpl:run): CRunReport returns: 300
[2011/1/24 10:4:31:754] Debug 50103 (EngineImpl:run): Quit
[2011/1/24 10:4:31:754] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

Error 2
===========
[2011/1/24 10:4:38:692] Error 50103 (rwfdt:rwfdtgcf_GenCachefile): Cache file is D:\oracle\FR_AS\reports\cache\FN_R7021055655.pdf
...

[2011/1/24 10:4:38:723] Error 50103 (C Engine): 10:04:38 ERR ORA-00942: table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtprint): 10:04:38 ERR Error occurred sending Job output to cache
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): running
[2011/1/24 10:4:38:723] Error 50103 (rwfdt:rwfdtfl_FreeDistList): quit
[2011/1/24 10:4:38:739] Debug 50103 (EngineImpl:run): CRunReport returns: 300
[2011/1/24 10:4:38:739] Debug 50103 (EngineImpl:run): Quit
[2011/1/24 10:4:38:739] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)

Error 3
==========
2011/1/24 10:5:15:5] Exception 300 (): table or view does not exist
FROM ==> FN_PAY_FINANCE_MASTER

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:447)
at oracle.reports.engine._EngineClassImplBase._invoke(_EngineClassImplBase.java:90)
at com.sun.corba.se.internal.corba.ServerDelegate.dispatch(ServerDelegate.java:353)
at com.sun.corba.se.internal.iiop.ORB.process(ORB.java:280)
at com.sun.corba.se.internal.iiop.RequestProcessor.process(RequestProcessor.java:81)
at com.sun.corba.se.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:106)




Solution
Confirmed that the problem was a database permission issue.




1. Open your RDF file and verify which table will be used.
2. Now verify if your application user has the permission to select the table.
(For instance use SQL * Plus session to login to the database and try to execute a select statement with the same application user that will be used when you start Forms or Reports)

Get Oracle Certifications for all Exams
Free Online Exams.com