Reference:
Note: 414976.1 – How To Force All Applications Users To Change Their Password?
We might have the requirement to force all EBS users to change their passwords due to some requirement.
run sql Script like below or same you can achieve by submitting concurrent request
sqlplus -s APPS/apps; @AFCPEXPIRE.sql
or
Submit concurrent request: CP SQL*Plus Expire FND_USER Passwords
Above 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.
