You should search for ORA-00942 and it will give you the full reasons behind the error, usually user does not have access to the table/view or the table/view does not exist
Please make sure the user you are using in the integration "to connect the data base source" has an admin privileges to the source database
The user which in use has read access to the View created from different tables for this integration.
So you are suggesting this user should have admin/superuser access to the schema where this view reside.
The user doesn't need to have admin access, the user just needs to have READ access. More importantly what the error is saying is the table you have defined in your integration does not exist or the user does not have access to read from it. When using a view the user must have read access to all objects that make up the view. If your user truly did have access, Oracle (not EPM) would not be throwing that error.
Under the Physical Schema settings, what do you have defined as the default Schema/Work Schema?
Seems like an integration is feasible only with an admin user in FDMEE landscape.
Due to security reason, customer always show reluctance to use an admin user.
This issue got resolved with same user(Non admin) by making following changes
1.Modifed the data set for view
2.Modified the mapping for account
Thank you so much for all inputs and helps.