5.18.4 Checking the Execution Status

The status of execution can be monitored using the Batch Monitor screen.

Note:

For a more comprehensive coverage of configuration & execution of a batch, see Oracle Financial Services Analytical Applications Infrastructure User Guide.

The status messages in batch monitor are :

N: Not Started

O: On Going

F: Failure

S: Success

The Event Log window in Batch Monitor provides logs for execution with the top row being the most recent. If there is any error during execution, it will get listed here. Even if you see Successful as the status in Batch Monitor it is advisable to go through the Event Log and re-check if there are any errors. The execution log can be accessed on the application server by going to the following directory $FIC_DB_HOME/log/date. The file name will have the batch execution id.

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.

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

Following messages will be available in the FSI_MESSAGE_LOG table after executing the batch.

Starting to update DIM_FINANCIAL_ELEMENT

Please provide application user name (In case OFSAAI application user name is not passed as a parameter).

Successfully Completed.

After successful execution of the batch, user can verify custom financial element present in DIM_FINANCIAL_ELEMENT table.