Query to find which all schema password will be changed when using ALLORACLE mode in FNDCPASS

When we are changing the seeded schema password using FNDCPASS ALLORACLE mode then there might be custom schemas that would be registered as well. I we need to find out which custom/seeded schema password be changed using FNDCPASS, then we can use the below query.


Query:

select * from fnd_oracle_userid where read_only_flag='A';


If you like please follow and comment