Existing T2Ts

Existing T2Ts are modified to join the stage table and SETUP_ MASTER table, where the V_COMPONENT_VALUE = 'B' for Base Load and V_COMPONENT_VALUE = 'I' for Incremental Load for V_COMPONENT_CODE = 'LLFP_LOAD_TYPE'.

In the case of Base Load, even though changes are made to the existing T2Ts, seeded entries in the SETUP_ MASTER table works if the Load Run ID column value in the stage table contains the default value of 0. If the Load Run ID value in the stage table is a value other than 0, then update the BASE_LOAD_RUN_ID and EPM_LOAD_RUN_ID parameter value in the SETUP_MASTER table with the used Load Run ID value for the load. While using modified existing T2Ts, insert a complete snapshot of the data for a given MIS date. Merging of data is not supported with existing T2Ts. Re-execution for a given MIS date needs the deletion of data from instrument tables and execution of existing T2Ts. Deletion of data is not required for OFS LLFP processing tables. Seeded master batches are provided to execute the T2Ts in a single execution.

In the case of Incremental Load, registration of the "load run id" in the required tables are required which is explained in the below section.
  1. Generate the Load Run ID.
    • Execute the fn_register_load_run function
    • Input: Load Run Name, Load Purpose, Load Type
    • Output: generates Load Run ID in REV_LOAD_RUN_MASTER table
  2. Register the Load.
    • Execute the fn_register_load_details function
    • Input: Stage Table Name, Load Run ID, Load Run Name, Type Of Load
    • Output: REV_LOAD_RUN_DETAILS
  3. Load Data to stage table with generated Load Run ID.
  4. Execute the batch to load the data to the FSI_ACCOUNT_LOAD_RUN_MAP table:
    • Execute the fn_pop_load_run_map function
    • Input: STAGE_TABLE_NAME, LOAD_RUN_ID, LOAD_RUN_NAME
    • Output: FSI_ACCOUNT_LOAD_RUN_MAP
  5. Execute the incremental T2T to load the data into the processing table.
    • Input: FSI_ACCOUNT_LOAD_RUN_MAP, Stage Table
    • Output: Processing Table
  6. Mark the load manually as completed by updating the REV_LOAD_RUN_MASTER table.

    For more information, refer to the section Loading Multiple Load Runs in OFSAA in the Oracle Financial Services Data Foundation Application Pack.