Changed the Database name column to STATSTG to match the tnsnames alias.
The Database name has to match the tnsnames alias. Database Server and Service name must match the tnsnames service name.
Test Connection was successful and able to complete migration successfully.
(ADDRESS = (PROTOCOL = TCP)(HOST = set1db-scan)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = dcapdmo)