Sunday, March 26, 2023

Fusion workflow notification tables

Fusion Can we access tables in the XXX_FUSION_SOAINFRA schema in order to report on Workflow Notifications ? (Doc ID 2010398.1) Starting with Release 13 of Fusion Application the FUSION_RUNTIME has been granted with access on the following schemas: FA_FUSION_SOAINFRA A list of tables that can be queries through BI Publisher can be found below. FA_FUSION_SOAINFRA.WFTASK FA_FUSION_SOAINFRA.WFASSIGNEE FA_FUSION_SOAINFRA.WFCOMMENTS FA_FUSION_SOAINFRA.WFATTACHMENT FA_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC FA_FUSION_SOAINFRA.WFTASKHISTORY FA_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE FA_FUSION_SOAINFRA.WFAPPROVALGROUPS FA_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS FA_FUSION_SOAINFRA.WFCOLLECTIONTARGET For HCM_FUSION_SOAINFRA tables you can use also the Human Capital Management - Approval Notification Archive Real Time subject area.