We can forcefully expire password for all EBS user.This feature is available after RUP4.We need to apply Patch 4676589 ATG RUP 4 enabling this feature.
Script:
The below script can be used to expire all passwords in the fnd_user table $FND_TOP/sql/AFCPEXPIRE.sql.
Execution Method
Connect to SQL*Plus
sqlplus APPS/ APPSPASSWORD
@AFCPEXPIRE.sql
OR
Submit Concurrent Program
CP SQL*Plus Expire FND_USER Passwords
Note:
This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire.The user will need to create a new password upon the next login.
Script:
The below script can be used to expire all passwords in the fnd_user table $FND_TOP/sql/AFCPEXPIRE.sql.
Execution Method
Connect to SQL*Plus
sqlplus APPS/ APPSPASSWORD
@AFCPEXPIRE.sql
OR
Submit Concurrent Program
CP SQL*Plus Expire FND_USER Passwords
Note:
This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire.The user will need to create a new password upon the next login.
6 Comments
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
ReplyDeleteAWS Training in Bangalore|
If you don"t mind proceed with this extraordinary work and I anticipate a greater amount of your magnificent blog entries Roblox APK Robux Download
ReplyDeleteSuper site! I am Loving it!! Will return once more, Im taking your food additionally, Thanks. TubeMate APK iPhone Download
ReplyDeleteThe web site is lovingly serviced and saved as much as date. So it should be, thanks for sharing this with us. Latest & Updated Version
ReplyDeleteThis is an excellent post I seen thanks to share it. It is really what I wanted to see hope in future you will continue for sharing such a excellent post. Iphone Download Latest version
ReplyDeleteI am seeking how to expire APPS & APPLSYS password. This is because of a database upgrade I am currently working on to 19c from 11g (11.2.0.4.0). The db parameter setting of sec_case_sensitive_logon has been FALSE and password version=10. I want to set it to 11 and change the parameter to TRUE. The moment I do this apps and applsys gets locked out and I have to do this prior to running the upgrade. I want to avoid getting logged out post upgrade.
ReplyDeletePost a Comment