6.3 Update Alert Financial Data

OFSBD provides some enhanced data on alerts to support searching by alerts based on business data. For example, Trader-focused alerts may be searched based on the security involved in the activity. Update Alert Financial Data is the process that populates this information.

To update alert financial data, run the following command from the <OFSAAI Installed Directory>/database/db_tools/bin directory:

upd_kdd_review_fin.sh <batch_id> <YYYYMMDD>

If <batch_id> and the batch date <YYYYMMDD> are not provided, the system derives this data for matches created in the current batch.

The log for this process is under the <OFSAAI Installed Directory>/database/db_tools/logs directory. The name of the file is run_stored_procedure.log.