1 Database Setup
This topic describes the database setup for Oracle Banking Cash Management Installation.
Pre-requisite
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
- PLATO_BATCH
- PLATO_PASSWORD
- COMMON_CORE
- PLATOALERTS
- PLATO_TRANSPORT
- PLATOORCH
- SMSCD0
- OBSCFCM_ACCOUNTING
- OBSCFCM_ALERTS
- OBSCF_BATCH
- OBSCFCM_CHARGES
- OBSCFCM_CORE_SERVICES
- OBSCFCM_FILTER
- OBSCFCM_INSTRUMENTS
- OBSCFCM_RECON
- OBSCFCM_REPORT
- OBSCFCM_WORKFLOWS_CONDUCTOR
- OBSCFCM_MASTER_MAINTENANCE
- OBSCFCM_FILE_PROCESSING
- OBCM_CASHFLOW_FORECASTING
- OBCM_CASHFLOW_PROJECTION
- OBCM_CASHFLOW_PREDICTION
- OBCM_COLLECTIONS_MASTERS
- OBCM_COLLECTIONS
- OBCM_NETTING
- OBCM_REPORT_SERVICES
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;