An opaque view is in the physical layer a physical table that consists of a Select statement .
In the repository, opaque views appear as tables in the physical layer but the view does not actually exist.
How to deploy an opaque view?
You deploy an opaque view in the physical database using the Deploy View(s) utility.
After deploying an opaque view, it is called a deployed view. Opaque views can be used without deploying them but the Oracle BI Server has to generate a more complex query when an opaque view is encountered.
Databases such as XLS and nonrelational database do not support opaque views and, therefore, cannot run the view deployment utility.