Soumya's Database Blog : How to change APPLSYSPUB password in EBS R 12.2

After implementing PASSWORD_LIFE_TIME TO 30 DAYS for default profile, applsyspub user’s password was expired after 30 days.

Following error is observed after logging in to application,

Solution:-

We altered the profile of APPLSYSPUB user from default to EBS_APPS and rested the password of APPLSYSPUB user.

SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE FROM DBA_USERS WHERE USERNAME='APPLSYSPUB';

USERNAME ACCOUNT_STATUS EXPIRY_DATE PROFILE

-------------------- -------------------- --------------- -------------------------

APPLSYSPUB EXPIRED 27-MAR-21 DEFAULT

SQL> ALTER USER APPlSYSPUB PROFILE EBS_APPS;

User altered.

· Shutdown application service.

[appltest@vm1test scripts]$ cd $ADMIN_SCRIPTS_HOME

[appltest@vm1test scripts]$ adstpal.sh

· Reset APPLSYSPUB password using FNDCPASS OR AFPASSWD .

Note:- APPLSYSPUB password must be in UPPER CASE due to internal code dependencies.

[appltest@vm1test scripts]$ AFPASSWD -c APPS -o applsyspub

Enter the ORACLE password of Application Object Library 'APPSUSER':

Connected successfully to APPS.

Enter the password for your 'SYSTEM' ORACLE schema:

Connected successfully to SYSTEM.

Log file: AFPWD_TEST_042697.log

Enter new password for user [applsyspub]:

Verify new password for user [applsyspub]:

· Make following changes in application context file.

Take a backup of application context file.

[appltest@vm1test scripts]$ cp $CONTEXT_FILE TEST_vm1test.xml_bkp

[appltest@vm1test scripts]$ vi $CONTEXT_FILE

Look for following parameter s_gwyuid and s_gwyuid_pass

Make changes like this

From

<GWYUID oa_var="s_gwyuid">APPLSYSPUB/PUB</GWYUID>

<GWYUID oa_var="s_gwyuid">APPLSYSPUB/NEWAPPLSYSPUBPASSWD</GWYUID>

From

<password oa_var="s_gwyuid_pass"> NEWAPPLSYSPUBPASSWD </password>

· Run autoconfig on application tier

[appltest@vm1test scripts]$ sh adautocfg.sh

· Start application and now error should be resolved.