DBLOOKUP is not returning Correct Value

[Former Member]

Hi All,

We are on GRC 10.0 and SP 21.

We have a requirement that some Risk say, F005 should be considered only for Country  India (IN) and not for America(US). We have created a custom attribute Z_COUNTRY for storing Country Data.

And once the request gets created, all the Request Information (Including Z_COUNTRY) gets stored in GRACREQ Table.

We have also created Mitigation Policy BRF+ Application to cater the above requirement. We are doing the following :-

1. We have created a DBLOOKUP Expression ZGet_Country which gets Z_COUNTRY variable from GRACREQ for the current request. Below is the definition of ZGet_Country

  2.  We are using the Expression ZGet_Country to check if the Location mentioned in Request is IN or US so that Mitigation Policy can be applied accordingly. PFB the screen shot which shows the usage of ZGet_Country.

MIT Policy 1=Yes and 2=No

Problem being Faced : ZGet_Country is not returning right value. When I did the Simulation at Function level (Z_MIT_POLICY function)  I found that the DBLOOKUP Expression ZGet_Country was returning Null Value. So to troubleshoot it I passed the REQ_ID manually ( See Below ) and it worked fine. So I believe the problem is with the REQ_ID being fetched by the DBLOOKUP expression.

Can anyone comment on this and help?

Thanks.

Regards,

Fazil

[former_member204479]

Hi Fazil,

What is the field that you are checking the REQ_ID against?

The screen shot does not give the full name.

Thanks

Sammukh