1 Set up Database

User needs to setup the database-related configuration for the installation of the Oracle Banking Retail Lending Servicing. It is recommended to create a different schema for each application.

The prerequisites for setting up the database are as follows:

  1. Make sure that the pre-installation setup is completed. The pre-installation setup includes the configuration of the database and setting up the setUserOverrides.sh file.

  2. Configure the placeholders in the setUserOverrides.sh file for Oracle Banking Retail Lending Servicing installation. For the values of keys and placeholders, refer to Keys and Placeholders.

    Note:

    To update the placeholders for Oracle Banking Microservices Architecture services, refer to Placeholder Update for Oracle Banking Microservices Architecture Services section in Configuration and Deployment Guide.

The setup is designed to work with a separate schema for each application.

To setup the database for Oracle Banking Retail Lending Servicing:

  1. Create the Oracle Banking Retail Lending Servicing schemas. For information on schemas to be created, refer to the table below:

    Table 1-1 Database Setup

    Service Name Schema Required
    obrl-ln-maintenance-services Yes(RL_MAINTENANCE Schema)
    obrl-ln-lending-product-services Yes(RL_MAINTENANCE Schema)
    obrl-ln-product-segment-services Yes(RL_MAINTENANCE Schema)
    obrl-ln-account-services Yes (RL_ACCOUNT schema)
    obrl-ln-amendment-services Yes (RL_ACCOUNT schema)
    obrl-ln-payment-services Yes (RL_ACCOUNT schema)
    obrl-ln-restructure-maintenance-services Yes(RL_MAINTENANCE Schema)
    obrl-ln-restructure-services Yes (RL_ACCOUNT schema)
    obrl-ln-migration-services Yes (RL_MIGRATIONschema)
  2. Create the user grants. For more information on creating user grants, refer to Create User Grants.
  • Keys and Placeholders
    The values of the keys and their respective placeholders need to be configured in the setUserOverrides.sh file for installation of the Oracle Banking Retail Lending Servicing.
  • Create User Grants
    User needs to create the user grants in the necessary schemas to setup the database-related configuration for Oracle Banking Retail Lending Servicing.