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.

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 LOCAL.
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	Submission A 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	IS_REGISTRATION_MANDATORY	This flag used to force mandatory channel registration while submitting application.
OriginationConfig	MAX_ALLOWED_VEHICLE_AGE	Maximum age allowed for vehicle in number of years
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_ubs124	FUNDING_OPTIONS_PRESENT_ON_HOST	If funding options are present on host. Value should be ‘false’ for UBS origination setup
OriginationConfig_ubs124	APPLICANT_ID_MODIFICATION_REQUIRED	If applicant Id is to be replaced by customer Id generated from host system in OUD/DB. Value should be ‘true’ for UBS origination setup
OriginationConfig_ubs124	LENDER_DEALER_ID	Lender Dealer Id present in OFSLL application.
OriginationConfig_ubs124	HOST_NAME	Indicates the name of the host, value for this value should be ‘UBS’ for UBS origination setup.
OriginationConfig_ubs124	ORIGINATION_APPLICANTS_DATA_SOURCE_CHECK_REQUIRED	If applicant data is to be always fetched from host system for existing customer in host system. Value should be ‘true’ for UBS origination setup
OriginationConfig_ubs124	FUNDING_OPTIONS_FOR_EXISTING	Funding options For Existing Party A party is any individual or business entity having a banking relationship with the bank.. Value should be ‘DDAO’ for UBS origination setup. It indicates only owned casa accounts are supported for funding.
OriginationConfig_ubs124	DATA_REQUIRED_FOR_SUBMISSION	Indicates if submission data should be used for submitting application details to host system. Value should be ‘true’ for UBS origination setup.

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 ('SAVINGSH3','CHECKINGH3','AUTOLOANH3','PERSONALLOANH3');

This will enable the savings, current accounts, auto loans, and personal loans products

Back