So I updated fnd_user records to clear out the fnd_user.user_guid and was going to try to import from OID using the LDAPUserImport command
Please provide more details, How you have cleared the FND_USER records. Any possibility if you can restore it from backup.
We use this update statement on the back-end to clear out the fnd_user.user_guid when needed:
update fnd_user set fnd_user.user_guid=null (where ... if we want to restrict to a particular user when trying to resolve SSO issues).
I checked our cloning procedures and we do take a backup of the fnd_user table during cloning as we change the email address so there won't be any chance that workflow mailer might send out emails from a test environment. I could go back to that backup table and refresh the fnd_user.user_guid. Maybe this is the best tactic -- I should restore that and then try to follow instructions for dumping the GUIDs back into the OID database.
1 person found this helpful
And also just import one unique user to EBS through LDAPUserImport and see if SSO functionality with forms issue works normal. and accordingly, scale it to all OID users.