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

Report - Notifications a learner received on learnings

Received Response
15
Views
3
Comments
edited Dec 17, 2020 8:06AM in Learning 3 comments

Summary

SQL / Report to Get List of notifications a learner received

Content

Team,

We have a requirement to build a report to display Offering Details (Offering Title, Start Date, End Date, etc) with Recipients, Subject, Message Text , etc.,

We are unable to find all the details in the subject area "Human Capital Management - Approval Notification Archive Real Time" in OTBI.

Tried with the below tables in BI and could not find the details.

 fa_fusion_soainfra.wftask                    fwt
       , fa_fusion_soainfra.wfassignee                fwa
       , fa_fusion_soainfra.wftaskhistory             fwh
       , fa_fusion_soainfra.wfcomments                fwc
       , fa_fusion_soainfra.wfattachment              fwat
       , fa_fusion_soainfra.wftaskassignmentstatistic fwst

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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