“Expire all FND_USER passwords”

This is available starting in RUP4. Requires Patch 4676589 ATG RUP 4.

The script to expire all passwords in the fnd_user table is $FND_TOP/patch/115/sql/AFCPEXPIRE.sql.  It can be executed from SQL*Plus or as a Concurrent Program:

sqlplus -s APPS/<pwd> @AFCPEXPIRE.sql
Submit concurrent request: CP SQL*Plus Expire FND_USER Passwords

This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire. It can also be run as a SQL*Plus concurrent program. The user will need to create a new password upon the next login.

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s