Ability To Report On Approval History with Access To Workflow Tables
Last updated on SEPTEMBER 27, 2017
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms