You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we use FA_FUSION_SOAINFRA.WFTASKHISTORY and WFCOMMENTS for custom reports in Oracle Fusion?

edited Apr 2, 2025 10:39AM in Fusion Applications Administration 5 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!