Fix duplication of records in Reporting database

Description

While working in Malawi I've noticed that f.e. in materialized view stock_status_and_consumption there is a lot of duplication of line items. It's affect on performance and correct of data. In this ticket we should check if the same issue exist in Core and take care of it.

ACC:

  • There is no duplication of records in any of reporting tables or views.

Environment

None

Assignee

Unassigned

Reporter

Jakub Jakubowski

Labels

Story Points

3

Priority

Major
Configure