Can we use FA_FUSION_SOAINFRA.WFTASKHISTORY and WFCOMMENTS for custom reports in Oracle Fusion?
Summary:
Hi,
As part of our ongoing investigation into the alert issue referenced in this SR regarding Support on Approval Console Issue, we have identified a way to retrieve the required values by querying the following tables:
FA_FUSION_SOAINFRA.WFTASKHISTORY
FA_FUSION_SOAINFRA.WFCOMMENTS
Our approach involves using these tables to extract specific workflow-related details, including comments and task history. However, we would like to confirm whether these tables are officially recommended for use in custom queries or reports.
Could you please provide guidance on:
The intended use of these tables within Oracle Fusion applications.
Whether they are stable and supported for reporting purposes, or if there are alternative recommended tables/views for retrieving workflow history and comments.