Previous Next JavaScript must be enabled to correctly display this content

## 1 Database Setup

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

Prerequisite

Before you proceed with the document, ensure Schema’s are being created. It is recommended to have different schema for each application.

Database Schema Creation

Create the following database schema's. These schema names are recommended, but not mandatory.

- PLATO
- PLATO_UI_CONFIG
- PLATO_SECURITY
- PLATO_FEED
- PLATO_REPORT_SERVICE
- PLATORULE
- PLATOBATCH
- PLATO_PASSWORD
- COMMON_CORE
- PLATOALERTS
- PLATO_TRANSPORT
- PLATOORCH
- SMS
- OBRC
- PLATO_EDP
- OBSCFCM_ACCOUNTING
- OBSCF_BATCH
- OBSCFCM_CHARGES
- OBSCFCM_CORE_SERVICES
- OBSCFCM_FILTER
- OBSCFCM_INSTRUMENTS
- OBSCFCM_RECON
- OBSCFCM_REPORT
- OBSCFCM_WORKFLOWS_CONDUCTOR
- OBSCFCM_MASTER_MAINTENANCE
- OBSCFCM_GENAI_INTEGRATION
- OBCM_CASHFLOW_FORECASTING
- OBCM_CASHFLOW_PROJECTION
- OBCM_CASHFLOW_PREDICTION
- OBCM_COLLECTION_MAINT
- OBCM_COLLECTIONS
- OBCM_REPORT_SERVICES
- SFS_ALERTS
- SFS_FILTER
- OBSCFCM_ARCH

Note:

For creating database schemas, refer to Database Schema Creation section in Configuration and Deployment Guide.

View Creation Grants (Oracle Banking Cash Management Cashflow Prediction)

The following grants are provided for Oracle Banking Cash Management Cashflow Prediction:

- grant create mining model to OBCM_CASHFLOW_PREDICTION;
- grant create any mining model to OBCM_CASHFLOW_PREDICTION;
- grant alter any mining model to OBCM_CASHFLOW_PREDICTION;
- grant drop any mining model to OBCM_CASHFLOW_PREDICTION;
- grant select any mining model to OBCM_CASHFLOW_PREDICTION;
- grant comment any mining model to OBCM_CASHFLOW_PREDICTION;
- grant execute on DBMS_DATA_MINING to OBCM_CASHFLOW_PREDICTION;
- grant create view to OBCM_CASHFLOW_PREDICTION;
- grant create table to OBCM_CASHFLOW_PREDICTION;
- grant drop table to OBCM_CASHFLOW_PREDICTION;
- grant create job to OBCM_CASHFLOW_PREDICTION;
- ALTER USER OBCM_CASHFLOW_PREDICTION ENABLE EDITIONS;