OFSLL SETUP CONFIGURATION GUIDE

This document includes following topics:

Introduction

The purpose of the OBDX OFSLL Installation Guide is to provide a step by step overview on the installation process of the solution.

It Includes:

  1. Installation of OBDX 18.1.0.0.0 OFSLL with Oracle’s own Core Banking and Origination Products.

Prerequisites

OBDX 18.1.0.0.0 with OBPClosedOracle Banking Platform BASE flavor should be installed through OBDX Installer. This installation will be henceforth referred to in this manual as ‘OBDX18.1 Base’.

For OBDX 18.1 Base installation, refer documents mentioned in section 1.5 Related Information Sources.

Installation

Pre Installation

OBDX18.1.0.0.0 Base wi;th OBP flavor should be installed through installer.

Preference

Changes in preference.xml: (refer /config/preference.xml).

Preference EnumerationConfig should override preference EnumerationConfigOFSLL143 as given below.

<Preference

name="EnumerationConfig" overriddenBy="EnumerationConfigOFSLL143"

PreferencesProvider="..

/>

Preference CustomBusinessPolicyPreferences should override preference CustomBusinessPolicyPreferencesOFSLL143 as given below.

<Preference

name="CustomBusinessPolicyPreferences" overriddenBy="CustomBusinessPolicyPreferencesOFSLL143" PreferencesProvider="..

/>

Preference OriginationConfig should override preference OriginationConfig_ofsll143 as given below.

<Preference

name="OriginationConfig"

overriddenBy="OriginationConfig_ofsll143"

PreferencesProvider="..

/>

 

OFSLL Setup Configuration

Steps of installation

Download and extract. Post extraction ‘OBDX_LZNInstaller’ folder would be available.

Ensure before installation following sub-directories are available

Application deployment

The ‘app’ directory will have 3 artifacts to be deployed on the OBDX 18.1.0.0.0 Base Application server.

Note: First shut down the application server. Go to deployments. Un-deploy the REST application project of the OBDX 18.1.0.0.0 Base and deploy REST application project of the OBDX 18.1.0.0.0 US LZN, two libraries (ii & iii) and an application (iv) as mentioned above. All other libraries of OBDX 18.1.0.0.0 Base are required for OBDX OFSLL setup. Do not remove them. Start the application server.

Steps to Un-deploy library/application

  1. Login into Weblogic Server. Go to Deployments. Select the library / application and click on delete.

OFSLL Setup Configuration

  1. Confirm delete.

OFSLL Setup Configuration

  1. Success message will be displayed.

OFSLL Setup Configuration

Steps to Deploy library / application:

  1. Click on install to deploy library / application. Click on Upload Button.

OFSLL Setup Configuration

  1. Click on ‘Choose File’ to select the library / application to upload.

OFSLL Setup Configuration

 

OFSLL Setup Configuration

  1. Click on NEXT button.

OFSLL Setup Configuration

  1. Again click on NEXT button.

OFSLL Setup Configuration

  1. Select ‘Install as library / application’, as per the deployment.

OFSLL Setup Configuration

  1. Select the managed server / cluster to deploy on. Click on Next.

OFSLL Setup Configuration

  1. Click on Finish

OFSLL Setup Configuration

  1. Confirmation of installation will be displayed.

OFSLL Setup Configuration

Deployments after OBDX18.1.0.0.0 Base Installation

OFSLL Setup Configuration

OFSLL Setup Configuration

Deployments after OBDX 18.1.0.0.0 OFSLL Installation

OFSLL Setup Configuration

OFSLL Setup Configurration

Security credential mapping for connector.ear

Please follow following steps

  1. Login into Weblogic console.
  2. Click on Deployments.
  3. Expand by clicking ‘+’ icon present in front of com.ofss.digx.app.connector application as shown below.

OFSLL Setup Configuration

  1. Click com.ofss.digx.connector.rar as shown below.

OFSLL Setup Configuration

  1. Click ‘Security’ tab and then click ‘Outbound Credential Mappings’ sub tab as shown below.

OFSLL Setup Configuration

  1. Click on ‘New’ Button. Following screen will be appearing.

OFSLL Setup Configuration

  1. Select ‘ra/DIGXConnectorAES’ and click then ‘Next’ button. Following screen will be appearing.

OFSLL Setup Configuration

  1. Select ‘Default User’ and then click ‘Next’ button. Following screen will be appearing.

OFSLL Setup Configuration

  1. Enter following details and then click ‘Finish’ button
  2. EIS User Name > AES_KEY
  3. EIS Password > OBDX_PASSWORD123
  4. Confirm Password > OBDX_PASSWORD123
  5. Restart the manage server to activate the changes.

BI credential mapping for connector.ear

Please follow following steps

  1. Login into Weblogic console.
  2. Click on Deployments.
  3. Expand by clicking ‘+’ icon present in front of com.ofss.digx.app.connector application as shown below.

OFSLL Setup Configuration

  1. Click com.ofss.digx.connector.rar as shown below.

OFSLL Setup Configuration

  1. Click ‘Security’ tab and then click ‘Outbound Credential Mappings’ sub tab as shown below.

OFSLL Setup Configuration

  1. Click on ‘New’ Button. Following screen will be appearing.

OFSLL Setup Configuration

  1. Select ‘ra/DIGXConnectorBIREPORTS’ and click then ‘Next’ button. Following screen will be appearing.

OFSLL Setup Configuration

  1. Select ‘Default User’ and then click ‘Next’ button. Following screen will be appearing.

OFSLL Setup Configuration

  1. Enter administrative authentication credentials of BIP and then click ‘Finish’ button.
  2. Restart the manage server to activate the changes.

Database scripts deployment

The ‘db’ directory will have two sub-directories: dml and ddl. Executes all scripts present in the dml folder

Note: There are no ddl scripts to execute.

UIClosedUser Interface deployment

The ‘ui’ directory contains all the UI related files. The UI deployed by OBDX 18.1.0.0.0 Base installation should be replaced by the UI contents of this directory.

Note: No change required in OHS.

Database configuration

Following configurations need to be done post installation

System Configuration

Please complete day one maintenance from admin screen. Please refer ‘User Manual Oracle Banking Digital Experience System Configuration.docx’ document for day one maintenance. These are mandatory configurations for application to work. It should be completed before using the application.

table ‘digx_me_ep_conf_b’

Query to be executed

Description

UPDATE DIGX_ME_EP_CONF_B SET MULTI_ENTITY_CODE='GLBL_NMKT', FROM_ADDR=’<system_email_id>’ WHERE MULTI_ENTITY_CODE ='OBP_ME' and Destination_type='EMAIL';

This property is used to provide system’s email id. All system generated mails will be come from this id.

Additional (functional) Configurations

These are non-mandatory configurations. Default values for these configurations are available through day 0 scripts. Bank can change these values as per their business need

Table ‘digx_fw_config_var_b’

Category ID

Property ID

Description

OriginationUserRole

USER_ROLE_CUSTOMER

Default roles for Origination user creation. The prop_id does not matter. All roles for category_id 'OriginationUserRole' would be assigned to the created user.

OriginationConfig

ORG_DOB_AGE_LIMIT_CHECK

Whether DOB check is local or to be done remotely. Possible values are LOCAL or REMOTE. For this setup it will be REMOTE.

OriginationConfig

ORG_DOB_AGE_LIMIT

DOB Age Limit Value. In case the above property value is LOCAL, the age limit in number is to be specified for this property.

OriginationConfig

USERNAME_TYPE

 Username type while registering the prospect. Possible values EMAIL/OTHERS

OriginationConfig

LIST_CANCELLATION_DAYS

SubmissionClosedA submission contains one or more applications submitted by the applicants in a single request. Cancellation List Range. This value will be used in Report Generation for Cancelled Applications. This property indicates the number of days for which the cancellation report will be generated.

OriginationConfig

ORIG_PI_EMAIL_VERIFICATION_REQUIRED

If Email Verification via OTP is required

OriginationConfig

CONTENT_UPLOAD_ALLOWED_TYPE_LIST

File types allowed for document uploading.

Example:- .txt,.png,.xlsx,.doc,.pdf,.jpeg,.jpg

OriginationConfig

CONTENT_UPLOAD_MIME_TYPES_WHITE_LIST

Allowed MIME types for file uploading.

Example:- application/pdf,image/jpeg,image/png

OriginationConfig

CONTENT_UPLOAD_MIME_TYPES_ZIP_LIST

Allowed MIME types for uploading zip document.

Example:- application/x-compressed

OriginationConfig

DRIVING_LICENSE_EXPIRY_DURATION

Value should be in years.

Driving License expiry date should be less than current date + this value

OriginationConfig

DRIVING_LICENSE_MAX_LENGTH

Driving License number’s maximum length allowed

OriginationConfig

EMPLOYMENT_STABILITY_MONTH_DURATION

Value should be in months.

This value is used to decide employment stability

OriginationConfig

IS_REGISTRATION_MANDATORY

This flag used to force mandatory channel registration while submitting application.

OriginationConfig

MAX_ALLOWED_VEHICLE_AGE

Maximum age allowed for vehicle

OriginationConfig

ORG_REG_LINK_TIMEOUT

Channel registration link time out value

OriginationConfig

ORIGINATION_WORKFLOW_LOADER

Workflow loader configuration

OriginationConfig

VEHICLE_MILEAGE_MAX_LIMIT

Maximum mileage of used vehicle needs to be captured

OriginationConfig

VEHICLE_YEAR_MAX_LIMIT

Maximum duration of used vehicle needs to be captured

OriginationConfig

RESIDENT_STABILITY_MONTH_DURATION

Value should be in months.

This value is used to decide residential stability

OriginationConfig

SSNClosedSocial Security Number_MAX_LENGTH

Maximum length allowed for Social Security Number

OriginationConfig_ofsll143

DEALER_ID

Dealer Id present in OFSLL application

OriginationConfig_ofsll143

LENDER_ID

Lender Id present in OFSLL application

OriginationConfig_ofsll143

LENDER_DEALER_ID

Lender Dealer Id present in OFSLL application.

OriginationConfig_ofsll143

COMPANY_CODE

Company Code present in OFSLL application

OriginationConfig_ofsll143

BRANCH_CODE

Branch Code present in OFSLL application.

OriginationConfig_ofsll143

DATA_REQUIRED_FOR_SUBMISSION

Indicates if submission data should be used for submitting application details to host system.

Value should be ‘true’ for OFSLL setup.

Disclosure configurations

Please follow doc (Origination_disclosure_configuration.doc) for configuring disclosures in OBDX OFSLL application

Promo code maintenance

Promo codes (which exist in OFSLL application) can be maintained in OBDX database at table ‘digx_or_promo_codes’.

Dealer maintenance

Dealer details can be maintained in OBDX database at table ‘digx_or_dealer_details’

Social Media Integration

Please refer ‘User Manual Oracle Banking Digital Experience Origination Social Media Integration.docx’ document to have social media integration.

Product configuration

To enable the products execute the following script. Update DIGX_OR_PRODUCT_TYPE set STATUS = 'ACTIVE' where ID IN ('PAYDAYLOANH2','AUTOLOANH2'); This will enable the payday loans, and auto loans products.

Admin Maintenance

Accommodation Type maintenance:

Execute the following scripts to add accommodation type maintenance.

Where OBDX_BUClosedBusiness Unit is the entity id for which the OFSLL host is configured.

INSERT INTO DIGX_OR_ACC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) VALUES ('OTHER', 'Other', 100, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, '', 1);

INSERT INTO DIGX_OR_ACC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) VALUES ('PARENTS', 'Living with parents', 30, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, '', 1);

INSERT INTO DIGX_OR_ACC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) VALUES ('OWN', 'I own this home', 10, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, '', 1);

INSERT INTO DIGX_OR_ACC_TYPE (CODE, DESCRIPTION, ORDINAL, DETERMINANT_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_STATUS, OBJECT_VERSION_NUMBER) VALUES ('RENT', 'I pay rent', 20, 'OBDX_BU', 'superadmin', sysdate, 'superadmin', sysdate, '', 1);

Home