on 02-26-2015 4:38 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Screen shot attached with this thread.
Regards,
Surendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.