Thanks for the update. My requirement is not to register the schemas. I have around 18 custom schema in ERP database. But any query to check the which schemas registered in EBS ?
You can use this script (adutconf.sql) that provides details about Registered ORACLE Schemas
you can run adutconf.sql
Hope this helps!
The output should contain what you are looking for.
Registered ORACLE Schemas