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

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

Question
33
Views
0
Comments

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!