9.5.2 Execute the Runs Using Command Line Utility

A command line utility ./wfExecExternal.sh is available in $FIC_DB_HOME/bin folder.

To execute the Run Pipeline using the command-line utility :

  1. To execute the Run Pipeline using the command-line utility :
  2. 2. Execute the script file using the following command: ./wfExecExternal.sh processInstanceId processId '$objectId' objectType infodom userID segment locale 'applicationparams' 'securityparams'
    • processInstanceId - Instance Id of the Process or Run Pipeline
    • processId - Process ID of the Run Pipeline. This is a mandatory parameter.
    • objectId - This is an auto-generated unique Object ID. Enter '$objectId' as a mandatory parameter value.
    • objectType - Specify the Object Type if it is defined in the aai_wf_app_definition_map table.
    • infodom - Information Domain Name
    • userID - Specify the user ID
    • segment - Segment Name
    • locale - Locale selected. For example, en_US
    • 'applicationparams'- Specify values for the Run execution parameters stored in APP_COMP_ATTR_MAP_ID within single quotes separated by a comma.
      • Legal Entity – This name of the Legal Entity. This is a mandatory parameter.
      • Data Source Code – This is the numeric value of the data source code.
    • 'securityparams'- Specify any security parameters within single quotes separated by comma.

      For example:./wfExecExternal.sh null DL_AVG_BAL_COMP_ML '$objectId' null FSDFINFO BCEUSER BFNDSEG en_US '{"hierDetailsLE":[{"hierValueCode":"1","value":"YourLegalEntityName","hierNodeCode":"1","leafCondition":"CASE WHEN DIM_ORG_STRUCTURE.F_LATEST_RECORD_INDICATOR = 'Y' THEN DIM_ORG_STRUCTURE.N_ENTITY_SKEY END='1'","hierNodeDesc":"YourLegalEntityName"}],"FIC_MIS_DATE":"2019-12-30","V_RUN_MAIN_DESC":"test","hierDetailsDATA_ORIGIN":[{"hierValueCode":"3","value":"SFT","hierNodeCode":"3","leafCondition":"DIM_DATA_ORIGIN.N_DATA_SOURCE_CD = '21'","hierNodeDesc":"STL"}]}' null

    Note:

    • Users must pass the value for parameters same as that was passed in the User Interface.
    • Null should be passed if users do not want to pass the value for a parameter.

    For more details to execute the rules using command line utility see section Using Command Line Utility in the the Oracle Financial Services Analytical Applications Infrastructure Process Modelling Framework Orchestration Guide.