Dear Folks,
Recently we have faced an issue in EBS 12.2 instance where we weren't able to change APPLSYSPUB password and ended up with below error.
APP-FND-02704: Unable to alter user APPLSYSPUB to change password.
Oracle error 28003: `n▒ 8 has been detected in alterpassword2.
Unable to change the password for Oracle user APPLSYSPUB.
Fix
Check APPLSYSPUB belongs to which profile.
SQL> col USERNAME for a10;
col ACCOUNT_STATUS for a20;
col EXPIRY_DATE for a10;
col PROFILE for a20;
select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from dba_users where USERNAME in ('APPLSYSPUB');SQL> SQL> SQL> SQL>
USERNAME ACCOUNT_STATUS EXPIRY_DAT PROFILE
---------- -------------------- ---------- --------------------
APPLSYSPUB OPEN APPS_USER_PROFILE
Verify "PASSWORD_VERIFY_FUNCTION" RESOURCE_NAME for the above profile.
SQL> select * from dba_profiles where PROFILE='APPS_USER_PROFILE' and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT COM
-------------------- ------------------------------ ------------------------------ ---------------------------------------- ---
APPS_USER_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G NO
Alter it to NULL.
SQL> alter profile APPS_USER_PROFILE LIMIT PASSWORD_VERIFY_FUNCTION NULL;
Profile altered.
and change the APPLSSYPUB password and now it works.
Working...
Password is changed successfully for user APPLSYSPUB.
FNDCPASS completed successfully.
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Rervert back the profile.
SQL> alter profile APPS_USER_PROFILE LIMIT PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G;
Profile altered.
Thanks.
