check if guest password is working
if not run autoconfig to correct
if you can't find record in fnd_user_resp_groups for user_id
runned those concurrent request
Workflow Directory Services User/Role Validation
Synchronize WF Local Tables
This did not work. Still working with Oracle
i know it looks weird,
we got something similar after upgrading techstack in production
and we were unable to know what solve the problem exactly
are you able to reset sysadmin with fndcpass and login
if yes create a dummy user with system administrator responsibility
login with this user
if it start working, comme back to tell me
so did it work with oracle
Have you verified that you sufficient space in all tablespaces. Also check whether you added TEMP tablespace after cloning.
Check as below -
Users default tablespace, temp tablespace and try to reset the password and again try to log in.
And share the latest error.