My Oracle Support Banner

Table Linkage Between Workflow Table (FA_FUSION_SOAINFRA.WFTASK) And Projects Table (PJF_PROJECTS_ALL_B) (Doc ID 2394836.1)

Last updated on MARCH 28, 2023

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.13.17.05.0 and later
Information in this document applies to any platform.

Goal

The customer is working on a BI Publisher report for all pending projects approval (ContractsApproval, ProjectStatusNotificationApproval, and Forecast Approval).
They are using the FA_FUSION_SOAINFRA.WFTASK table to get the workflow statuses but cannot find the column to link it to projects table, PJF_PROJECTS_ALL_B.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.