NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Change\Expire all application users password forcefully

1 comment
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.

1 comment :

  1. 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…

    AWS Training in Bangalore|

    ReplyDelete