How to Change the APPS APPLSYS FS_NE schema passwords in oracle APPS R 12.2.X

Note: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed.
         Remove the backups after you have confirmed that the changes are successfully completed.
         Passwords for all the 3 schemas APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

A. Shut down the application tier services using the below script:
$INST_TOP/admin/scripts/adstpall.sh

B. Change the APPLSYS password using one of the following options:

1) FNDCPASS:

Use the below syntax:
FNDCPASS 0 Y / SYSTEM APPLSYS <new_password>
For example, the following command changes the APPLSYS password to 'WELCOME':
FNDCPASS apps/ 0 Y system/manager SYSTEM APPLSYS WELCOME

Note: Confirm you have $FND_TOP/patch/115/sql/ AFSCJAVS.pls file version 120.12.12020000.8 or above before running FNDCPASS on 12.2.X.
Otherwise apply Patch 19127427 : UNABLE TO CHANGE PASSWORD USING FNDCPASS - NO ERRORS IN THE LOG. If not installed FNDCPASS with fail to change the password.



NOTE: The steps 3 to 7 are mandatory for both FNDCPASS and AFPASSWD and are only applicable when changing the APPLSYS password. They are not applicable when changing passwords for product schemas like PO, GL etc or the SYSTEM schema.
In the next prepare phase after the password change, adop will invoke EBS Domain Configuration to ensure that the WLS datasource on the patch file system will be synchronized with the new APPS password.

C. Run autoconfig with the newly changed password.

D. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services.

E. Change the "apps" password in WLS Datasource as follows:

1) Log in to WLS Administration Console.
2) Click Lock & Edit in Change Center.
3) In the Domain Structure tree, expand Services, then select Data Sources.
4) On the "Summary of JDBC Data Sources" page, select EBSDataSource.
5) On the "Settings for EBSDataSource" page, select the Connection Pool tab.
6) Enter the new password in the "Password" field.
7) Enter the new password in the "Confirm Password" field.
8) Click Save.
9) Click Activate Changes in Change Center.

F. Start all the application tier services using the below script

$INST_TOP/admin/scripts/adstrtal.sh

G. Verify the WLS Datastore changes as follows:

1) Log in to WLS Administration Console.
2) In the Domain Structure tree, expand Services, then select Data Sources.
3) On the "Summary of JDBC Data Sources" page, select EBSDataSource.
4) On the "Settings for EBSDataSource" page, select Monitoring > Testing.
5) Select "oacore_server1".
6) Click Test DataSource
7) Look for the message "Test of EBSDataSource on server oacore_server1 was successful".