Using Command Line Utility

A command line utility ./wfExecExternal.sh is available in $FIC_DB_HOME/bin folder. To execute Pipeline using the command line utility:

  1. Navigate to $FIC_DB_HOME/bin folder.
  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 Pipeline.
  • processId - Process ID of the Pipeline. This is a mandatory parameter.
  • objectId - This is an auto-generated unique Object ID. Enter '$objectId' as 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.
  • 'securityparams' - Specify any security parameters within single quotes separated by comma.

For example:

./wfExecExternal.sh null 1492150193532 testRunStageDet null ERMINFO ERMUSER IFRSEG en_US '{"hierDetailsLE":[ {"hierValueCode":"MBB","value":"MBB", "hierNodeCode":"[HLLFP029].[MBBG].[MBB]"," leafCondition":"CASE WHEN DIM_ORG_STRUCTURE.f_latest_record_indicator = 'Y' THEN DIM_ORG_STRUCTURE.v_entity_code END='AU'", "hierNodeDesc":"MBB"}, {"hierValueCode":"MSL","value":"MSL","hierNodeCode":"[HLLFP029].[MBBG]. [MSL]","leafCondition":"CASE WHEN DIM_ORG_STRUCTURE.f_latest_record_indicator = 'Y' THEN DIM_ORG_STRUCTURE.v_entity_code END='AU'","hierNodeDesc":"MBL"}], "CONSOTYPE":"S","FIC_MIS_DATE":"2019-04- 19","V_RUN_MAIN_DESC":"TestStageDetRun"}' null

Note:

Null needs to be passed if you do not want to pass a value for a parameter.