Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Get the list of persons included in an Access for a Learning Offering
Summary
Access Group Details For each Offering name and EmployeeContent
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
Tagged:
0