My Oracle Support Banner

Data Redaction: System Is Displaying Null Value For Redacted Columns And On Save, Values Got Removed (Doc ID 2924675.1)

Last updated on FEBRUARY 05, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.2 and later
Information in this document applies to any platform.

Goal

Problem Summary
---------------------------------------------------
Data Redaction: System is displaying null value for redacted columns and on save, values got removed

Problem Description
---------------------------------------------------
When user (analyst) who does not have data security rights, views the Case Details page >> Customer tab, the redacted data (Ex: Customer Date of Birth), is showing as null. User will mis-understand that data not available in the system. Ideally, we need to configure the system to display some constant values (Ex: XXXX). Currently this configuration needs to be done manually in aai_ff_form_controls_b.REDACTED_VALUE_TO_DISPLAY column. I did for Tax Id as in screenshot. Can we configure this default value as part of data redaction in AAI_DRF_FUNCTION_COLUMN_MAP table before batch execution?

Since null value is getting displayed, if user tries to save the record, the respective column value is getting updated with null value. This leads to data loss.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.