RSA Identity Governance and Lifecycle report template Entitlement Review Item Details by Reviewer does not display the custom state
2 years ago
Originally Published: 2017-01-16
Article Number
000040155
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0
Issue
Although the custom review state is enabled and defined in the Review definition, it is displayed as None in the generated report when you run the Entitlement Review Item Details by Reviewer report.  As an example, 
  • In the Review Definition, the custom review state (e. g., Keep and Remark) is defined in the Review Definition. 
User-added image
 
  • Keep and Remark is displayed as valid custom review state when you run the review.
User-added image
  • However, when you run the Entitlement Review Item Details by Reviewer Report, it displays None instead of the defined custom state (e.  g., Keep and Remark).
User-added image
Cause
The View definition (V_AVR_ER_ITEM_DETAIL) in the Entitlement Review Item Details by Reviewer Report tries to include the custom state, but the inclusion happens only when there is a setting in the System Settings table with parameter name of CustomState with the value expected to be the display name for custom state (that is, Keep and Remark). 
Workaround
To fix the entries in the view and the report,
  1. Run the following SQL script to add the setting (replacing Display Name for Custom State with your custom state display name).  It could be a simple INSERT statement, but use the example below to avoid inserting the same entry multiple times.
DECLARE
v_count INTEGER;
v_param VARCHAR2(50) := 'CustomState';


BEGIN

SELECT COUNT(1) INTO v_count FROM T_SYSTEM_SETTINGS WHERE PARAMETER = v_param;
IF(v_count = 0) THEN

  INSERT INTO T_SYSTEM_SETTINGS(PARAMETER, VALUE) VALUES (v_param, 'Display Name for Custom State');

END IF;


COMMIT;
END;
  1. Verify that the setting in the System Settings table with parameter name CustomState has been added.
Verify T_system_settings table
 
  1. Run the Entitlement Review Item Details by Reviewer report again.  This time it will display your custom state of Keep and Remark.
User-added image