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',0.05,'>','USD',200203,'100',6,5011);
    end;
    /
    Here,
    • User Name: ALMUSER is the user Name for which the task is to be executed
    • Off-Balance Sheet Flag: Set the Off-balance sheet flag as ‘Y’ to enable off-balance sheet instruments, ‘N’ to disable them.
    • Material Currency Threshold: .05 is Material Currency Threshold. 05 is the threshold defined by BASEL norms but the parameter is configurable between [0,1], limits inclusive
    • Comparison Operator: Is Comparison Operator; valid choices include [>,>=,<,<=]
    • Reporting Currency Code: USD is reporting currency ISO code
    • LE Hierarchy Id (Optional): Numeric Id of Legal Entity hierarchy to be used must be given. It accepts only a single hierarchy ID. If this parameter is provided, LE Id_list must be either NULL or contain only one Legal Entity ID.
    • LE Id list (Optional): If LE Hierarchy Id is not provided, LE Id list can contain either a single Legal Entity ID or multiple IDs in a comma-separated format. Example: ‘1,2,3,4’. If LE Hierarchy Id is provided, then LE Id list must contain only one value of either node or leaf member present in hierarchy. Example: ‘1’.
    • Product Dimension Id (Optional): Numeric Id of custom key processing dimension to be used.
    • Common COA Attribute Id (Optional): Numeric Id of the Common Chart of Account attribute of the dimension given in Product Dimension Id. This will be used to identify asset and liability instruments. If value is given for Product Dimension Id then Common COA Attribute Id is mandatory.
  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, Reporting Currency Code, LE Hierarchy Id, LE Id list, Product Dimension Id, and Common COA Attribute Id (for description of the configurable paramters, see above)