Search This Blog

Sunday, July 24, 2011

How to force application users to change their password

Some time there is a requirement to force application users to change their password.
for eg: to implement new validation password policy (role).

There is two ways to achieve this
1. through sql script
2. oracle application "expire day" setting at system administration responsibility --> user ---> there is a option to set expiration no of days.

1. through sql script

there is a script called 'AFCPEXPIRE.sql' located under $FND_TOP/patch/115/sql
eg: sqlplus -a APPS/APPS @AFCPEXPIRE.sql
Or
concurrent program called 'CP SQL*Plus Expire FND_USER Passwords'

No comments: