Previous Next JavaScript must be enabled to correctly display this content

## 1 Replicate Mini Core to Common Core

User needs 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.