Thanks Mihaela, I will give it a go :)

For example in this query your persons with multiple assignments will float to the top... do you have any with multiple primary active employee assignments at the same point in time? select all count…

Hi, Yes a person may have many assignments at the same point it time and for each assignment id many instances (updates) of that assignment id over time including multiple update in the same day. Per…

No but you can add a union to select a constant from a subject area that you know will only return 1 row. (select all 0 as s_0, "presentation table"."presentation column" as s fro…

Hi, I think you refer to business process 04 Order Fulfillment 03 Bill Customers 05 Present Bill Oracle Fusion Business Process Models: 04 Order Fulfillment (Doc ID 1578139.1) For more information se…