GRC Report (Request Details vs Approver Details)

[former_member187795]

Hi All,

I want to prepare a report which gives the request number and approvers at different stages.

I found that information is available in below tables.

1. GRACREQ - With Request ID, Request number, Request Created Date

2. GRFNMWRTDATLG - with MSMP Instance ID, Stage Sequence Number, Stage Status,Approver User

3. GRFNMWRTINST - with MSMP Instance ID, External Key (ACCREQ/REQUESTID)

I am not able to connect GRFNMWR* tables with GRACREQ* tables as I couldn't find any mapping.

However in GRFNMWRTINST table, I could see there is a column called "EXTERNAL KEY"

for example with value as "ACCREQ/529CEC1BA0701A30E1008000C0A8141C".

In this second part of value corresponds to Request ID in GRACREQ* tables.

I am trying to create a table join using SQVI for above mentioned 3 tables but not able to connect

GRFNMWR* tables with GRACREQ* tables.

Someone please suggest how to connect GRFNMWR* tables with GRACREQ* tables.

Thanks in advance.

Regards,

Sai.

[sandeep_devaki]

Hi Sai,

Just make use of two tables GRFNMWRTINST and GRFNMWRTDATLG you will get the required result .

In table GRFNMWRTINST give the request number in EXTERNAL_KEY_DIS and get the INSTANCE_ID . Give this INSTANCE_ID in the table GRFNMWRTDATLG , you will get the stage approvers for request .

Regards,

Sandeep Devaki