Hi everyone!
I am becoming exasperated with missing views in one of my Oracle Cloud data sources and need advice. I am successfully connecting to our Oracle Cloud via the on-premise gateway. Until today, I could use the search box to bring up the views which were specifically created for this project. Now, the search box only returns two tables which match part of the search term. I scrolled all the way down in the result list and obviously couldn't find it either.
I can force the connection by typing the name in the custom table name field but that is causing significant more work when moving from beta to prod environment since the notation changes from '[schema].[table_name]' to 'schema.table_name'. I could use variables but all that would require me to significantly change my code base. Before, I could just remove the views from the beta source and add in the views from prod database which have the same name and structure.
As you can read in between the lines, I don't have this issue on prod. I can search for the views, they pop up and I can just add them.
What I've tried/checked so far:
- Checked database user privileges (grant rights)
- Removing and re-adding the data source from the on-premise gateway
- Changing browsers (Opera, Chrome, Edge Chrome, Edge Chrome Dev)
- Disabled "Improve data source experience and Common Data Services views" as suggested in another thread
Anyone?
Thx for your time and help!
Henning
