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. (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.

Oracle OLM - Business wants to track a user and his assigned course progress by date wise break-up.

For ex:

*******

1. Maria John did a course on "Sexual_Harassment". She started the course on 1st Jan and stopped after an hour, again continued on 2nd Jan for an hour and finally completed the course on 3rd Jan.


Now business want to see this break-up as 3 lines in report stating user progressed in 3 different days like Start Date and End Date needed for my report. If anyone have any sql query to find the break-up.


Note: Since we have custom parameters as per business requirement, OTBI will not work. However, as a back up if you have any OTBI, please provide that as well. However my goal is to achive the requiremnt in BIP.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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