R12 : Duplicates in data defintion XML eventually leading to erroneous values in SUM columns ?
I am working on data defintion XML for a report and it seems there is an issue with way the groups have been created.There are duplicates appearing in the output XML, eventually the SUM columns are displaying erroneous values.
For the example given below :
Ideally the values should have been :
BBDR BBCR PERNETDR PERNETCR
16448.73 130.6 32897.46 261.2 (IDEAL VALUES)
49346.19 391.8 49346.19 391.8 (ACTUAL ERRONEOUS values)
Data defintion XML used is like :
<group name="G_HEADER_INFO" source="Q_RUN_SHORT_REPORT">
<element name="L_RUN_SHORT_REPORT" value="L_RUN_SHORT_REPORT" />
<group name="HEADER_BALANCE_INFO" source="Q_SHORT_REPORT">
<element name="LEDGER_NAME" value="LEDGER_NAME" />