C.1 Implementing Right to Forget

Follow these steps to implement Right to Forget:

  1. Transfer the Batch Username ownership to PMUSER (or any common user) from sysadmn as below:
    begin
    AAI_OBJECT_ADMIN.TRANSFER_BATCH_OWNERSHIP('SYSADMN','PMUSER');
    end;
  2. Go to Batch Maintenance Screen and Edit the Right to forget and data redaction batch usernames under param values to common usernames like PMUSER.
  3. Give an entry of v_d_cust_ref_code by selecting the existing v_d_cust_ref_code from dim_customer for which Right to Forget has to be applied in the FSI_PARTY_RIGHT_TO_FORGET table.
  4. Execute the Righttoforget batch and then verify the V_D_Cust_First_Name should get randomized. Verify Right to forget for Processing Table:

    Create the existing customer deal for the same v_d_cust_ref_code and verify the Right To Forget only for existing customers in fsi_m_customer_details.

    Get the List of processing column names which has to get randomized from the AAI_DRF_QUERY_METADATA table.

    Note:

    Right to Forget will not work for New Customers. It works only for existing customers.
  5. Execute the DataRedaction batch and then verify the v_d_cust_first_name should be empty. Get the List of PI columns for Data Redaction from the AAI_DRF_FUNCTION_COLUMN_MAP table.