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 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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

Error with report

edited Dec 12, 2022 8:40AM in Taleo Learn 10 comments

Summary

When I add a location table I lose over 100 enrollments

Content

I started by creating a report of future enrollments.  I have the following tables 

  1. LearnCenters
  2. Users
  3. enrollments
  4. Enrollments Progress
  5. ILT Session

When this report runs I get 2289 lines of data

When I add the Location table and join location to session I get 1692 lines of data.  I lose 101 enrollments.  I have double checked the session to make sure the sessions has a valid location and it does.  I have worked on this report for several hours and clearly cannot see where the difference is coming from and why the it is skipping over some of the enrollments.  Any help  would be appreciated.  I am including the export files for these two reports.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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