3 Setup Database
This topic provides detailed information about database related configuration for Oracle Banking Enterprise Limits and Collateral Management Installation.
It is recommended to create different schema for each application.
The prerequisites for setting up the database are as follows:
- Complete the pre-installation setup. The pre-installation setup includes configuring the database and setting up the setUserOverrides.sh file.
- After creating the schema for each of the required micro services, we compile DDLs and INCs of each micro-service in the respective schemas. The DDLs and INCs ensure that the creation of tables and availability of static data required for the execution of services. Flyway compiles these automatically.
To set up a database for the creation of Oracle Banking Enterprise Limits and Collateral
M/kjanagement schema:
Table 3-1 Database Setup
| Service Name | Schema Required |
|---|---|
| obelcm-common-maintenance-services | Yes (OBELCM_COMMON schema) |
| obelcm-limits-maintenance-services | Yes (OBELCM_LIMITS schema) |
| obelcm-collateral-maintenance-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-exposure-maintenance-services | Yes (OBELCM_EXPOSURES schema) |
| obcc-core-services | Yes (OBCCCORE schema) |
| covenant-services | Yes (OBCC_COVENANTS schema) |
| terms-conditions-services | Yes (OBCC_TERMSCONDITIONS schema) |
| obelcm-limits-utilization-services | Yes (OBELCM_LIMITS schema) |
| obelcm-collaterals-utilization-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-limits-kafka-consumer-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-limits-currency-reval-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-facility-transfer-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-facility-earmarking-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-exposure-block-batch-services | Yes (OBELCM_EXPOSURES schema) |
| obelcm-pp-facility-nonrev-closure-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-facility-untanking-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-facility-stats-master-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-liab-tanking-untanking-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-facility-expiry-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-facility-fee-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-facility-activation-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-facility-schedules-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-facility-gebsuval-batch-services | Yes (OBELCM_LIMITS schema) |
| obelcm-pp-coll-activation-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-coll-perfection-status-batch-services | Yes (OBELCM_COLLATERALS schema) |
| Yes (OBELCM_COLLATERALS schema) | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-coll-tanking-untanking-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-charge-expiry-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-child-reval-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-eca-accounting-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-enddate-reval-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-expiry-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-facility-master-batch-service | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-fee-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-haircut-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-pool-reval-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-reval-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-collateral-util-reval-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-colpool-tanking-untanking-batch-services | Yes (OBELCM_COLLATERALS schema) |
| obelcm-pp-common-notification-batch-services | Yes (OBELCM_COMMON schema) |
| obelcm-pp-common-ofsaa-batch-services | Yes (OBELCM_COMMON schema) |