Home » Developer & Programmer » Forms » report generation shows ora00942-table or view does not exist (OS HPUNIX ,forms and report6i)
report generation shows ora00942-table or view does not exist [message #310836] Wed, 02 April 2008 10:07 Go to next message
riazudeens@hcl.in
Messages: 5
Registered: March 2008
Junior Member
hi
while generating reports from forms 6i ,it shows popup menu title as Report Builder and in the content it is showing ora00942-table or view does not exist .Can u pls provide solution.

[Updated on: Wed, 02 April 2008 10:21]

Report message to a moderator

Re: report generation shows ora00942-table or view does not exist [message #310849 is a reply to message #310836] Wed, 02 April 2008 11:13 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Look like you`re missing table or view that are used in your report. Maybe the object doe not exist or you don`t have grant on it from the user you are connected to compile/execute the report
Re: report generation shows ora00942-table or view does not exist [message #310856 is a reply to message #310849] Wed, 02 April 2008 11:28 Go to previous messageGo to next message
riazudeens@hcl.in
Messages: 5
Registered: March 2008
Junior Member
hi
table or view is not missing as the other users are able to connect and generate the report.
grant is also in place .any other solutions pls



Re: report generation shows ora00942-table or view does not exist [message #310894 is a reply to message #310856] Wed, 02 April 2008 14:18 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
riazudeens@hcl.in
table or view is not missing as the other users are able to connect and generate the report.
If one user sees the table, it doesn't mean that the other one sees it as well.
Quote:
grant is also in place
Can you prove it? Please, copy and paste SQL*Plus session you used to verify this statement.
Previous Topic: cursor
Next Topic: Call a procedure
Goto Forum:
  


Current Time: Tue Dec 06 16:29:07 CST 2016

Total time taken to generate the page: 0.05365 seconds