Re: 12.1.3 Forms Navigator is empty after moving the DB to Exadata Gen 2

Posted by ErmanArslansOracleBlog on Jan 29, 2023; 8:12am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/12-1-3-Forms-Navigator-is-empty-after-moving-the-DB-to-Exadata-Gen-2-tp11523p11525.html

You didn't do anything critical in the apps layer. You just the migrated the db to Exa Gen2
Probably the autoconfig that you executed in the apps node, overwrite some profile option values.

You can go with the MOS. (for instance note 265657.1)..
You don't need forms screens to update the profile option, we have APIs that let you do those things on the db level. Check the documentation of FND_PROFILE. There are lots of resource publicly available for getting the method required for modifying the profile options. So I guess you can find your way there.

Some refs : How To Set A System Profile Value Without Logging In To The Applications (Doc ID 364503.1)

-- note that you can compare the profile options of those problematic instance and a proper one as well.. You have fnd_profile.save, fnd_profile_option_values and etc will help you on that.