OTBI Report for Learning module, to extract expiration dates of courses

Summary:

I'm trying to create an OTBI report that will show the courses, assignees and expiration dates from the Learning module but am struggling to pull through validity data that matches what we're seeing on the front end.

Content (please ensure you mask any confidential information):

I'm trying to create an OTBI report that will show the courses, assignees and expiration dates from the Learning module. We have a number of courses that have Default Assignment Rules as per below:

Initial Assignment Status: Active

Validity Period Starts: After completion

Validity Period Expires: Expires in years

Valid For: One Year

Renewal Options: Do not create a renewal assignment