B.3 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. Follow these steps, to create or execute LRM batch from command line:
  1. Navigate to the $FIC_APP_HOME/icc/bin directory and open the lrmExecParams.properties file.
  2. Provide all the required parameters. All Parameters are mandatory, except for the Contractual Run Execution ID which is required only for BAU Run.
    1. RUNID:
      • For 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 following 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';

    2. RUNTYPE: The type code of the Run to be executed is as follows:
      • 10: Contractual Run; 11: BAU Run;
    3. INFODOM: Enter the name of the INFODOM which is in use.
    4. FICMISDATE: Enter the FIC MIS date to be used for execution.
    5. RUNEXECDESC: Enter the description for the execution.
    6. CONTRAEXECID: For BAU, 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.

      Figure B-1 CONTRAEXECID


      CONTRAEXECID

    7. 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)

    8. 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

    9. LCRHORIZON: Enter the LCR Horizon (in days) to be used. The default provided is 30.
    10. USER: Enter the OFSAA application user name.
    11. 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 the LRMWSservices.properties file under the $FIC_APP_HOME/icc/lib LRM_WSDL_LOCATION=$PROTOCOL$://$WEBSERVERHOST$:$WEBSERVERPORT$/$CONTEXT$/lrmService?wsdl directory.