1 Replicate Mini Core to Common Core

You need to replicate the core data of FLEXCUBE Universal Banking to the common core of the Oracle Banking Microservices Architecture application as a part of the initial setup.

The following files are required for the replication, and these files are available in the OSDC.

Table 1-1 List of Services

Service Name	Domain Name
ubs_minicore_dblink.sql	{unzip the file}OBBRN_INITIAL_SETUP\
ubs_minicore_replication_obbrn.spc	{unzip the file}OBBRN _INITIAL_SETUP\
ubs_minicore_replication_obbrn.sql	{unzip the file}OBBRN _INITIAL_SETUP\

To replicate the core data of FLEXCUBE Universal Banking to the common core of Oracle Banking Microservices Architecture:

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

   Note:

   For more details on the common core schema of the Oracle Banking Branch, refer to Common Core Services Installation Guide.
   The sample script and DB link name are provided below:

   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 as follows:

   SQL > Select sysdate from dual@dblinkname;

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

3. Specify the details to execute the script.
   For example, MAINTENANCE_COUNTRY = GB.
4. Compile ubs_minicore_replication_obbrn.spc and ubs_minicore_replication_obbrn.sql in the common core schema of Oracle Banking Branch.
5. 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 Branch. Refer to the Common Core Services Installation Guide.
   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.

      • exec ubs_minicore_replication.replicate_minicoreaccount;

      • exec ubs_minicore_replication.replicate_minicorebank;

      • exec ubs_minicore_replication.replicate_minicorebranch;

      • exec ubs_minicore_replication.replicate_minicoreccydefn;

      • exec ubs_minicore_replication.replicate_minicoreccyholidays;

      • exec ubs_minicore_replication.replicate_minicorecountry;

      • exec ubs_minicore_replication.replicate_minicorecustomer;

      • exec ubs_minicore_replication.replicate_minihostcodes;

      • exec ubs_minicore_replication.replicate_ccyratemaster;

      • exec ubs_minicore_replication.replicate_miniglcode;

      • exec ubs_minicore_replication.replicate_ccypairdef;

      • exec ubs_minicore_replication.replicate_minitrncode;

      • exec ubs_minicore_replication.replicate_ccyratetype;

      • exec ubs_minicore_replication.replicate_bicdirectory;

      • ubs_minicore_replication.replicate_minicoredeposit_accounts;

      Note:

      Automation of these scripts execution and running periodically is out of scope of this topic.