Fusion Applications BI Publisher: Need A Query For BPM Delegations

(Doc ID 2202819.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

A report is required to show BPM Workflow information where a task has been directly assigned to a user by another user or BPM Workflow information where a task has been assigned due to a vacation rule taking effect. The tables that have been attempted to be queried have given the "insufficient privileges" error message. Is there a query that can be run to retrieve this information either from a cloud environment through a BI Publisher data model or through cloud ops running a query for the customer?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms