1 Mini Core to Common Core Replication

The topic provides the information on detailed approach to replicate Oracle FLEXCUBE Universal Banking Core data to Oracle Banking Origination Application Common Core.

The list of files required for the replication is available in the OSDC are:

Table 1-1 List of Replication Files

Service Name Domain Name
ubs_minicore_dblink.sql {unzip the file}Part2\OFLO_INITIAL_SETUP\INSTALL
ubs_minicore_replication.spc {unzip the file}Part2\OFLO_INITIAL_SETUP\INSTALL
ubs_minicore_replication.sql {unzip the file}Part2\OFLO_INITIAL_SETUP\INSTALL

To replicate the core data of Oracle FLEXCUBE Universal Banking to Oracle Banking Origination Application Common Core.

  1. Create the database link from the common core schema to the FLEXCUBE Universal Banking schema.

    Note:

    Refer to the Common Core Services Installation Guide for more details on the Common Core schema of the Oracle Banking Origination Application.

    Table 1-2 Samples

    Sample Value
    Sample Script ubs_minicore_dblink.sql
    Sample DB Link Name UBS144_MINICORE
    DB Link Name Used in Package UBS144
  2. Once the database link is created, execute a simple query: SQL > Select sysdate from dual@dblinkname;

    The value of MAINTENANCE_COUNTRY will be prompted while executing the script.

  3. Compile ubs_minicore_replication.spc and ubs_minicore_replication.sql in the common core schema of Oracle Banking Origination application.
  4. Execute the replication scripts as follows:
    1. Make sure that the Common Core services are installed.

      Note:

      This step will ensure the required common core entities are created in the Oracle Banking Origination Application. Refer to Common Core Services Installation Guide for more details.
    2. Execute the following commands in SQLPLUS or any other sql client connecting to the common core schema:

      Note:

      The script populates the common core tables from the host FLEXCUBE Universal Banking. If the data already exists in the common core tables, it updates.
      • SQL> exec ubs_minicore_replication.replicate_minicoreaccount;
      • SQL> exec ubs_minicore_replication.replicate_minicorebank;
      • SQL> exec ubs_minicore_replication.replicate_minicorebranch;
      • SQL> exec ubs_minicore_replication.replicate_minicoreccydefn;
      • SQL> exec ubs_minicore_replication.replicate_minicoreccyholidays;
      • SQL> exec ubs_minicore_replication.replicate_minicorecountry;
      • SQL> exec ubs_minicore_replication.replicate_minicorecustomer;
      • SQL> exec ubs_minicore_replication.replicate_minihostcodes;

      Note:

      Automation for the execution of these scripts and running periodically is out of scope for this guide.