Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BRF+ DB Lookup No Role Approver Issue

Hi All,


I have referred the blog on BRF+ DB lookup for routing result on no role owner:


http://scn.sap.com/community/grc/blog/2013/03/15/using-brf-db-lookup-to-create-complex-msmp-rules


I am on GRC 10.1.


I am able to create the db lookup successfully but unable to achieve the result in simulation mode. I have attached screenshot of the same.


My ultimate goal is to configure the following scenario:


While raising access request I have configured default role (General / Common role) which are without Role Approvers.In Access Request I don't have manager stage, directly the request  would move to Role Owner stage. I need to take care of the roles without the owner which is why I have taken the help of DB Lookup to move the roles without role approver to No Stage path.

Any help is highly appreciable.

Screenshots:

Tags:
replied

Hi Plaban / Everyone,

I have resolved the issue.

I wrote 2 DB Lookup, one for determining the Role ID and other to determine Role assignment approver for the Role ID then I used the same in decision table.

Finally I got the results as expected and my access requesting is also behaving as per expectation. The access request is moving the role with no role owner to a path with no stages and roles with role owner are moved to path with role-owner stage. Post role-owner approval the user is provisioned in the system.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question