I'm trying to connect to a view in Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production from a WS 2012 R2 FMS 16.0.3 server using Oracles instantclient 18_3 drivers. I did establish the environment variable "tnsnames" successfully and the server and proper ports appear. I installed the 64 bit drivers and got a "successful" test but when I went to establish the relationship using Manage External Data Source I could not see the Oracle view. So, I removed the drivers and files and installed the 32 bit drive (18_3) and had the same problem.
What am I missing? I could really use some help.