Oracle Fusion AI Data Platform Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Idea Labs› Oracle Fusion AI Data Platform Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Primary Key and Constraints for

Needs Votes
511
Views
2
Comments
RFong at PSJH
RFong at PSJH Rank 3 - Community Apprentice
in Oracle Fusion AI Data Platform Idea Lab

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Providence St Joseph Health

Description (Required):

Can you provide primary keys for below tables?

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

Use Case and Business Need (Required):

We have operational reports that require the collection of these tables. Some tables are large and requires Primary Keys and other constraints to create ETL efficiencies.

Enhancement Request / Service Request:

SR 3-30837503261 : Required help on FA_FUSION_SOAINFRA tables

Tagged:
6
Up
6 votes

Needs Votes · Last Updated

Comments

  • RFong at PSJH
    RFong at PSJH Rank 3 - Community Apprentice

    Will help users that require WF tables to query for analysis.

  • Karmveer
    Karmveer Rank 1 - Community Starter

    Hi Team,

    Workflow tables are required for operations support and matrix, it would be great to consider this request as an ER to track for near future.

    Regards

    Karmveer