Welcome to the Dataiku community.
First, I'm not an expert on Oracle and the DSS connection to Oracle. (Others who are, please jump in here.)
That said in all of the SQL databases I've used a view can be used very much like any table.
SELECT * FROM TABLE_NAME;
Where TABLE_NAME is the name of a table in your database.
This works much the same way as selecting from a view
SELECT * FROM VIEW_NAME;
Where VIEW_NAME is a view defined in the database.
Here is the documentation for the Oracle Dataiku DSS Connector. I see nothing there that says that this connector can not see a view.
If I was debugging this situation. I'd connect to the database directly with the credentials that DSS is being used by DSS and confirm that that account has rights to the view in question. This security issue has more often caused me problems with views. Then I'd set up the connection. If I can not see the view from any of the DSS dropdowns. I'd then create a simple SQL query from within DSS to see if I can access the view.
Just my $0.02. Hope it helps. Let us know how you are getting on with this.