Get the list of persons included in an Access for a Learning Offering — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Get the list of persons included in an Access for a Learning Offering

edited Oct 15, 2020 6:47PM in Reporting and Analytics for HCM 2 comments

Summary

Access Group Details For each Offering name and Employee

Content

Hi  Every One,

for an Offering in the Learning Catalog I have created an Access Group. I would like to extract from HCM tables the list of persons and Offering name  that are included in that Access. Now, i am getting Access group details but i need to show Offering name is also in BIP report . 

Which table and table field  i need to join to get the Offering Name  . Please help me on below query

SQL:

SELECT mail.person_number, wlit.name

  FROM wlf_learning_items_f wlif

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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