[
https://issues.apache.org/jira/browse/FINERACT-2742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Saghy resolved FINERACT-2742.
----------------------------------
Resolution: Fixed
> Journal Entry Aggregation - update reader query to default to null instead of
> ''
> --------------------------------------------------------------------------------
>
> Key: FINERACT-2742
> URL: https://issues.apache.org/jira/browse/FINERACT-2742
> Project: Apache Fineract
> Issue Type: Improvement
> Affects Versions: 1.15.0
> Reporter: Adam Saghy
> Assignee: Adam Saghy
> Priority: Major
> Fix For: 1.16.0
>
>
> Currently, Journal entry aggregation reader job uses COALESCE((SELECT \s""" +
> aggregateFunction + """ to build the aggregation query. Before these changes,
> journal entry aggregation has been inserting data into the summary table with
> originator_external_ids as null wherever it’s not available. This caused an
> issue during report reconcilation whereby the reports used aggregated data
> and duplicated the rows based on “null” originator ids (for old/existing
> data) and ‘' originator ids for new aggregation runs.
> So we need to update the reader query to not default to '’.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
