Backup tables before changing passwords using FNDCPASS

Hi All,

Please backup tables before using the FNDCPASS utility on changing default passwords - EBS
a. fnd_user
b. fnd_oracle_userid

steps:

SQL> connect system/manager

SQL> create table [backup_tab_fnd_oracle_userid] as select * from apps.fnd_oracle_userid;
SQL> commit;
SQL> connect apps/apps
SQL> create table [backup_tab_fnd_user] as select * from fnd_user;
SQL> commit;
SQL> exit

Now execute the FNDCPASS APPLSYS schema

Need to apply this on application tier:
$ FNDCPASS apps/[apps_pwd] 0 Y system/manager SYSTEM applsys [apps_new_pwd]

follow the required steps to finish the remaining.

NOTE: all changes will affect only after restarting the apps tier services (apache)

Thank you for your time to read this post!

/shakir
Apps DBA