View PV_REVIEW_DEFINITION returns entries for deleted and/or revised review definitions in RSA Identity Governance & Lifecycle

[#1]

Article Number

000039088

Applies To

RSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 7.1.0, 7.1.1, 7.2.0
 

Issue

When creating a report in RSA Identity Governance & Lifecycle  (Reports > Tabular > Create Report) that uses the AVUSER.PV_REVIEW_DEFINTION public view to get a list of review definitions, if deleted review definitions and/or revised review definitions exist, they appear on the report.

EXAMPLE

Note the following review names under Reviews > Definitions.

Image description

If review UA10 is deleted (Reviews > Definitions > UA10 > trash can icon top right corner), it no longer shows under Reviews > Definitions.

Image description

The expected behavior is that the report will show the list of current review definitions only. The same list as can be seen under Reviews > Definitions. However, the deleted reviews and all review definition revisions show on the report (Reports > Tabular > {Name of report} > Run Report). Note in the example below that UA10 and all of its revisions show on the report.

Report Definition:

Image description

Report Results:

Image description

 

Cause

This is a known issue reported in engineering ticket ACM-104869.

The PV_REVIEW_DEFINITION returns entries from the incorrect table. The view queries a table that tracks all review definitions including deleted definitions and version changes rather than the table that stores the current review definitions. This causes the view to return deleted definitions and duplicate entries when they exist.
 

Resolution

This issue is resolved in RSA Identity Governance & Lifecycle 7.2.0 P02.
 

Workaround

Please contact RSA Identity Governance & Lifecycle Customer Support for a workaround and mention this RSA Knowledge Base Article ID 000039088 for reference.