Previous Next JavaScript must be enabled to correctly display this content

## 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 and 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-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>