1. Installation Guide
  2. Initial Setup

5 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 5-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 5-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 ANNEXURE-1.