Jdeveloper DB connection Error - ORA-12504, TNS Listener was not given SID in CONNECT_DATA

Jdeveloper version used is 10.1.3.5.0.3

Oracle db version is 19C

I am setting up the JDeveloper for OAF development in EBS. I created a DB connection and the Database Connection test passes when tested from db connections in jdeveloper.

While creating a project in jdeveloper; there is a step to choose database connection and when i choose the connection it throws below error:

No database connection available. Listener refused the connection with following error:

ORA-12504, TNS Listener was not given SID in CONNECT_DATA

Its strange the test DB connection works but when i am selecting the DB connection as part of project creation it is throwing error.