Project and Portfolio Management Practitioners Forum
cancel

WF transaction details question

SOLVED
Go to solution
Highlighted
Semenov Alexand
Acclaimed Contributor.

WF transaction details question

Hi ALL
I use 7.5+sp3
I need calculate a time between Eligible and Complete status for any step.In which view store this date.
In result I need:
Request: 60719
Step: initiation
Step status: Eligible date: 11.01.2009
Step status: Complete date: 16.02.2009
Total: x hours or x days.
Standard report: Workflow Statistics Report not allow select any parameters from request details.
How it possible
Many Thanks
5 REPLIES
Mahen M
Acclaimed Contributor.

Re: WF transaction details question

Hi Semenov,
I think both the Eligible and completed dates are available in a PPM Table(Hope it is a workflow transaction Table)

Please take both the dates and do the data manipulation.

The Below mentioned query tells how to find Days and Hours.

select to_char( created, 'dd-mon-yyyy hh24:mi:ss' ),
trunc( sysdate-created ) "Dy",
trunc( mod( (sysdate-created)*24, 24 ) ) "Hr",
trunc( mod( (sysdate-created)*24*60, 60 ) ) "Mi",
trunc( mod( (sysdate-created)*24*60*60, 60 ) ) "Sec",
to_char( sysdate, 'dd-mon-yyyy hh24:mi:ss' ),
sysdate-created "Tdy",
(sysdate-created)*24 "Thr",
(sysdate-created)*24*60 "Tmi",
(sysdate-created)*24*60*60 "Tsec"
from all_users Order by 10


Sorry if this is not your requirement.

Regards,
Mahendran M
Semenov Alexand
Acclaimed Contributor.

Re: WF transaction details question

Thanks, but I need calculate a time between Eligible and Complete status for any step
Mahen M
Acclaimed Contributor.
Solution

Re: WF transaction details question

See if this query helps.

Regards,
Mahendran M
Semenov Alexand
Acclaimed Contributor.

Re: WF transaction details question

Mahendran, Many Thanks.
After little modernization your query all working fine.
Semenov Alexand
Acclaimed Contributor.

Re: WF transaction details question

closed