FNDCPASS with ALLORACLE option -what is the effect on EBS
We are on 12.2.6 EBS with 12c database and are focusing on ensuring our users/schemas have non-default passwords. I've run the script from patch 4926128 "dfltpass.sql" and it returns no entries, but a query on dba_users_with_defpwd returns 193 rows. I'm not sure why they don't report the same thing.
How safe is it to run FNDCPASS APPS/<pswd> 0 Y SYSTEM/<pswd> ALLORACLE <new-pswd> on the seeded schema users? Will this affect EBS functioning or adop patching?
I don't believe there is any custom interfacing that actually uses these schema users but I'm unsure how it might affect standard 12.2 EBS.