OFS Anti-Money Laundering (AML)

This section describes the AML-related post-installation steps.

If OFS AML is installed:

1. Delete the list of class files inside the $FIC_HOME/bdf/classes directory.
2. Steps to execute DQ scripts in different FSDF INFODOMs are as follow:
   1. Navigate to FIC_HOME/database/db_tools/bin path and execute the file Replace_FSDF_Placeholder.sh with FSDF infodom and FSDF segments as arguments. For example : ./Replace_FSDF_Placeholder.sh FSDFINFODOM FSDFSEGENT.
   2. Copy $FIC_HOME/database/DQScripts to a local folder.
   3. Log in to FSDF schema and Run the following command in SQL developer.
      • define dir="DQFIles_PATH"

        DQFIles_PATH - The directory path DQ files were copied in step above.

        For example: define dir="C:\DQScripts".

      • Execute Execution_Order_DQ.sql

        For example: @&dir\Execution_Order_DQ.sql.

3. Execute the below SQL script in BD atomic schema if BD and FSDF are in the same Infodom. If FSDF is in a different Infodom, execute the below SQL script in FSDF atomic schema:

   ALTER TABLE STG_RETIREMENT_ACCOUNTS_TXNS MODIFY D_POSTING_TIME TIMESTAMP WITH TIME ZONE

   /

   ALTER TABLE STG_ANNUITY_TXNS MODIFY D_POSTING_TIME TIMESTAMP WITH TIME ZONE

   /