This content has been marked as final. Show 4 replies
I have no real help for you as we're not on 11, but have you checked your aggregation settings? (I assume it's still under tools/options/aggregation.) I'd try all the possible options and see if any make a difference.
If not that, could it be one of the registry settings related to aggregation? I don't remember the specifics but maybe that would trigger some ideas. If something is different from the way it was set in your prior version...?
Thanks for your suggestions. Yes, I have tried all the possible ways for aggregations, plus setting up way to deal with null values, but so far nothing helps. I forgot to mention that the subtotal for single row works and for multiple rows, sometimes it works, sometimes it won't. The only difference I can tell is that when the query is from a detailed table, such as po_distributions_all, it works and if the query is from higher level table, such po_lines_all, it won't. Any ideas why?
Sorry, not much help here. I'm on a different platform (Desktop, version 10), but what you're describing about detail table vs. higher level table would make me suspect the AggregationBehavior registry setting. I know that doesn't apply to you but maybe someone else can help out based on that.
Thank you for your suggestion and I actually added that in the first place, but it didn't help. Anyway, I logged a SR with Oracle Support.