5.21.2 Executing the Material Currency loader

There are two ways to execute the Material Currency Loader procedure: Running Procedure Using SQL*Plus and Material Currency Loader Procedure Using OFSAAI Batch Maintenance

1. To run the procedure from SQL*Plus, login to SQL*Plus as the Schema Owner:
   For example:
   SQLPLUS > declare
   result number;beginresult := fn_signf_currency_loader (‘ALMUSER’,’Y’,05,>,’USD’);
   end;
   /
   Here,

   • ALMUSER is the user Name for which the task is to be executed
   • Set the Off-balance sheet flag as ‘Y’ to enable off-balance sheet instruments, ‘N’ to disable them.
   • .05 is Material Currency Threshold. 05 is the threshold defined by BASEL norms but the parameter is configurable between [0,1], limits inclusive
   • Is Comparison Operator; valid choices include [>,>=,<,<=]
   • USD is reporting currency ISO code
2. To execute Material Currency Loader from OFSAAI Batch Maintenance, a seeded Batch <INFODOM>_MATERIAL_CURR_IDENTIFICATION is provided.
   The batch parameters are:

   • Datastore Type: Select the appropriate datastore from list.
   • Datastore Name: Select the appropriate name from the list.
   • IP address: Select the IP address from the list.
   • Rule Name: fn_signf_currency_loader
   • Parameter List: User Name, off-Balance Sheet Flag, Material Currency Threshold, Comparison Operator, and Reporting Currency Code (for description of the configurable paramters, see above)