cancel
Showing results for 
Search instead for 
Did you mean: 

Need help on BRF+ lookup to determine Type of Super User ID in Access Request

Former Member
0 Kudos

Dear Experts,

we are using different Super User IDs in EAM. If an Super User ID is critical it should have an different rule result in BRF+ decsion table for req type 6.

To get this into BRF+ decision table I am going to create two DB Look Ups

1. DBLookUp: Get REQ_ID from GRACREQ

2. DBLookUp: Use REQ_ID from 1. DBLookUp to get Request Details from GRACREQPROVITEM and check in PROV_ITEM_ID if critical Super User ID = FF_ID2 is in the Access Request.

3. Add 2. DBLookUp into Decision Table for PROV_ITEM_ID = FF_ID2

My issue is that any Access Request for this Super User ID results in error:


Item '0001' resulted to ''; cannot resolve path; check routing mapping


Can anybody help me to get this running? Many thanks!


Regards,

Markus

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear all,

I have solved the issue today as follows:

Switched 2. DBLookUp to Existence Check type. Then changed DBLookUp as follows to result in TRUE or FALSE and it works now

Regards,

Markus

former_member185447
Active Contributor
0 Kudos

Hello Markus,

Nice to go through this discussion.

I am trying to build a DBlookup for BRF+.

Can you please share the screens and scenarios here which will be useful to understand DBlookup?

Thanks in advance.

Regards

Deepak M

Answers (2)

Answers (2)

Former Member
0 Kudos

HI Markus ,

We tried using both the DB Lookups ( 1 &2 ) and now we understood the reason why you are retrieving the REQ_ID from GRACREQ table.

Now, the workflow paths are getting triggered correctly based on Level of FFID.

Thank you very much for your help.

Regards,

Surendra

Former Member
0 Kudos

HI Markus ,

We are using the same logic which you have explained in your post but we are only using DB lookup 2 only.

We are having three levels for FFID  FFL1,FFL2,FFL3

FFL1 takes standard path

FFL2,FFL3 needs to take Custom Path

Can you please let me know if your logic is working and if so can you please provide me the DB Lookups & Decision Table logic which you have used ?

Regards,

Surendra

Former Member
0 Kudos

Dear Surendra,

second DB Lookup is as below

and in Decision Table based on BOOLEAN True or False the result for FF critical or uncritical is determined (ReqType = 006):

Kind regards,

Markus

Former Member
0 Kudos

HI Markus,

Thank you very much for your reply and screenshots.

We tried to map the scenario as per your screen shot but this did not worked.

Please help get some clarity on the below to get close to solution. Can you please clarify the below things?

- Have you used both DBLOOKUPs ( 1 & 2 )  as a solution ?

- What are the DBLookup names

- Why did we considered REQ_NO from GRACREQ and passed into REQ_ID in one of the DBLOOKUP 1

- What are we trying to achieve by passing the value from DBLOOKUP 1 to DBLOOKUP 2 -> REQ_ID

- What is the value (GRACREQ) passed in the REQ_ID field of  DBLOOKUP 2

For some reason, for our solution the request keep going to the same path what ever is picked first.

Some of the detail from our side is below:

  • DBLookup 1 name: GET_FF_ID_LEVEL1_ONLY and Table GRACREQ
  • DBLookup 2 name: GET_FF_ID_LEVEL and Table GRACREQPROVITEM
  • Decision Table Logic

Screen shot attached with this thread.

Regards,

Surendra