Does anyone know a way to report on Sign Off Duration for Activities?
There is a User Signoff Duration Report, but that only works for changes. If there is no OOTB solution, does anyone have a SQL for this?
I’d imagine it’s the sign SIGNOFF table and the same SQL as you would pull with other changes, though I don’t have PPM to confirm this. Try it by: <select * from SIGNOFF s, ACTIVITY a where a.id = s.change_id> and go from there.
Thanks for the reply Matt! Yes I got that far, and a little further, but struggled with having my SQL match the signoff duration, on the workflow tab of task, because the app is calculating business days dynamically. I’m unclear on how to get the business days difference into my query. I was hoping someone already invented this wheel.
I’ve used these two lines to calculate date difference:
ROUND((LAST_UPD – CREATED),2) as DateDiff
ROUND((select sysdate – interval ‘8’ hour – s.created from DUAL), 0) as elapsed
I’ve ran into the same thing and I know what you’re talking about, so I used the second line to get the most accurate (I have to subtract 7 or 8 hours for Pacific Standard Time).
Make sure you check your server preferences to see if it’s counting weekends or not.