In Bi Publisher when creating a JDBC Connection to an oracle database please ensure there is a TNS Entry available in the network/admin folder for OBIEE.
Also use the following syntax when creating a JDBC Connection within BI Publisher Administration
jdbc:oracle:thin:@HOST:PORT/SID
Note: only a member of this blog may post a comment.