5.5.3 Executing the Prepayment Model Data Loader

You can launch the Data Loader from the following: Prepayment Models summary page, PL/SQL block, and Operations Batch

1. Prepayment Models summary page: To launch from the Prepayment Models summary page:
   1. Click the Data Loader icon on the Prepayment Models summary grid toolbar. A warning message will appear: Upload all available Prepayment Rates?
   2. Click Yes. The process will load all valid data included in the staging table.
2. PL/SQL block: To execute theLoader within a PL/SQL block:
   1. To run the function from SQL*Plus, log in to SQL*Plus as the Schema Owner. The loader requires following parameters:
      Batch Execution Name
      As Of Date
      Object Definition ID
      Load All
      Model Name
      Folder Name
      Syntax:
      fn_ppmt_rate_loader(batch_run_id VARCHAR2, mis_date VARCHAR2, pObject_Definition_ID NUMBER, pLoad_all CHAR default 'N', pModel_name VARCHAR2, pFolder_name VARCHAR2)
      Where:

      • BATCH_RUN_ID is any string to identify the executed batch.
      • As_of_Date is the execution date in the format YYYYMMDD.
      • Object Definition ID is the System Identifier of the Prepayment Model to which this data will be loaded.
      • Select Load All if you want to load all the prepayment Models.
      • Folder Name is the name of the Folder which holds the Prepayment Model. If the Prepayment Model System ID is provided, then populate this field with -1. If Folder name is provided, then provide Prepayment Model name as well.
      For Example:
      IF (P_OBJECT_DEFINITION_ID = -1) THEN PRC_STG_PPMT_MODEL_SYSID(P_OBJECT_DEFINITION_ID, P_AS_OF_DATE); ELSE IF P_LOAD_ALL = 'Y' THEN BEGIN SELECT DISTINCT V_PPMT_MDL, V_FOLDER_NAME BULK COLLECT INTO V_MODEL_FOLDER_NAME FROM STG_PPMT_MODEL_HYPERCUBE WHERE TO_CHAR(FIC_MIS_DATE, 'YYYYMMDD') = P_AS_OF_DATE AND N_PPMT_MDL_SYS_ID = -1; SELECT DISTINCT N_PPMT_MDL_SYS_ID BULK COLLECT INTO V_OBJECT_DEFINITION_ID FROM STG_PPMT_MODEL_HYPERCUBE WHERE TO_CHAR(FIC_MIS_DATE, 'YYYYMMDD') = P_AS_OF_DATE AND V_PPMT_MDL = '-1' AND V_FOLDER_NAME = '-1'; IF (V_MODEL_FOLDER_NAME.COUNT != 0) THEN FOR L_INDEX IN V_MODEL_FOLDER_NAME.FIRST .. V_MODEL_FOLDER_NAME.LAST LOOP PRC_STG_PPMT_MODEL_NAME(V_MODEL_FOLDER_NAME(L_INDEX).PPMT_MODEL_NAME, V_MODEL_FOLDER_NAME(L_INDEX).OBJECT_DEFN_FOLDER_NAME, P_AS_OF_DATE); END LOOP; END IF; IF (V_OBJECT_DEFINITION_ID.COUNT != 0) THEN FOR L_INDEX IN V_OBJECT_DEFINITION_ID.FIRST .. V_OBJECT_DEFINITION_ID.LAST LOOP PRC_STG_PPMT_MODEL_SYSID(V_OBJECT_DEFINITION_ID(L_INDEX), P_AS_OF_DATE); END LOOP; END IF; ELSE SELECT COUNT(*) INTO V_COUNT_CHECK FROM STG_PPMT_MODEL_HYPERCUBE WHERE V_PPMT_MDL = P_MODEL_NAME AND V_FOLDER_NAME = P_FOLDER_NAME AND TO_CHAR(FIC_MIS_DATE, 'YYYYMMDD') = P_AS_OF_DATE; IF V_COUNT_CHECK != 0 THEN PRC_STG_PPMT_MODEL_NAME(P_MODEL_NAME, P_FOLDER_NAME, P_AS_OF_DATE);
      The loader is executed for the given as of date. If the return value (NUM) is 1, this indicates the load completed successfully. Check the FSI_MESSAGE_LOG for more details.
3. Operations Batch: To run from Operations Batch framework:
   1. You can create a new Batch with the Component = 'TRANSFORM DATA'
   2. Specify the following parameters for the task:
      Datastore Type: Select appropriate datastore from list
      Datastore Name: Select appropriate name from the list
      IP address: Select the IP address from the list
      Rule Name: ppmt_rate_loader
      Parameter List: None
4. View the results.
   Any error messages are logged in the FSI_MESSAGE_LOG table. If you launch the Loader from the Prepayment Models Summary page or Operations Batch, you can view processing messages in OFSAAI in the Operations and select View Log UI, where the Component Type = Data Transformation and the Batch Run ID = the ID for your run. You can also spot check results of the load as follows: Query the FSI_PPMT_MODEL_HYPERCUBE table to confirm existence of the new rates. Use the Prepayment Model rule UI to select your rule and View your rates