E.1 Customizing Scripts

For OFSAAI to execute the shell scripts, the customized scripts have to be placed in the ficdb layer.

The customized scripts should be placed under <Installed Path>ficdb/bin. When the customized scripts are called from OFSAAI, it appends the Batch Flag and Wait Flag parameters. This must be internally handled in the customized script to eliminate these additional parameters.

Note:

The Batch Flag and Wait Flag are the default parameters expected by the AAI Batch. For more information on these parameters refer the Oracle Financial Services Analytical Applications Infrastructure User Guide.
The following paths should be set inside the scripts:
  • MANTAS_HOME: The path where the solution is installed. For Example: /scratch/ofsaaapp/FCCM804
  • INGESTION_HOME: The path under installed area pointing to the ingestion_manager subsystem. For Example: /scratch/ofsaaapp/FCCM804/ingestion_manager
  • DB_TOOLS_HOME: The path under installed area pointing to database subsystem. For Example: /scratch/ofsaaapp/FCCM804/database/db_tools
  • BDF_HOME: The path under the installed area pointing to the BD subsystem. For Example: /scratch/ofsaaapp/FCCM804/bdf

    Note:

    BDF_HOME should be exported only if Ingestion has to be run through the BD subsystem.

After exporting the respective paths inside the script, the product script must be called from the customized script. For more information about how to create an OFSAA Batch and add a task for executing the custom script, refer to the Oracle Financial Services Analytical Applications Infrastructure User Guide.

Sample customized script for execute.sh is given below:
#!/bin/sh
if [[ $# == 0 || $# > 3 ]]; then
##echo "Usage: run_GD_dpdl.sh YYYYMMDD"
exit -1;
fi
export MANTAS_HOME=/scratch/ofsaadb/BD_801_BUILD2/BD_801C2WL
export BDF_HOME=$MANTAS_HOME/bdf
export DB_TOOLS_HOME=$MANTAS_HOME/database/db_tools
##export DIS_FILES=$HOME/GD_Scripts/disfile.cfg
export FILE_NAME=$1
$BDF_HOME/scripts/execute.sh $FILE_NAME
err=$?
if [ $err -ne 0 ]
then
echo " BDF Execution failed"
exit 1
fi

The above script is used to trigger BD Ingestion using execute.sh. This script expects only the file name (such as Account)as a parameter. Since AAI batch appends two additional default parameters (Batch Flag and Wait Flag) during batch execution, these should be handled inside the script and only the file name should be passed as a parameter. Internally this customized script calls the product script, execute.sh. Similarly, other scripts can also be customized.