| Article Number | 000034690 |
| 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.
- Keep and Remark is displayed as valid custom review state when you run the review.
- 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).
|
| 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,
- 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;
- Verify that the setting in the System Settings table with parameter name CustomState has been added.
- Run the Entitlement Review Item Details by Reviewer report again. This time it will display your custom state of Keep and Remark.
|
on Jan 27, 2017
