Unifier (MOSC)

MOSC Banner

Table name schedule/task data

edited May 5, 2014 5:26PM in Unifier (MOSC) 4 commentsAnswered

We use scope manager to launch business processes.  I am trying to add to a data view what the current task is (per the schedule) and who it is assigned to.

I have found this data (using auburn_sys_task,& auburn_sys_user_info ). Where i am having trouble is linking the active task back the schedule.

For example, my query is returning ALL active tasks for the project, not just those that were generated from the schedule. 
For the purposes of this report -- i only want to display the active task that is linked to the schedule.


Can anyone help me with this?  I have been trying to find a link between auburn_sch_task (which contains the schedule data) with auburn_sys_task -- but can't seem to find a common key.

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