000034690 - RSA Identity Governance and  Lifecycle report template Entitlement Review Item Details by Reviewer does not display the custom state

Document created by RSA Customer Support Employee on Jan 27, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034690
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0
IssueAlthough 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
CauseThe 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 (e. g., Keep and Remark). 
WorkaroundTo 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 (e. g. Keep and Remark).
User-added image

 

Attachments

    Outcomes