5.4 Checking the Execution Status

The Batch Execution Status can be monitored through the Batch Monitor window of the OFSAAI Operations module.

The status messages in the Batch Monitor are:

• N: Not Started
• O: On Going
• F: Failure
• S: Success

The Batch Process execution log and the detailed ALM Transformation component log can be accessed on the application server at $FIC_DB_HOME/log/date.

The file name will have the Batch Execution ID.

Sample Path: /dbfiles/home/oracle/OFSAAI/ficdb/log/date. The database-level operations log can be accessed by querying the FSI_MESSAGE_LOG table. The Batch Run ID column can be filtered for identifying the relevant log.

To monitor the progress of the transformation program query the table FSI_MESSAGE_LOG with process ID and batch run ID as follows:

select * from fsi_message_log where a.process_id=<ProcessID> and batch_run_id=<Batch Run ID>;

Check the .profile file in the installation home if you are not able to find the paths mentioned above.