Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute.

Hi , I am using OBIEE 12.2.1.2.0
I got this error when i try to make an analysis in OBIEE,
I went through my RPD all the connections are good, I am able to view data from physical layer,
i set PERF_PREFER_INTERNAL_STITCH_JOIN to Yes
Still the same message.
Has anyone encountered the same issue?
Kr, Matija
Answers
-
Does the user in the connection pool have access to the table in question? Can you connect directly to the data source and run the same query that is run in OBIEE? If you can, does it run without an error?
0 -
Hi, sry for raising this as a topic, it was my mistake Disabled was ticked on my business model.
Kr, Matija
0