14.43 Data Redaction

Oracle Financial Services Analytical Application Infrastructure (OFSAAI) is enhanced to enable masking of sensitive data and Personal Identification Information (PII) to adhere to Regulations and Privacy Policies. Oracle Data Redaction provides selective, on-the-fly redaction of sensitive data in database query results prior to display by applications so that unauthorized users cannot view the sensitive data. The stored data remains unaltered, while displayed data is transformed to a pattern that does not contain any identifiable information.

For more information, see Oracle Financial Services Advanced Analytical Applications Infrastructure Administration and Configuration Guide Release 8.1.x.

Note:

• The Redacted user must not have the Edit option in the UI
• To display the default value in the UI, configure the AAI_FF_FORM_CONTROLS_B table
• If you do not have data redact function rights and try to update any value in PII data, the application updates all redacted column values to null which leads to data loss.

Configuring Redaction for FCC Grids

Redaction can be configured for FCC grids that are configured using the FCC UI MODULE CONF table. The V MODULE PROP column must be configured under the columnProperties section.

The following is an example for Related Party grid in Customer tab (see the bold attributes):

"key":
          "customer_name","locale_code":"RENDERER.CM_RP_CUST_NAME","align":
        "left","headerAlign":
          "left","width":
        "0.13","dataType":
          "string","draggable":true,"resizable":true,"sortable":true,"readOnly":true,"visible":
        true,"addToColMenu":
          true,"isRedactedColumn": true,
"redactedValueToDisplay": "********"

For Date, Integer, and Float fields, regardless of the value provided for the redactedValueToDisplay attribute, the field will appear as blank.

Redaction on Research UI Screen

A new table FCC_NATIVE_REDACTION_CONFIG has been introduced in Atomic schema. Based on your requirement you can set the value of redaction under the V_REDACTED_VALUE_TO_DISPLAY column.

For the date fields irrespective of whatever value configured in the V_REDACTED_VALUE_TO_DISPLAY column it will be displayed as blank if redacted.

Redaction for Research Customer Overview is provided for now. You can also configure redaction for Account and External Entity. Refer to the FCC_NATIVE_REDACTION_CONFIG table for more information. Additionally you can also see the Redaction_Account_External Entity_Info spreadsheet in MOS.