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 Currency 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,'OBPOracle 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_BU (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" /