10.2.4.4 Checking the Execution Status
The status of execution can be monitored using the Batch Monitor window of the OFSAAI Operations module.
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.
Alternatively, the execution log can be accessed on the application server
in 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. (This is the same log you see in the Event Log
window).
Check the .profile
file in the installation home if you are
unable to navigate to the above-mentioned locations.
Change of Product Dimension can also be directly executed on the database through SQLPLUS.
Details are:
- Function Name: FN_ALM_BI_SET_USER_DEF_DIM
- Parameters: BATCH_RUN_ID, MIS_DATE, DIMTABLENAME
- SOURCECOLNAME, MEMBERCOLNAME, and SKEYCOLNAME
Sample Parameter Values: 'Batch1' , '20130310' , ' DIM_TM_COA_ID', 'N_TM_COA_ID', 'TM_COA_ID', and 'N_TM_COA_SKEY'.