BI Publisher (MOSC)

MOSC Banner

R12 : Duplicates in data defintion XML eventually leading to erroneous values in SUM columns ?

edited Nov 14, 2012 6:58PM in BI Publisher (MOSC) 6 commentsAnswered
Hi there,

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" />

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center