Previous Next JavaScript must be enabled to correctly display this content

## 6 Initial Setup

This topic describes the initial setup for Oracle Banking Virtual Account Management Installation.

Once everything is deployed, run the CMC and SMS initial setup scripts from the below OSDC path to create the required maintenances.

- `obvam_initial_setup / cmc_initial_setup.sql`

  To be compiled in Common Core schema

- `obvam_initial_setup / sms_initial_setup.sql`

  To be compiled in SMS schema

CMC Initial Setup

This script would prompt a user to enter the below values.

Table 6-1 CMC Initial Setup - Field Description

Serial Number | Field | Description
--- | --- | ---
1 | Bank Code | A four letter Bank Code
2 | Bank Description | Description of the Bank Code
3 | Branch Code | A three letter Branch Code
4 | Branch Name | Name of the Branch
5 | Branch Address Line 1 | Address line 1 of the branch
6 | Branch Address Line 2 | Address line 2 of the branch
7 | Branch Address Line 3 | Address line 3 of the branch
8 | Branch Currency | A three letter ISO Currency Code
9 | Country Code | A two letter ISO Country Code
10 | Walk-In Customer | Walk-in customer number
11 | Host Code | Host code of the Branch
12 | Host Description | Host code description
13 | Host Process Time Zone | Host code time zone (GMT+5.30)
14 | Source System | External source system
15 | Source System Description | Source system description
16 | Source System Branch | Branch code as in the source system
17 | Previous Working Day | Previous working day of the Branch
18 | Current Working Day | Current working day of the Branch
19 | Next Working Day | Next working day of the Branch

SMS Initial Setup

This script would prompt the user to create two admin users.

Table 6-2 SMS Initial Setup - Field Description

Serial Number | Field | Description
--- | --- | ---
1 | User Login ID 1 | Login ID of the first User
2 | User Name 1 | Name of the first User
3 | User Login ID 2 | Login ID of the second User
4 | User Name 2 | Name of the second User
5 | Users Home Branch Code | A three letter Home-Branch Code of the users
6 | Users Locale | Users locale (2 letter ISO country code)
7 | Start Date | Start date
8 | End Date | End date

These users are assigned the default ADMIN_ROLE, and the below functional activities are mapped.

1. SMS_FA_USER_NEW
2. SMS_FA_USER_AMEND
3. SMS_FA_USER_CLOSE
4. SMS_FA_USER_REOPEN
5. SMS_FA_USER_DELETE
6. SMS_FA_LOAN_DASHBOARD_PREFERENCE
7. SMS_FA_USER_VIEW
8. SMS_FA_USER_AUTHORIZE
9. SMS_FA_ROLE_NEW
10. SMS_FA_ROLE_AMEND
11. SMS_FA_ROLE_CLOSE
12. SMS_FA_ROLE_REOPEN
13. SMS_FA_ROLE_DELETE
14. SMS_FA_LOAN_DASHBOARD_PREFERENCE_PUT
15. SMS_FA_ROLE_VIEW
16. SMS_FA_ROLE_AUTHORIZE
17. SMS_FA_LOAN_DASHBOARD_VIEW
18. SMS_FA_APPLICATION_VIEW
19. SMS_FA_MENU_DASHBOARD_VIEW
20. CMC_FA_EXT_BRANCH_PARAMETERS_LOV
21. CMC_FA_EXT_BRANCH_PARAMETERS_VIEW
22. CMC_FA_EXT_BANK_PARAMETERS_VIEW
23. CMC_FA_EXT_BANK_PARAMETERS_LOV
24. CMC_FA_SYSTEM_DATES_VIEW
25. CMC_FA_CURRENCY_DEFN_VIEW
26. CMC_FA_LOCAL_HOLIDAY_VIEW
27. CMC_FA_LANGUAGE_CODE_VIEW

LDAP Setup

The users created using the SMS script must also be created in the LDAP server.

Note:

For LDAP setup, refer to Configuration and Deployment Guide.