Database link Creation

A database link is required to be created from the Common Core Schema to the Oracle FLEXCUBE Universal Banking Schema.

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

ubs_minicore_dblink.sql is a sample script. The sample DB Link name used is UBS144_MINICORE.

Once the database link is created, execute a simple query: SQL > Select sysdate from dual@dblinkname;

Compiling the DB objects

Compile ubs_minicore_replication.spc and ubs_minicore_replication.sql in the common core schema of Oracle Banking Origination application.

Execute the Replication scripts

Make sure that the Common Core services are installed first. This 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.

Execute the following commands in SQLPLUS or any other sql client connecting to the common core schema. The script populates the common core tables from the host FCUBS. In case 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;