B.2 Create/Execute LRM Batch from Command Line

To generate the execution IDs the following steps can be followed by passing all requisite parameters at command line. Perform the following steps, to create or execute LRM batch from command line:

1. Navigate to $FIC_APP_HOME/icc/bin path and open lrmExecParams.properties.
2. Provide all the required parameters. All Parameters are mandatory, except for the Contractual Run Execution ID which is required in case of BAU / Stress Run.
   1. RUNID:
   • In case of Contractual Run and BAU Run, the N_RUN_OBJECT_ID (FSI_LRM_RUN_PARAM.N_RUN_OBJECT_ID) of the run definition you are trying to execute.

     Example: If the name of the Run definition created is 'TEST2131', execute the below query to get the n_run_object_id

     SELECT T.N_RUN_OBJECT_ID FROM FSI_LRM_RUN_PARAM T WHERE T.V_RUN_NAME LIKE 'TEST2131';

   • In case of Stress Run, the ID of the Stress Run created (ST_STRESS_MASTER.V_STRESS_ID)
   1. RUNTYPE: The type code of the Run to be executed is as follows:
      10:- Contractual Run; 11:- BAU Run; 12:- Stress Run
   1. INFODOM: Enter the name of the INFODOM which is in use.
   1. FICMISDATE: Enter FIC MIS date to be used for execution.
   1. RUNEXECDESC: Enter the description for the execution.
   1. CONTRAEXECID: In case of BAU/Stress Run, enter the ID of the Contractual Run execution to be used. The following query can be used to find the various Contractual Run Execution IDs:

      Note:

      Choose any value of ITEM_ID column as an input for "CONTRAEXECID" from the result of the query.

      
      

      

      
      
   1. REPCURRENCY: Enter the code of the reporting currency to be used. The currency code can be found using the following query:
      SELECT V_ISO_CURRENCY_CD, V_CURRENCY_NAME FROM DIM_CURRENCY ORDER BY UPPER(V_CURRENCY_NAME)
   1. EXCHGRATESRC: Enter the code of the exchange rate source to be used. The code can be found using the following query:
      SELECT LOOKUP_CD, LOOKUP_DESCRIPTION FROM FSI_LRM_LOOKUP_TL T WHERE T.CATEGORY_ID = 19
   1. LCRHORIZON: Enter the LCR Horizon (in days) to be used. The default provided is 30.
   1. USER: Enter the OFSAA application user name.
   1. EXECUTE: Enter Y/N. Here, Y= Execute Run and N=Create Batch Only.
3. Run the lrmBatch.sh file to create or execute a batch. Provide the input parameter as EXECUTE=Y to execute the batch.
4. Ensure that the wsdl URL is replaced with correct values in LRMWSservices.properties file under $FIC_APP_HOME/icc/lib LRM_WSDL_LOCATION=$PROTOCOL$://$WEBSERVERHOST$:$WEBSERVERPORT$/$CONTEXT$/lrmService?wsdl.