BPM Tables in system:


These tables will be available in R12

Fusion Applications BI Publisher : Can we access tables in the XXX_FUSION_SOAINFRA schema in order to report on Workflow Notifications ? (Doc ID 2010398.1)

Until Release 12 of Fusion Application the tables in the XXX_FUSION_SOAINFRA schemas (where XXX can be HCM/CRM/PRC/FIN ) which store information for Workflow Notifications are not accessible from BI Publisher.BI Publisher works through the three ApplicationDB_XXX datasources which are provided out of the box and no additional FusionDB datasources can be defined. As a result access to the XXX_FUSION_SOAINFRA schema would need to be via database grants. At present no such grants have been created and therefore the schema is inaccessible from the FUSION_RUNTIME schema

Starting with Release 12 of Fusion Application the FUSION_RUNTIME has been granted with access on the following schemas:

FIN_FUSION_SOAINFRA

PRC_FUSION_SOAINFRA

HCM_FUSION_SOAINFRA

CRM_FUSION_SOAINFRA

List of tables that can be queries through BI Publisher can be found bellow.

FIN_FUSION_SOAINFRA.WFTASK
FIN_FUSION_SOAINFRA.WFASSIGNEE
FIN_FUSION_SOAINFRA.WFCOMMENTS
FIN_FUSION_SOAINFRA.WFATTACHMENT
FIN_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC
FIN_FUSION_SOAINFRA.WFTASKHISTORY
FIN_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE
FIN_FUSION_SOAINFRA.WFAPPROVALGROUPS
FIN_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS
FIN_FUSION_SOAINFRA.WFCOLLECTIONTARGET

PRC_FUSION_SOAINFRA.WFTASK
PRC_FUSION_SOAINFRA.WFASSIGNEE
PRC_FUSION_SOAINFRA.WFCOMMENTS
PRC_FUSION_SOAINFRA.WFATTACHMENT
PRC_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC
PRC_FUSION_SOAINFRA.WFTASKHISTORY
PRC_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE
PRC_FUSION_SOAINFRA.WFAPPROVALGROUPS
PRC_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS
PRC_FUSION_SOAINFRA.WFCOLLECTIONTARGET

HCM_FUSION_SOAINFRA.WFTASK
HCM_FUSION_SOAINFRA.WFASSIGNEE
HCM_FUSION_SOAINFRA.WFCOMMENTS
HCM_FUSION_SOAINFRA.WFATTACHMENT
HCM_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC
HCM_FUSION_SOAINFRA.WFTASKHISTORY
HCM_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE
HCM_FUSION_SOAINFRA.WFAPPROVALGROUPS
HCM_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS
HCM_FUSION_SOAINFRA.WFCOLLECTIONTARGET



CRM_FUSION_SOAINFRA.WFTASK
CRM_FUSION_SOAINFRA.WFASSIGNEE
CRM_FUSION_SOAINFRA.WFCOMMENTS
CRM_FUSION_SOAINFRA.WFATTACHMENT
CRM_FUSION_SOAINFRA.WFTASKASSIGNMENTSTATISTIC
CRM_FUSION_SOAINFRA.WFTASKHISTORY
CRM_FUSION_SOAINFRA.WFMESSAGEATTRIBUTE
CRM_FUSION_SOAINFRA.WFAPPROVALGROUPS
CRM_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS
CRM_FUSION_SOAINFRA.WFCOLLECTIONTARGET

 For HCM_FUSION_SOAINFRA tables you can use also the Human Capital Management - Approval Notification Archive Real Time subject area.

An example query is:
Rport showing requisitions and purchase orders where the approver has reassigned the approval.
select distinct title, to_char(updateddate, 'dd-Mon-yyyy'), fromuser, assignees touser
from prc_fusion_soainfra.wftaskhistory where substate='REASSIGNED'
and compositename in ('PrcPorManageReqApprovalComposite', 'PrcPoApprovalComposite')
and createddate >sysdate-400;