How to change APPLSYSPUB password in EBS.

Change APPLSYSPUB password

Shutdown the apptier:

 

Backup and change PWD in the below files:

$CONTEXT_FILE

$FND_SECURE  → .dbc file

$IAS_CONFIG_HOME/Apache/Jserv/etc/formservlet.ini

appTier .env files ($APPL_TOP)

sqlplus / as sysadb

SQL> create table applsys.fnd_oracle_userid_02102016 as select * from applsys.fnd_oracle_userid;

Table created.

SQL> create table applsys.fnd_user_02102016 as select * from applsys.fnd_user;

Table created.

Change password:

FNDCPASS apps/xxxxxxxxxxxx 0 Y system/xxxxxxxxxxxx ORACLE APPLSYSPUB xxxxxxxxxxxx

Start the apptier: