How to handle insurance payment in OpenERP ?

@suruchi @laxmanm7 @laxman @utsavdeshar Guys i changed the git to develop as recommended by you guys but now it throwing error as shown above, Please spare some time so we can fix this quickly, I would like to ask few other questions as well, so need your kind support on this. Appreciate the time you guys are spending on this ticket.

@hassan, can you please follow the below mention document once: https://nepalehr.atlassian.net/wiki/spaces/NEPALEHR/pages/4358202/Installation+guide. Just need to run the script file.

To run the above mentioned scripts, please remove the insurance features first you have already installed.

Done thank you so much, now all things are installed, Next question i have is i created a patient and assigned him NHIS number, but that number isnt showing in odoo.

Second question: i saw below in the insurance-integration properties file, i do not have idea how to set it up as nothing is given on that in documentation. /////// app.openimis.api.url=dhisinstanceurl

openimis.api.url=dhisinstanceurl openimis.api.user=user openimis.api.password=password /////

Got the NHIS number to show after following this:

But regrading the Second question: i saw below in the insurance-integration properties file, i do not have idea how to set it up as nothing is given on that in documentation. /////// app.openimis.api.url=dhisinstanceurl

Still unclear what to do.

@laxman @laxmanm7 i am following your blog for imis integration and unclear on

openimis.api.url=https://openimis.nepalehr.org/api/api_fhir/ openimis.api.user=bahmni openimis.api.password=bahmnipw openimis.enterer.id=VIDS0011 openimis.healthFacility.id=VIDS001

openimis.fhir.api.elig=https://openimis.nepalehr.org/api/api_fhir/Elig/ openimis.fhir.api.claim=https://openimis.nepalehr.org/api/api_fhir/Claim/

This part in configuration file for insurance-integration, do i need to install imis also as a seperate portal?

Hi @hassan Apologies for late response , I was offline for sometime.

Regarding your question above, This work we have done is for integrating bahmni with the OpenIMIS system only, It does not work with other insurance systems and payments.

The configuration above mentioned are credentials for connection with openimis

Please let me know if you have further queries.

1 Like

@laxman my understanding is that OpenIMIS app would have to be installed separately on the system right?

yes openimis needs to be installed if you are testing integration. You can install openimis separately on your system or use some demo machines provided by openimis community.

tagging @utsavdeshar here.

@hassan which steps did you use to make NHIS number show on odoo? been trying to add it to no avail. Kindly assist

@hassan @laxman @laxmanm7 @jaghatise Hi, I have followed the steps of integration of openIMIS via the script of NepalEHR mentioned in comment 22 of this thread. Also I have configured the application.properties file of insurance-integration according to comment 24 of this thread.

Now I am having two issues:

1.) I am unable to find any “Insurance settings” under the newly added “Insurance” tab in Odoo for to perform settings given on NepalEHR odoo configuration guidelines.

2.) On clicking on New Claim in Insurance tab I am getting the following error:

Traceback (most recent call last):

  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/http.py”, line 642, in _handle_exception*
  • return super(JsonRequest, self)._handle_exception(exception)*
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/http.py”, line 684, in dispatch*
  • result = self._call_function(*self.params)
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/http.py”, line 334, in _call_function*
  • return checked_call(self.db, *args, *kwargs)
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/service/model.py”, line 101, in wrapper*
  • return f(dbname, *args, *kwargs)
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/http.py”, line 327, in checked_call*
  • result = self.endpoint(*a, *kw)
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/http.py”, line 942, in call*
  • return self.method(*args, *kw)
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/http.py”, line 507, in response_wrap*
  • response = f(*args, *kw)
  • File “/opt/bahmni-erp/odoo/addons/web/controllers/main.py”, line 895, in call_kw*
  • return self._call_kw(model, method, args, kwargs)*
  • File “/opt/bahmni-erp/odoo/addons/web/controllers/main.py”, line 887, in _call_kw*
  • return call_kw(request.env[model], method, args, kwargs)*
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/api.py”, line 689, in call_kw*
  • return call_kw_multi(method, model, args, kwargs)*
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/api.py”, line 680, in call_kw_multi*
  • result = method(recs, *args, *kwargs)
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/models.py”, line 5537, in onchange*
  • record._onchange_eval(name, field_onchange[name], result)*
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/models.py”, line 5436, in _onchange_eval*
  • process(method_res)*
  • File “/usr/lib/python2.7/site-packages/odoo-10.0.post20190619-py2.7.egg/odoo/models.py”, line 5413, in process*
  • if res.get(‘value’):* AttributeError: ‘str’ object has no attribute ‘get’

Please help me in resolving this.

#1 may be due to user privilege, user should have managerial privilege i think #2 we will check on our side and let you know. cc: @utsavdeshar , @sudishrestha

@laxman @hassan
Hi, I am now able to view the insurance settings after changing my login privileges for Insurance to “Manager”.
Now I am trying to setup the insurance-integration’s URI,username and password in insurance settings with the values:
uri: https://localhost:8092/insurance-integration
username: admin
password: haha
Also it additionally requires me to provide the ’journal name’ for which I have created the ‘Insurance journal’ according to steps provided on NepalEHR.

So after setting up these values when I click on ‘Test Settings’ button it returns ’Connection failed’. Please help me where I am going wrong.

Also I am unable to login into Swagger documentation link https://localhost/insurance-integration/swagger-ui.html#/request-processor with credentials "admin/haha" which is the 7th step to checkup my successful insurance-integration installation. The login box keeps on popping repeatedly.I have also tried many other combinations but none of them seem working.

I am attaching my - bahmnicore.properties file and insurance-integration.properties file contents.Please help me if I am doing anything wrong in the configuration.

1 Like

Please check if you have installed the java insurance-installation service properly and the service can be accessed from 8092 port ‘https://localhost:8092/insurance-integration

You have used the openIMIS instance of nepalehr which is currently down, so you might have faced the problem of test connection failed. Please try other deployed openIMIS instance. You can followup to openimis community or try installing yourself. You can change the config from insurance-integration.proporties for the instance.

I guess my insurance-installation is starting up fine because the insurance-integration.log says Bahmni insurance service started successfully
However when I try to access your mentioned URL ‘https://localhost:8092/insurance-integration’ or the Swagger URL : https://localhost/insurance-integration/swagger-ui.html#/request-processor I am getting popup to enter username and password so I am trying to enter it by default credentials “admin/haha” but it keeps on popping up repeatedly.

Also after this in insurance-integration.log file I have discovered an error which states that the context URL path can not be normalized.
You can also view the complete log file here: insurance-integration.log

I have solved this issue now. To solve this, I had to rebuild the rpm after changing the spring boot version 2.1.5.RELEASE to 2.1.6.RELEASE in pom.xml file of insuance_connect project
And then I reinstalled the rpm.
Now I am able to log in to /insurance-integration and able to view the SWAGGER UI as well
I think this problem was related to spring security exception which is fixed in the later versions.

Also I would like to request the team to do the same changes on their repo as so as the future developers are able to get this benefit.

3 Likes

Maybe you can consider logging a bug or leaving a comment in the specific Github repo, or on their confluence page: https://nepalehr.atlassian.net/wiki/spaces/NEPALEHR/pages/4423810/Odoo+Configurations

really great Thanks for sharing this.

Hi @laxman ,

I followed the steps for claim submission by nepalEHR, I am able to create Claim which is according to the visit flow and then creation of quotation and confirming invoice and creating claim. However on final step of clicking “Submit Claim” on Odoo, I am getting error saying - [42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Conversion failed when converting from a character string to uniqueidentifier. (8169) (SQLExecDirectW)

The log in insurance-integration.log can be viewed here: LINK

Also in my logs in Postegres > Insurance > logs table shows following entries for the claim

user_id dated logger level message
2021-03-05 10:36:49 org.bahmni.insurance.web.RequestProcessor ERROR submitClaim : {¶ “patientUUID” : “0d163f84-5d12-4e27-92d4-cc417d6d7c73”,¶ “visitUUID” : “b6bbeac8-3273-41e9-9340-265d2de618ba”,¶ “claimId” : “600002”,¶ “insureeId” : “10500001”,¶ “item” : [ {¶ “category” : “item”,¶ “quantity” : 1.0,¶ “sequence” : 1,¶ “unitPrice” : 100.0,¶ “totalClaimed” : null,¶ “status” : null,¶ “rejectedReason” : null,¶ “totalApproved” : null,¶ “code” : “I26”¶ }, {¶ “category” : “service”,¶ “quantity” : 1.0,¶ “sequence” : 2,¶ “unitPrice” : 1.0,¶ “totalClaimed” : null,¶ “status” : null,¶ “rejectedReason” : null,¶ “totalApproved” : null,¶ “code” : “A1”¶ } ],¶ “total” : 101.0¶}
2021-03-05 10:36:53 org.bahmni.insurance.web.RequestProcessor ERROR claimRequest : {“resourceType”:“Claim”,“id”:“600002”,“identifier”:[{“use”:“usual”,“type”:{“coding”:[{“system”:“https://hl7.org/fhir/valueset-identifier-type.html",“code”:“MR”}]},“value”:“600002”}],“type”:{“text”:“O”},“patient”:{“reference”:“Patient/64E3194F-E50A-4D98-A401-CF8F20EF0527”},“billablePeriod”:{“start”:“2021-02-26T13:59:02+05:30”,“end”:“2021-02-26T14:31:28+05:30”},“created”:“2021-03-05T10:36:51+05:30”,“enterer”:{“reference”:“Practitioner/VIDS0011”},“facility”:{“reference”:“Location/VIDS001”},“diagnosis”:[{“sequence”:1,“diagnosisCodeableConcept”:{“coding”:[{“code”:“A00”}]},“type”:[{“text”:“icd_0”}]}],“item”:[{“sequence”:1,“category”:{“text”:“item”},“service”:{“text”:“I26”},“quantity”:{“value”:1.0},“unitPrice”:{“value”:100.0}},{“sequence”:2,“category”:{“text”:“service”},“service”:{“text”:“A1”},“quantity”:{“value”:1.0},“unitPrice”:{“value”:1.0}}],“total”:{"value”:101.0}}
2021-03-05 10:36:53 org.bahmni.insurance.web.CustomWebErrorController ERROR Internal Server Error 500 Internal Server Error [42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Conversion failed when converting from a character string to uniqueidentifier. (8169) (SQLExecDirectW)

Please help me urgently.

I think this is something related to database of openimis, please verify in your openimis if its having correct version of database supporting fhir integration, pls reach out openimis community for further knowledge abt different versions of db.