OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Incorrect Behavior of SUM in Discoverer...?

Home » Applications » Oracle Fusion Apps & E-Business Suite » Incorrect Behavior of SUM in Discoverer...?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Incorrect Behavior of SUM in Discoverer...? [message #270221]

Wed, 26 September 2007 03:30

joselfmp
Messages: 23
Registered: August 2007
Location: Madrid

Junior Member

Hello,
[Disc versions: Vierwer&Desktop 4i (4.1.0.48.06.00) vs 10g (10.1.2.48.18) - DB: 9.2.0.8]

I've just done an installation of Discoverer 10g and after migrating EUL's I'm comparing results between 4i and 10g. All my 15 reports (non-standard) that have similar total calculations presents in 10g different values (wrong ) than in 4i

An example:

- ColA --- ColB -- Col%
- ---------------------------------------
- 10 - 5 - 2
- 40 - 8 - 5
- ---------------------------------------
Total4i 50 - 13 - 3,8
Total10g 50 - 13 - 7

The Correct is the behavior in 4i....

This problem is exactly related on point 1.4 of the pdf file mentioned in Note:276176.1 from Metalink (Oracle Discoverer Aggregation /
Totals / Calculations Explanation and Examples)
It seems to correspond with the behavior of Sum and Sum Cell, and.. seeing the results of 10g, it seems to be the Sum Cell Format.. but in both, the Total Calculation is set to Sum

I've checked lot's of metalink notes about differents results in Totals&aggregations:

208366.1
333521.1
358707.1
177935.1
276176.1
389850.1
312607.1
290870.1
210553.1
247738.1

and in some of those... appeared references to variables of pref.txt that may alter the total behavior
(AggregationBehavior,AllowAggregationOverRepeatedValues and
EnhancedAggregationStrategy). I have all set to 1 in my regedit and in my
pref.txt. I also have under my database node the variable
DisableFanTrapResolution = 0. (I don't know if it would correspond to a Fan
trpa behaviour)... But.. apart from this.. I can't imagine.. what more things
to look...
Any ideas? Is it an incorrect behavior of SUM calculation in 10g?
I tried to add a new total line in 10g report with SUM CELL instead SUM and the same values appear... I mean with this new line I'd have this two lines for totals:

Total10g (SUM) -> 50 13 7 <- This is what it'd be wrong..
Total10g (SUM CELL) -> 50 13 7

Thanks a lot.

Jose L.

Report message to a moderator

Re: Incorrect Behavior of SUM in Discoverer...? [message #271680 is a reply to message #270221]

Tue, 02 October 2007 08:36

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Jose,

I would suggest to either raise an SR on metalink for this or post your question on the OTN Discoverer forum (perhaps Michael Armstrong or others there do know a solution).

Regards,
Sabine

Report message to a moderator

Previous Topic:	Printed Purchase Order Report gives no output
Next Topic:	A/P Distribution Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 03:21:30 CDT 2024