How to Expire All Oracle Applications Users Passwords
There may be a need to expire all Oracle Application users passwords in Oracle Applications 11i. Oracle provides a script to expire all users passwords from 11i.ATG_PF.H RUP4. The script is located under $FND_TOP/patch/115/sql/AFCPEXPIRE.sql.
AFCPEXPIRE.sql is a very simple script and is a single update statement that sets the PASSWORD_DATE column to null in FND_USER.
However, due to the ability to decrypt the application user passwords, expiring all users passwords in cloned instances is not an acceptable practice. Rather, all passwords must be changed when cloning. In 11.5.10+, the reset password feature can be used for users to access the cloned instance.