OCI Gen 2 Migration: Smart View URL Mappings are extremely helpful
Not sure if this is obvious, but I thought I'd mention it - for those managing their own migration to OCI Gen 2, utilizing the URL Mapping feature in Smart View will make you and your users' lives much easier. You just map all of your URLs and that's it! All your existing ad hoc, report, form, etc. connections automatically map as well. No need to go into each individual sheet and update the connection. Below is the documentation:
Adding Connection URL Mappings (oracle.com)
Hopefully this helps anyone who is not aware of this feature. Do note that you need to be on Smart View version 22.100 or later to utilize this.