Has anyone come across a situation where a View created on an Oracle DB is not seen thru DB Connect ?
I have views created on an Oracle DB, which can be confirmed independently via pl/sql. When I establish link between a SAP BW and the Oracle DB using a DB Connect, (-intention being to extract data from the Oracle DB into the BW) I dont seem to see some of the views. I am trying to repeat the case to see if there is an issue with 'Grant Access' on the Oracle side. Any ideas ?
SRRao