C.1.4 Configurations Required for the Audit Tables

Before you update the tables, you must first provide a unique value in the n_activity_id column in the SETUP_RT_AUD_ACTIVITY table and then provide the same value in the n_activity_id column in the SETUP_RT_AUD_STEPS table.

After this is done, run the select * from SETUP_RT_AUD_ACTIVITY query to update the SETUP_RT_AUD_ACTIVITY table and run the select * from SETUP_RT_AUD_STEPS query to update the SETUP_RT_AUD_STEPS table.

After the tables are updated, provide two entries, 1 and 2, in the n_step_sequence column in the SETUP_RT_AUD_STEPS table.

Note:

The value provided in the v_status_name column in the AAI_WF_STA- TUS_TL table must be a combination of one of the following values:

• The value provided in v_sanction_status_name in dim_sanc- tions_status table and the name of the transaction workflow invoked for entry 1.
• The value provided in v_sanction_status_name in dim_sanc- tions_status table and the name of the transaction workflow completed for entry 2.