Validation : OS-20472 - Eaches to Pallets Conversion Factor Logic (Live Factor)

analysis :

Logging hours here for the below issues which carlos asked to check

1)MOT simulation view was fixed but the data was not coming in tableau dashboard, had a call with deepak and we found the password was expired for OSCAR2TABLEAU userid , we dropped an message to vinay to change the password. I ran the job in prod and data got populated in the tableau dashboard.

2)The Mot simulation had duplicates records to fix dat i have applied group by in the view , but we need to change the main SP from UI side also in my code to pick the correct budget version.

3)Dev market PIR issue , where few skus were not getting populated in the DEV db but coming in the UI 80 skus , checked it all them and did  analysis and fixed it in dev and informed carlos.

4)Carlos asked to refresh the view , i have refreshed the view for historical data in dev.

5(dropped an email to kunal and leila for PIR FG AND SFG DATA.

6)Had discussion on LUCAS email with bharath for LEAD time calculation.