The Run Execution can be performed from the Command Line Interface with the following steps.
1. Navigate to the $FIC_HOME/ficdb/conf directory.
2. Enter the details for the following fields in the <RUN_NAME>.properties.template file:
§ FSDF Execution Run - FSDF_EXE_RUN.properties.template
and
§ FSDF Sourced Run - FSDF_SOURCED_RUN.properties.template
Details for <RUN_NAME>.properties.template file:
|
Name |
Description |
Example |
|
INFODOM |
Specify name of Information Domain (INFODOM) of Run Definition |
INFODOM=FSDFINF300 |
|
SEGMENT |
Specify the Folder Code / Segment Code of Run Definition |
SEGMENT=FSDFSEG |
|
RUN_CODE |
Specify the Run Code of the Run Definition |
RUN_CODE=FSDF_EXE_RUN Or RUN_CODE=FSDF_SOURCED_RU N |
|
USER_ID |
Specify the OFSAAI User ID for the Run Execution |
USER_ID=rrruser |
|
HIER_RCY |
Specify the Reporting Currency Hierarchy Code for the Run Execution |
HIER_RCY=[HFSDF002].[USD] (default value) |
|
HIER_LE |
Specify the Legal Entity Code for the Run Execution |
HIER_LE=WFCB |
|
HIER_CONSOHIER |
Specify the Consolidation Hierarchy for the Run Execution |
HIER_CONSOHIER=[HFSDF003].[ Default Org Structure Hierarchy] (default value) |
|
LIST_CONSOTYPE |
Specify the Consolidation Type for the Run Execution |
LIST_CONSOTYPE=<value> List of values accepted are: CONSL: Consolidated Run SOLO: Solo Run (default value) |
|
HIER_GAAP |
Specify the GAAP Code Hierarchy for the Run Execution |
HIER_GAAP=[HFSDF005].[USGAAP] |
|
HIER_BASELEXEID |
This is an optional Parameter. Only if OFSAA - BASEL Run Execution is completed. Specify the BASEL Run Execution Identifier Hierarchy for the BASEL Processed Output to FSDF Results. Format: [Hierarchy].[V_RUN_ID].[N_RU N_SKEY] |
HIER_BASELEXEID=[HFSDF004].[ 1234567890].[100] |
|
HIER_LRMEXEID |
This is an optional Parameter. Only if OFSAA - LRS Run Execution is completed. Specify the LRS Run Execution Identifier Hierarchy for the LRS Processed Output to FSDF Results. Format: [Hierarchy].[V_RUN_ID].[N_RUN_SKEY] |
HIER_LRMEXEID=[HFSDF006].[123 4567891].[101] |
|
HIER_FDICEXEID |
This is an optional Parameter. Only if OFSAA - LRS Run Execution is completed. Specify the LRS Run Execution Identifier Hierarchy for the LRS Processed Output to FSDF Results. Format: [Hierarchy].[V_RUN_ID].[N_RU N_SKEY] |
HIER_FDICEXEID=[HFSDF008].[1234567891].[101] |
|
HIER_LLFPEXEID |
This is an optional Parameter. Only if OFSAA - LLFP Run Execution is completed. Specify the LLFP Run Execution Identifier Hierarchy for the LLFP Processed Output to FSDF Results. Format: [Hierarchy].[V_RUN_ID].[N_RU N_SKEY] |
HIER_LLFPEXEID=[HFSDF007].[12 34567892].[102] |
|
RUN_EXE_COMMEN TS |
Specify the Comments for Run Execution |
RUN_EXE_COMMENTS=FSDF Results Run |
|
REQ_TYPE |
Specify the Type of Execution for Run |
REQ_TYPE=E List of Values Accepted are: E: Create Batch and Execute (default value S: Create Batch |
3. Navigate to $FIC_HOME/ficdb/bin directory.
4. Rename the .properties.template file to .properties. Changed file names are:
§ FSDF Execution Run - FSDF_EXE_RUN.properties
and
§ FSDF Sourced Run - FSDF_SOURCED_RUN.properties
5. Execute the following .sh file by passing two arguments.
ExecuteRunManagement.sh <file name> <execution date>
|
NOTE |
The execution date is in YYYYMMDD format. For example: 20171130 For example: ExecuteRunManagement.sh FSDF_EXE_RUN.properties 20171130 |
|
NOTE |
After successfully invoking the Run, the following messages are displayed. Wait till the newly created batch execution completes, and returns the status code for success or failure. Therefore, further action can be taken using autosys batch scheduler |
With REQ_TYPE=S, the message “Successfully created batch” is displayed in the console.
With REQ_TYPE=E, the message “Batch Triggered Successfully” is displayed in the console.
|
NOTE |
If any of the parameters in the FSDF_EXE_RUN.properties file is not entered correctly, the execution does not display the success message as above. |
The Batch execution status can be monitored through the Batch Monitor link from the OFSAA Application Interface and the relevant logs are generated under the $FIC_HOME/ficdb/log directory.
