We are migrating from On Prem OBIEE (12.2.1.4) to OACS Gen2 (Nov23 release) as part of migration project. On Prem OBIEE instance having USER ID session variable populated with six digit character string for ex. singgae while OACS Gen2 having USER system session variable populated as 7 digit numeric code for ex. 78990000 called as PeopelSoft ID.
The reason for :USER system session variable is because, On Prem OBIEE having MS AD as authentication provider while OACS we have IDCS/IAM which is based on employee ID
Due to this change, there are below issues occurred in migration project.
1. Users My folders (in catalog) in On Prem OBIEE inaccessible in OACS as those are with Racf ID mapped while we don't have this in OACS.
2. Data Level Security Init Blocks are returning no rows due to mismatch in :USER system session variable. Example given below. Database table sso_user_info column username has RACF ID while in OACS we :USER contains numeric value.
select 'ENTITY_REGION',Entity_region from sso_user_info where upper(username)=upper(':USER')
Thanks,
Gaurav
