Unifier (MOSC)

MOSC Banner

What is best way to determine if a task was performed by a proxy user. Or PLEASE ADD Task_ID to the

edited Aug 4, 2017 5:04AM in Unifier (MOSC) 1 commentAnswered

The audit log doesn't have the TASK_ID as a column so the only way that I have come up with to determine if a task was completed by a proxy user is this:

SQL Server query for a specific bp

select  al.userid, al.proxyuserid,  wft.end_date, al.eventtime, abs(convert(float,al.eventtime ) - convert(float,wft.end_date)) as timeDiff

FROM sys_wf_process_view wfp

INNER JOIN sys_wf_task_view wft ON wfp.id = wft.process_id

INNER JOIN unifier_auditlog al on  al.SOURCEID = wfp.source_id and al.sourcetype=wfp.bp_type and wft.action_name = al.description and wft.assignee_id = al.userid and abs(convert(float,al.eventtime ) - convert(float,wft.end_date)) <0.0009

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center