After migrating from Oracle BI EE 11g to Oracle BI 12c the RPD consistency checker shows the following Error message with Error # 38197:
Data filter expression VALUEOF(NQ_SESSION.”variable”) for Applicaton Role is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.variable, has no value definition
Within OBI EE 11g consistency checker this was neither thrown as a Error message nor as a Warning.
Within the consistency checker of 12c, this is throwing as a error. To fix this a default value needs to be specified for each variable besides the Authorization Block. For this go to Manage| Variables | Session |Initialization Blocks and double click on a Name e.g. Business Groups.
And open “Edit Data Target” within the variable Target area and assure that the Default Initializer as a default value as shown below:
After running the consistency checker again, the error message disappears.