S_NQ_INITBLOCK questions

Ebin Cherian

Hi All,

Oracle Business Intelligence 12.2.1.1.0

Authentication : MSAD

We have usage tracking and initialization block table configured and data is getting inserted into those tables. Previously values in USER_NAME column in S_NQ_ACCT & S_NQ_INITBLOCK was case sensitive..i.e. username typed at login get stamped into the tables. This created issues while generating usage tracking reports as there could be multiple user names for a single user.

Upon investigating, we found that "Use Retrieved User Name as Principal" was not checked in MSAD provider configuration and after checking it, the value from MSAD start getting populated in USER_NAME column in S_NQ_ACCT. Now the S_NQ_ACCT.USER_NAME is not case sensitive.

But this change is not getting reflected into USER_NAME column in S_NQ_INITBLOCK. Instead of getting the USER_NAME value from MSAD, it is still using the username typed at the login screen. How to resolve this issue ? Or Is this a standard behavior ?

Also I could see sessions where SESSION_ID present in S_NQ_ACCT is not present in S_NQ_INITBLOCK. What could be the reason for that  ?

Thanks

Ebin