Need Help Trouble Shooting One Issue

Closed

Hello,

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

Skills: Oracle, SQL

See more: oracle functions sql, need sql help, shooting, trouble shooting, help advertise books using ebay, sql query help, bank account program using arrays structures search functions, sql query sum, need login using facebook vote, need help sales, need website using simple program, oracle sql query, root cause, production group, need articles using best spinner, sql query oracle, need webmaster using volusion, oracle help, production reason, trouble ticket system projects using aspnet, query sum values, help desk tool using oracle, need sentences using word synonyms, query oracle, oracle sql help

Project ID: #5324811

27 freelancers are bidding on average $20 for this job

elboukharimu

Aucune proposition n'a encore été fournie.

$24 USD in 0 days
(16 Reviews)
4.7
LearningNew

I can do it..................................................................................................................................

$53 USD in 1 day
(4 Reviews)
4.6
nibiranijum

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://ww More

$20 USD in 1 day
(16 Reviews)
4.5
BhargavaB

Hi this is bhargava expert in oracle and Pl/sql . i am ready to provide quick and efficient solution . i am ready to start your project .

$20 USD in 1 day
(7 Reviews)
3.5
codetod

Sorry I missed to see the linking pd.code_combination_id = gl.code_combination_id, so my below assumption is not correct. Will have to look at the data to identify the actual issue. Thanks Dear Naveenmikkilinen More

$20 USD in 3 days
(6 Reviews)
2.7
TechJSolutions

Dear naveenmikkilinen, Let me help you to solve the problem. But I need to query in production. Waiting for your response. Thanks

$15 USD in 1 day
(1 Review)
0.5
larisacorina

Hello, I have over 6 years experience in developing SQL based reports for ERP and other industry specific software. I'm confident I can deliver the expected report and looking forward to working with you. Best rega More

$20 USD in 1 day
(0 Reviews)
0.0
Oramit

Dear Naveen, I have been working in PL SQL for more than 10 years now and very confident that can certainly help you with this issue. Request you to please give me opportunity to work. Thanks and Regards, Ami More

$25 USD in 3 days
(0 Reviews)
0.0
psrnath

I am currently working in Oracle apps. So I may be able resolve this quickly. This must be some ting very easy to fix

$20 USD in 1 day
(0 Reviews)
0.0
fedora18

Hi there, I can fix that in half hour. Let me do it please. That's it. Thanks and Regards, AbbasiTech (IT SOLUTIONZ ISB)

$20 USD in 1 day
(0 Reviews)
0.0
StefanDamyanov

My last 2 years of work is in Oralce Performance and Tunning and Data Quality. These type of problems is in the duplicate rows in one or more joined tables. In this particular case we need to check all tables to see wh More

$20 USD in 1 day
(0 Reviews)
0.0
arthurspa

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)
0.0
panshiva

A proposal has not yet been provided

$23 USD in 1 day
(0 Reviews)
0.0
nhattruong203

Dear naveenmikkilinen, I have many years experience in ORACLE, PL SQL, and Oracle EBusiness Suite R12. I will quickly help you to fix this trouble.

$18 USD in 1 day
(0 Reviews)
0.0
vw7485668vw

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?

$25 USD in 1 day
(0 Reviews)
0.0
Ameya08

I have a Good Knowledge of oracle 10G /11G and ready to do work in deadline. So i see your problem i can fix it please give me all the detail with skype id

$17 USD in 1 day
(0 Reviews)
0.0
hollidge

Hello, My work is to debug an application that has all General Motors medical records, this application is used globally (I work with US users only) this application has more than 1100 tables, more than 2500 views, More

$15 USD in 1 day
(0 Reviews)
0.0
indika666

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..!

$20 USD in 1 day
(0 Reviews)
0.0
ravimamilla

Hi, I am working on OBIA from the past 4 yearsin DEV as well as Production Support. I am good at SQL Debugging

$20 USD in 2 days
(0 Reviews)
0.0
naveen1985in

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0