CA Privileged Identity Manager Tech Tip by Toshiyuki Hatakeyama, Principal Support for July 14, 2015
You can create Endpoint for ORACLE server with ServiceName instead of SID.
URL format is following:
For SID: jdbc:oracle:thin:@hostname:port#:SID
i.e: jdbc:oracle:thin:@oracleserver:1521:SAMPLE_SID
For ServiceName: jdbc:oracle:thin:@//hostname:port#/ServiceName
i.e: jdbc:oracle:thin:@//oracleserver:1521/SERVICENAME