1. Installation Guide
  2. Database Setup

1 Database Setup

This topic describes the database setup for Oracle Banking Liquidity Management Installation.

It is recommended to create different schema for each application. The below setup is designed to work with separate schema for each application.

Prerequisite

Before proceeding with the below setup, make sure that the required schemas are provided.

Note:

To know server’s port number, refer to Check Port Number section in Configuration & Deployment Guide.

Database Setup

Create the below list of Oracle Banking Liquidity Management schema's:

Table 1-1 Database Setup

Service Name Schema Required
oblm-batch-services OBLMXXXLMB
oblm-cash-concentration-services OBLMXXXLMC
oblm-dashboard-services OBLMXXXLMD
oblm-icl-services OBLMXXXICL
oblm-integration-services OBLMXXXLMX
oblm-maintenance-services OBLMXXXLMM
oblm-messaging-services OBLMXXXLMG
oblm-pool-services OBLMXXXLMX
oblm-report-services OBLMXXXLMR
oblm-rtl-services OBLMXXXLRT
oblm-structure-services OBLMXXXLMA
oblm-sweep-services OBLMXXXLMS
vamlm-charge-services OBLMXXXCHG

Note:

Refer to Migration of Schema for Existing Pool Structures for change in existing schema from LMP to LMX for oblm-pool-services.

Migration of Schema for Existing Pool Structures

For the optimal performance of Pool & Reallocation operation, existing pool structures data has to be migrated. Following are the actions to be taken:
  1. Update plato.properties set value = <<LMXSCHEMA>> where application = 'oblm-pool-services' and key = 'flyway.domain.schemas'.
  2. Deploy the OBLM Pool Service.
  3. The data from the tables mentioned above must be ported from existing pool schema (XXXLMP) to new schema (XXXLMX) for existing clients who have deployed oblm-pool-services
    • ERTB_MSGS
    • LMP_TB_POOL_CONTRIBUTION
    • LMP_TB_POOL_CONTRIBUTION_BVT
    • LMP_TB_POOL_LOG
    • LMP_TB_POOL_LOG_BVT
    • LMP_TB_POOL_LOG_SI
    • LMP_TB_POOL_POSITION
    • LMP_TB_POOL_POSITION_BVT
    • LMP_TB_POOL_POSITIONSI
    • LMP_TB_REALLOC_SYS_ACC_LINK
    • LMP_TB_REALLOCATION_DETAIL
    • LMP_TB_REALLOCATION_DETAILSI
    • LMP_TB_REALLOCATION_LOG
    • LMP_TB_REALLOCATION_LOGSI

User Grants

The following grants are provided to the user in the projection schema which is required in ML use cases.
  • GRANT CREATE MINING MODEL TO <PROJECTION SCHEMA>;
  • GRANT CREATE ANY MINING MODEL TO <PROJECTION SCHEMA>;
  • GRANT ALTER ANY MINING MODEL TO <PROJECTION SCHEMA>;
  • GRANT DROP ANY MINING MODEL TO <PROJECTION SCHEMA>;
  • GRANT SELECT ANY MINING MODEL TO <PROJECTION SCHEMA>;
  • GRANT COMMENT ANY MINING MODEL TO <PROJECTION SCHEMA>;
  • GRANT AUDIT ANY TO <PROJECTION SCHEMA>;
  • GRANT EXECUTE ON DBMS_DATA_MINING to <PROJECTION SCHEMA>;
  • GRANT CREATE TABLE TO <PROJECTION SCHEMA>
  • GRANT DROP TABLE TO <PROJECTION SCHEMA>