Apparently that is not such a problem after all.
First I must say that new user is out because when SSO is used then also the domain userID would have to be new.
The resource ID can be changed in the GUI so the users see the correct one.
The problem appeared to be that pac_mnt_resources.resource_code is not the same as srm_resources_unique_name while it is equal to ppa_wip.resource_code ie
pac_mnt_resources.resource_code <> srm_resources_unique_name
pac_mnt_resources.resource_code = ppa_wip.resource_code
In Clarity it seems that it does not go that way, but srm_resources.id -> pac_mnt_resources.id and then pac_mnt_resources.resource_code -> ppa_wip.resource_code
That way we see the data in WIP even if there is the mismatch or resource name/code
The problem is with our custom queries which we can fix based on the above information.
Comments anybody?