I.1 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 the Related Party grid in the Customer tab (see the highlighted 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": "********"

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

Redaction on UI Screens

The FCC_NATIVE_REDACTION_CONFIG table in the Atomic schema allows you to set the value of redaction under the V_REDACTED_VALUE_TO_DISPLAY column, based on your requirements.

Date fields will be displayed as blank if redacted, regardless of the value is configured in the V_REDACTED_VALUE_TO_DISPLAY column.

You can also configure redaction for Accounts and External Entities. 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.