I need some help finding root cause of an issue that I am working. For some reason one query in Production is doubling measure values when i use SUM and GROUP by functions. That is if i have 10 $ as sales when i use sum and group by it is appearing as 20$. I am using approx about 8 tables with some joins. Same query is working perfect in DEV environment.
Length of the query is probably around 55 to 60 lines
27 freelancers are bidding on average $20 for this job
Hi, I would like to solve your query as may be I know where the problem is! Can u tell me exactly where are you executing this query to get double of output?
This is my first bid on this site..! I'm an experienced oracle EBS tecno-functional consulatnt with years of implementation experience..! pls check my profile..!