THIRD PARTY CONFIGURATION

Configurations

OBDX is the banking solution platform which needs to be integrated with one of core banking systems retrieve the customer banking details and to execute the set of operations on the core banking system as per the service requirement.

Below are the tables which need to be updated for day one configurations while implementing OBDX with third party.

DIGX_FW_CONFIG_ALL_B

This table maintains all the required day one configurations at DIGX. Based on category id and property id, property value will be returned and used in the system. Configurations like day one, adapter factories configurations, third party properties and configurations, External systems bank and branch configuration etc. are maintained in this table

Column prop_value needs to be updated based on Category_ID and Prop_ID

Sr.No

Category_ID

Property_ID

Prop_Value

1

ExtSystemsConfig

SESSION_BANK_CODE

Update the Bank Code of the Bank. (Run the Update Query)

2

ExtSystemsConfig

SESSION_TRANSACTION_BRANCH HEADER_APPLICATION_BRANCH HEADER_DATA_ENTRY_BRANCH

Update the Bank Code of the Bank. (Run the Update Query)

3

fileuploadconfig

WORKAREA_PATH

RESPONSE_FILE_PATH

Create a Folder where Weblogic is Installed. Update the File Upload Path for the folder Created. (Run the Update Query)

4

Dayoneconfig

EXTERNAL_PAYMENT_REDIRECTION_URL

Update the Redirection URL from Merchant Site. replace(PROP_VALUE, '<hostname>:<port>', Current Bank URL’s IP:Current Bank URL’s Port') (Run the Update Query)

5

 

Dayoneconfig

CLAIM_PAYMENT

Update the Current Bank URL with Module=home: for e.g. http://mum00boi:8888/index/public/model-bank.html?module=home (Run the Update Query)

6

 

ExtXfaceSimConfig

 

 

Interface Id for transaction.

E.g. SELF_TRANSFER

SUCCESS/FAILURE

Configuration for simulation xmls to pick up.

SUCCESS: success sim will be picked up and transaction will be successful.

FAILURE: failure sim will be picked up and transaction will fail.

7

ExtXfaceConfig

EXT_SYSTEM_Q_JNDI_NAME

ExtSystemSenderQueue External system queue JNDI name on which request is to be sent.

8

ExtXfaceConfig

EXT_SYSTEM_QCF_JNDI_NAME

ExtSystemSenderQCF

External system queue connection factory JNDI name on which request is to be sent.

9

ExtXfaceConfig

RECEIVER_Q_JNDI_NAME

ExtSystemReceiverQueue

Receiver queue JNDI name

10

ExtXfaceConfig

RECEIVER_QCF_JNDI_NAME

ExtSystemReceiverQCF

Receiver queue connection factory JNDI name

11

ExtXfaceConfig

ENDPOINT

com.ofss.digx.app.extxface.impl.endpoint.JMSEndpoint

This is configuration for endpoint to be called based on what third party has exposed for response.

12

ExtXfaceConfig

XSD_VALIDATION

TRUE/FALSE

TRUE: Indicates request and response will be validated against XSD.

FALSE: Indicates request and response will not be validated against XSD.

13

ExtXfaceConfig

TIMEOUT_MILLISEC

60000

Configures time in milliseconds for which receiver will wait for response to be posted on receiver queue by external system.

For thirdparty simulation:

update DIGX_FW_CONFIG_ALL_B set prop_value= '000' where category_id ='ExtSystemsConfig' and prop_id = 'SESSION_BANK_CODE';

update DIGX_FW_CONFIG_ALL_B set prop_value= 'AT3' where category_id ='ExtSystemsConfig' and prop_id = 'SESSION_TRANSACTION_BRANCH';

update DIGX_FW_CONFIG_ALL_B set prop_value= 'AT3' where category_id ='ExtSystemsConfig' and prop_id='HEADER_APPLICATION_BRANCH';

update DIGX_FW_CONFIG_ALL_B set prop_value= 'AT3' where category_id = 'ExtSystemsConfig' and prop_id = 'HEADER_DATA_ENTRY_BRANCH';

update DIGX_FW_CONFIG_ALL_B set prop_value= '/home/devops/obdx/fileupload' where category_id = 'fileuploadconfig' and prop_id ='WORKAREA_PATH';

update DIGX_FW_CONFIG_ALL_B set prop_value= '/home/devops/obdx/fileupload' where category_id = 'fileuploadconfig' and prop_id ='RESPONSE_FILE_PATH';

update digx_fw_config_all_b SET PROP_VALUE = replace(PROP_VALUE, '<hostname>:<port>', 'mum00boi:8888') where prop_id='EXTERNAL_PAYMENT_REDIRECTION_URL';

update digx_fw_config_all_b SET prop_value = 'http://mum00boi:8888/index/public/model-bank.html?module=home' WHERE prop_id = 'CLAIM_PAYMENT' AND category_id = 'dayoneconfig';

DIGX_CS_BRANCH_DATES_B

This table maintains branch information and like bank code, branch code, current date, previous and next working date. Values in this table need to be updated whenever there is change in bank or branch in the host system.

Sr.No

Bank_Code

Columns to be Updated

1

08

BANK_CODE – Update the Bank Code of the Bank.

BRANCH_CODE – Update the Branch Code of the Bank.

CURR_DATE - – Update the Current Date of the Bank.

PREV_WORKING_DATE – Update the Previous Working Date of the Bank.

NEXT_WORKING_DATE – Update the Next Working Date of the Bank.

(Run the Update Query)

For thirdparty simulation:

update DIGX_CS_BRANCH_DATES_B set branch_code='AT3', bank_code='000' WHERE bank_code = '08';

DIGX_FW_CONFIG_OUT_WS_CFG_B

This table maintains configuration of web services and their stubs which are used by DIGX. Service and process determines web service to be called, stub service, log handler etc.

Sr.No

Service_ID

URL

1

runReport

Update the SOAP service url of oracle BI.(Run the Update Query)

Find below is the script created for your reference:

update DIGX_FW_CONFIG_OUT_WS_CFG_B set URL= 'http://10.184.133.240:9502/xmlpserver/services/v2/ReportService?WSDL' where service_id = 'runReport';

DIGX_CS_BANKS_ALL_B

This table holds bank details like bank code, bank name, address etc. Values in this table need to be updated whenever there is change in bank details in the host system.

Sr.No

Bank_Code

Columns to be Updated

1

08

BANK_CODE – Update the Bank Code of the Bank.

(Run the Update Query)

For thirdparty simulation:

update DIGX_CS_BANKS_ALL_B set bank_code='000' WHERE bank_code='08';

DIGX_FW_BANK_CONFIG

This table holds bank details like bank code, home branch, currency and region. Values in this table need to be updated whenever there is change in bank details in the host system

Sr.No

Columns

Columns to be Updated

1

BANKCODE

HOME_BRANCH

CAL_CURRENCY

LOCAL_CURRENCY

CREATED_BY

CREATION_DATE

ENTITY_STATUS

LAST_UPDATED_BY

LAST_UPDATE_DATE

OBJECT_VERSION_NUMBER

REGION

Insert the Bank Code of the Bank.

Insert the Branch Code of the Bank.

Insert the Calendar CurrencyClosedA generally accepted form of money, including coins and paper notes, which is issued by a government and circulated with in an economy. of the Bank.

Insert the Local Currency of the Bank.

Ofssuser

Sysdate

A

Ofssuser

Sysdate

1

Region of the Bank

(Run the Insert Query)

For thirdparty simulation:

insert into DIGX_FW_BANK_CONFIG (BANKCODE,HOME_BRANCH,CAL_CURRENCY,LOCAL_CURRENCY,CREATED_BY, CREATION_DATE, ENTITY_STATUS, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER,REGION)values ('000','AT3','GBP','GBP','ofssuser',sysdate, 'A','ofssuser', sysdate, 1,’INDIA’);

DIGX_FW_BANK_CONFIG_MODULE

This table holds banking types supported by bank.CON indicates conventional banking and ISL is for Islamic banking.

Sr.No

Columns

Columns to be Updated

1

BANKCODE

MODULE

Insert the Bank Code of the Bank.

CON, ISL

(Run the Insert Query)

For thirdparty simulation:

Insert into DIGX_FW_BANK_CONFIG_MODULE (BANKCODE,MODULE) values ('000','CON');

Insert into DIGX_FW_BANK_CONFIG_MODULE (BANKCODE,MODULE) values ('000','ISL');

FLX_CS_BANK_CODES_ALL_B

This table holds bank code and description which is maintained in the system

Sr.No

Columns

Values

1

BANK_CODE

BANK_CODE_NUM

BANK_DESC

OBJECT_STATUS_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

LAST_UPDATED_BY

CREATION_DATE

LAST_UPDATE_DATE

DOMAIN_OBJECT_EXTN

Insert the Bank Code of the Bank.

Insert the Bank Code Number of the Bank.

Insert the Bank Description of the Bank.

A

1

TELLER1

TELLER2

Sysdate

Sysdate

CZ

(Run the Insert Query)

For thirdparty simulation:

Insert into FLX_CS_BANK_CODES_ALL_B (BANK_CODE,BANK_CODE_NUM,BANK_DESC,OBJECT_STATUS_FLAG,OBJECT_VERSION_NUMBER,CREATED_BY,LAST_UPDATED_BY,CREATION_DATE,LAST_UPDATE_DATE,DOMAIN_OBJECT_EXTN) values ('000',000,'OBPClosedOracle Banking Platform Demo Bank','A',1,'TELLER1','TELLER2',sysdate,sysdate,'CZ');

DIGX_CS_CURRENCY_TASK_LINKAGE

This table maintains mapping of payment task code with currencies. This is used to populate currency drop-down in payments screens.

Sr.No

Columns

Values

1

CURRENCY_CODE

TASK_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATED_DATE

STATUS_FLAG

VERSION

DETERMINANT_VALUE

GBP, INR, GBP, INR, GBP, INR, USD, USD, USD

INTERNATIONALFT_PAYLATER, INTERNATIONALFT_PAYLATER, INTERNATIONALDRAFT, INTERNATIONALDRAFT, INTERNATIONALFT, INTERNATIONALFT, INTERNATIONALFT, INTERNATIONALDRAFT, INTERNATIONALFT_PAYLATER

OFSSUser

to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss')

OFSSUser

to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss')

‘’

1

OBP_BUClosedBusiness Unit

(Run the Insert Query)

For thirdparty simulation:

Find below is the script created for your reference:

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('GBP', 'INTERNATIONALFT_PAYLATER', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('INR', 'INTERNATIONALFT_PAYLATER', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('GBP', 'INTERNATIONALDRAFT', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('INR', 'INTERNATIONALDRAFT', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('GBP', 'INTERNATIONALFT', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('INR', 'INTERNATIONALFT', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('USD', 'INTERNATIONALFT', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('USD', 'INTERNATIONALDRAFT', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

insert into DIGX_CS_CURRENCY_TASK_LINKAGE (CURRENCY_CODE, TASK_CODE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, STATUS_FLAG, VERSION, DETERMINANT_VALUE)values ('USD', 'INTERNATIONALFT_PAYLATER', 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), 'OFSSUser', to_date('24-11-2016 09:17:29', 'dd-mm-yyyy hh24:mi:ss'), '', 1, 'OBP_BU');

Preference

Do changes in /config/Preferences.xml: Preference AdapterFactories should be overridden by preference AdapterFactoriesExtSystem.

<Preference name="AdapterFactories" overriddenBy="AdapterFactoriesExtSystem" PreferencesProvider="com.ofss.fc.infra.config.impl.DBBasedPropertyProvider" parent="jdbcpreference" propertyFileName="select prop_id, prop_value from digx_fw_config_all_b where category_id = 'adapterfactoryconfig'" syncTimeInterval="60000" /

Home