1. Credit Risk Analytics User Guide
  2. Input Data Preparation
  3. Batch Execution

3.2 Batch Execution

You must execute the individual batches for the Data Population. The batches are executed using the Operations Menu of the Oracle Financial Services Analytical Applications Infrastructure Application. See the OFS Analytical Applications Infrastructure User Guide, for more information on executing a batch.

The batches to be executed are as follows:
  • Dimension Table Population (<INFODOM>_CRA_DIMENSION_DATA_POP): Dimension Table Population Process refers to the process of moving the dimension data from the Processing Dimension tables to the Common Reporting Dimension tables shared by all of the OFSAA Business Intelligence (BI) Applications. The Dimension Table Population is handled by the Slowly Changing Dimension (SCD) Process and the Data Transformations (DT) Process. SCDs are used to maintain the history of Dimension Member changes over time.

    The Run Chart details the tasks executed when the dimension table population batch is executed. It also states the order in which the tasks are executed as mentioned in the Precedence Section of the Run Chart. See the OFS CRA Run Chart (MOS Document ID: 2017353.1), for more details on the individual tasks executed. You must update this batch after installing the application. Later, if the data undergoes any change or new data is updated, then the relevant tasks must be updated.

  • Common Data Population (<INFODOM>_CRA_CAS_POP): This batch is executed to populate data from the Stage Product Processors to the Fact Common Account Summary (FCT_COMMON_ACCOUNT_SUMMARY) tables. The Fact Common Account Summary table is a Common Fact table used by all the Oracle Financial Services Analytical Applications. This is a T2T functionality and the order in which the tasks are executed is stated in the Run Chart. You must execute this batch for each MIS date. If there is any mismatch with the data then all the records for that MIS Date must be deleted and data must be loaded again.
  • CRA - ALM Integration: This batch is executed only when the OFS ALM Cash Flows are considered for OFS CRA. You must execute the following batches for successful CRA - ALM Integration:
    • SCD2ALM2CRA2INTGRTION
    • ALM_CRA_Cashflows
  • Data Preparation (INFODOM_CRA_DATA_PREP): This ICC Batch is configured to contain party data tasks required for Enterprise Credit Risk Calculation. You must execute this batch whenever there is a change, or a new download is received for the tables listed under this batch.
  • Exchange Rate (<INFODOM>_CRA_BATCHDAILY): This ICC Batch is configured to contain Party Data Tasks required for Enterprise Credit Risk Calculation. You must execute this batch to populate the FSI_EXCHANGE_RATES table.
  • Instrument Data (<INFODOM>_CRA_SCDINSTRCONTRACT): Execute this task first time for the date for which data is available in the stage table (VW_STG_INSTRUMENT_CONTRACT). Ensure to execute this task, whenever data is modified, or new data is entered.
  • Reporting Table Population (<INFODOM>_CRA_BI_POPULATION): Execute this Run to move the data from the CRA Fact tables to the CRA Reporting tables, based on the date.
  • Customer Data (<INFODOM>_CRA_MAPPER_CUSTOMER_POP): Execute this batch to load data to the dim_customer table.