There is a default index on user_guid which is not unique, so one has to assume yes, it is possible to have duplicates.
USER_GUID RAW (16) used to store the guid defined for this user record's corresponding entry in OID
which means that unless you are using Identity Manager then you probably won't have any entries.
so you mean to say that user_guid is coming from OIM?
Please suggest and confirm.
Sorry, I meant Oracle Internet Directory (OID). I couldn't say for sure, however eTRM suggests so.
Yes. I have cleared that column out and it will repopulate upon logging in via osso/oid. If you log in using the local login jsp, it wont populate.
We clear that column out when cloning EBS from PROD to non-PROD when the non-PROD uses a different osso/oid, as the guids differ in the non-prod oid.
In your case, I would delete the user_guid for both users (in a non-PROD of course) and see how it goes from there...