1 person found this helpful
Problem with passwords is that encrypting relies on the APPS password so the encrypted value is not transportable among instances unless the APPS schema credentials are the same (see the lct for parameters to download/upload the password as the default is not to do it).
Now, if users are already migrated, the way to unlock is to assign a password and set the password date to null to force a password change. This can be done via the user API:
fnd_user_pkg.UpdateUser( x_user_name => l_user_name , x_owner => 1 , x_unencrypted_password => 'Welcome1' -- password in clear text , x_password_date => trunc( sysdate ) -- null to require password change, date value to let the password remain , x_end_date => fnd_user_pkg.null_date );
I found a parameter to run as "DOWNLOAD_PASSWORD=Y" while downloading with FNDLOAD, and to UPLOAD you can use the "UPDATE_USER=Y" , and this works perfectly. All the users are loaded as "Active"