Ability To Report On Approval History with Access To Workflow Tables (Doc ID 1605531.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Symptoms


Developers have a requirement to create a custom report on Approval information for a specific task type ( Profile Update).  Fusion Applications has been configured so that whenever an employee updates a specific person profile value,  an approval is needed. There may be multiple approval levels based the approval rules.

Developers have a requirement  to report on the list of approvals for a given transaction. The approval information is not stored in Fusion Applications, but is available in BPM. This is described in KM document What Are The PO Requisition History Tables In Fusion? (Doc ID 1548407.1)

This BPM information is in table prc_fusion_soainfra.wftask.  Fusion schema does not have access to this table. Developers need  access to the workflow tables for reporting purposes.



Cause

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