Oracle Learn – Leaderboard | All You Need to Know

In the Oracle Learn module, the Leaderboard configuration gives an overall analysis of offered courses and other course offerings in a simplified way to the Learning Administrators and Employees.

The administrator Leaderboard helps to monitor the user’s performance in acquiring the courses and completing them. With this leaderboard, Learning Administrators can:

  • View how many courses are completed by employees
  • Which courses are assigned to them?
  • How many points are awarded for a particular course?

This will also provide information like the number of visits for a particular course, ratings, recommendations, and average popularity for that course. Based on employee performance and the number of studies completed, Administrators can assign trophies to them.

Employees Leaderboard has been configured accordingly where login users can view their details regarding the completed number of courses and offerings, awarded points, and the type of trophy assigned to them. With Employee Leaderboard, users cannot view other employees’ data.


Configurations pertinent to Leaderboard

The Learning Administrators Leaderboard is configured as below.

  • Learning Completion Track
  • Learning Contribution Track
  • Trophies
  • Trophies Lists

Let’s explore the Oracle Learn – Leaderboard sequentially


1. Learning Completion Track

The Learning Completion Track on the Leaning Administrator Leaderboard will provide an overview of the learner’s activity details based on the type of course assigned, points awarded for completed courses, the total count of assigned courses and offerings, and the average completion ratio on overall assigned courses and completed.

To configure this learning completion track, follow the below-mentioned steps.

  • Login into the application and navigate to the Tools/Reports & Analytics/Browse Catalog/Create/Select the Analysis.
  • Select Workforce Learning – Learning Management Real Time subject area to accomplish this requirement.
  • Drag and drop all the columns which are required to represent in the Completion Track.


Fig 1: Learning Completion Track Criteria

  • In the results section, select the table view in the left corner under views.

Fig 2: Selection of Table

  • The Alignments of texts, colors, and highlights can be done in the edit mode, which is highlighted in the above image.
  • Users can also exclude or include the columns based on the requirement to represent on output.

Fig 3: Formatting the Columns Properties

  • After completing the changes based on your requirement, give Done and Save the output.

Note: By default, there is no points configuration provided by oracle for the course and offerings. For representing the points based on the user requirements for a particular course or offering use the below-mentioned logic.

Sample Logic:

Here is the basic/sample logic for Awarded points column on the learning completion track table.(CASE WHEN (FILTER(“Learning Record Measures”.”Assignment Record Count” USING (“Assignment Status”.”Code” = ‘ORA_ASSN_REC_COMPLETE’)) = ‘1’AND “Learning Items”.”Learning Item Name” = ‘HTML’ AND “Learning Item Type”.”Name” = ‘Offering’) THEN 5 WHEN (FILTER(“Learning Record Measures”.”Assignment Record Count” USING (“Assignment Status”.”Code” = ‘ORA_ASSN_REC_COMPLETE’)) = ‘1’AND “Learning Items”.”Learning Item Name” = ‘HTML’ AND “Learning Item Type”.”Name” = ‘Course’) THEN 10 END)

  • To get the Sum value for a particular column select the sum option in the Aggregate Lists mentioned in the below screenshot.



Fig 4: Selection of Aggregate Rules


  • To make the dashboard more magnificent users can also display the flags or any other images by writing some HTML code.
  • For displaying images, select the Static option which is listed under views.



Fig 5: Selection of Static option.


  • HTML Code for sample flag image

Note: Any image can be added based on the user’s requirement

<table style=”background-color: #eeeeee;”>
<td><imgsrc=”https://<instance details>/cs/groups/ucm_spaces/documents/digitalmedia/ytaw/otk2/~edisp/ucmfa00996591.png” height=”180″ width=”180″></td>



Fig 6: HTML Code placed area



Fig 7: Overview of Static Flag image


  • In the above screenshot, the Completion Ratio is getting highlighted which will represent the employee’s efficiency in utilizing the courses and completing them.
  • To highlight any column in such a way, select the Performance Tile as same as Static text lists under views.

Fig 8: Selection of Performance Tile


  • Once the user clicks the Performance Tile, the screen is displayed with a few seeded format tiles, where the user can select one of the types and make the changes by adjusting and aligning colors to that field, followed by selecting the field to display on the Performance tile.




  • After making all the required changes, navigate to the result page to view the result.



Fig 9: Formatting the Performance Tile


2. Learning Contribution Track

The Learning Contribution Track on the Oracle leaderboard will help the Learning Administrator to view the overall status of all courses such as ratings, number of Visits, recommendations, and average popularity.

To do this setup follow the same steps mentioned above and perform all the required changes.

  • The Average Popularity is displayed based on the No.of visits, ratings, and recommendations.
  • To display the average popularity, use the below sample code.Sample Logic for Average Popularity on Learning Contribution Track (CASE WHEN (FILTER(“Event”.”Event Count” USING (“Event Type”.”Code” = ‘ORA_LI_VISIT’)) IS NULL) THEN 0 ELSE FILTER(“Event”.”Event Count” USING (“Event Type”.”Code” = ‘ORA_LI_VISIT’)) END)+ (CASE WHEN “Rating”.”Ratings” IS NULL THEN 0 ELSE “Rating”.”Ratings” END)+ (CASE WHEN (FILTER(“Event”.”Event Count” USING (“Event Type”.”Code” = ‘ORA_RECOMMEND_ASSIGNMENT’)) IS NULL) THEN 0 ELSE FILTER(“Event”.”Event Count” USING (“Event Type”.”Code” = ‘ORA_RECOMMEND_ASSIGNMENT’)) END)/100



Fig 11: Overview of Learning Contribution Track.


Note: Establishing the connection between two reports is mandatory to view the respective details in the dashboard and this can be done in the Interaction tab.

  • On the Learning Completion track report, click on the Person User Name settings icon/Column Properties/Interaction.
  • On the value section, click on Add and browse the respective report ex: Learning Contribution Track.

Fig 12: Linking of Two Reports in the Interaction tab.


3. Trophies

The next on the queue on the Oracle Learn – Leaderboard is Trophies. Trophies will be awarded to the employees based on the maximum number of courses completed.

To configure these trophies user needs to write a piece of HTML code along with the suitable conditions.

  • In this setup, there is such type of configuration where,
    • If the user completes 2 to 3 courses, the Bronze Cup will be granted.
    • If the user completes 4 to 5 courses, the Bowl Cup will be awarded.
    • If the user completes 6 to 7 courses, the Silver Cup will be granted.
    • If the user completes more than 7 courses, the Golden Cup will be awarded.

The sample HTML code along with the conditions is mentioned below for users’ reference.

Sample Code for each type of trophies

(CASE WHEN “Learning Record Measures”.”Completion Count” IN (1,2) THEN ‘<html><body><p><font size=”6″>&#129352;&#129352;&#129352;</p></font></body></html>’||'<img src=”https://<instance>/cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002832.png”>’||'<html><body><p><h2 style=”color:GreenYellow;”>BRONZE IS STARTING STEP OF YOUR JOURNEY</h2></p></body></html>’ ELSE (CASE WHEN “Learning Record Measures”.”Completion Count” IN (3,4) THEN ‘<html><body><p><font size=”6″>&#129353;&#129358;&#129353;</p></font></body></html>’||'<img src=”https:// <instance>//cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002839.png”>’ ||'<html><body><p><h2 style=”color:Orange;”>YOU ARE RUNNING LIKE A BALL</h2></p></body></html>’ ELSE (CASE WHEN “Learning Record Measures”.”Completion Count” IN (5,6) THEN ‘<html><body><p><font size=”6″>&#129352;&#129355;&#129352;</p></font></body></html>’||'<img src=”https://<instance>/cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002830.png”>’ ||'<html><body><p><h2 style=”color:Chartreuse”>CONGRATULATIONS!…</h2> <h2 style=”color:#3F3F3F;”>FOR SILVER TROPHY</h2></p></body></html>’ ELSE (CASE WHEN “Learning Record Measures”.”Completion Count” >=7 THEN ‘<html><body><p><font size=”6″>&#10024;&#10024;&#10024;</p></font></body></html>’||'<img src=”https:// /cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002831.png”>’||'<html><body><p><h2 style=”color:MediumSeaGreen;”>Hurry!…</h2><h2 style=”color:Orange;”>YOU WON A GOLDEN CUP</h2></p></body></html>’ END)END)END)END)

  • Once the code runs successfully, then the respective person will be awarded as below. (This should be shifted below)



Fig 13: Creation of Trophies.



Fig 14: Overview of Trophies.


Note: As mentioned above, the user needs to establish the connection between Learning Contribution Track and Trophies.


4. Trophies Lists

The Trophies Lists will display the type of trophies present in the dashboard and which trophy is awarded to the employees based on their performance of course completion.

This process can be accomplished by writing HTML code along with conditions.

Note: Add the below sample code by clicking the setting icon near the Trophy option.




Sample Code

CASE WHEN “Worker”.”User Name” IS NOT NULL THEN ‘<html><body><p><h2 style =”color:Green;”>Entry Level..!</h2></p></body></html>’||'<img src=”https:///cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002832.png”>’||'<html><body><p><h2 style =”color:Orange;”>Second Level</h2></p></body></html>’||'<html><body><p><img src=”https:// /cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002839.png”></p></body></html>’ ||'<html><body><p><h2 style =”color:#3F3F3F;”>Silver Cup for Experienced…!</h2></p></body></html>’||'<html><body><p> <img src=”https:// cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002830.png”> </p></body></html>’||'<html><body><p><h2 style =”color:Orange;”>Golden Cup for Professtionals..!</h2></p></body></html>’||'<html><body><p> <img src=”https://<instance> /cs/groups/ucm_spaces/documents/digitalmedia/ytax/mday/~edisp/ucmfa01002831.png”> </p></body></html>’ ELSE ‘123’ END



Fig 15: Trophies Lists.



Fig 16: Trophies List.


Here follows the output for the written piece of code.

Note: It is not mandatory to establish the connection for listing Trophies.


Displaying all four reports in the Dashboard

For Displaying Leaderboard details in the dashboard perform the steps mentioned below:

  • Create one dashboard (Click on Create/Dashboard).



Fig 17: Configuring the Dashboard.


  • Drag and drop the four sets of Columns based on the requirement and each column with one section.



Fig 18: Drag and Drop the Reports.


  • Select the respective report and drag and drop over each column and run the report.

Note: Users should create one common prompt for all three reports and drag it to the dashboard.

  • Run the report to view the result below.



Fig 19: Overview of Administrative Leader Board.


  • On the oracle learn – leaderboard module, Learning Administrators can search with person numbers to view the individual’s data if required.

It is also possible to configure this leaderboard only for the employee level, where only login users can view their data.



Fig 20: Configuring the Employee Level Leader Board


For this, the user needs to set the session variable as USER in the Person User Name filter for each report.

Note: It is not mandatory to create the standard prompt, for the Employee level leaderboard



Fig 21: Link between two reports.


  • For the Employee level Leaderboard, the user should establish the connection between Learning Completion Track and Employee Trophies.



Fig 22: Overview of Employee Level Leader Board.


  • Perform the same actions mentioned above for creating and running the dashboard.
  • If an employee doesn’t complete any course, they will not be awarded any type of reward (Cups), and it is available as per the above screenshot.


The bottom line

The Oracle learn leaderboard is one of the significant features of the Oracle HCM cloud, as it provides detailed analytics of all the courses offered by the Learning Administrators. The learner can plan based on their learning needs to know what courses they need to study. Also, it provides multiple ways to conduct learning analytics and track how effectively employees are performing their duties, whether it’s through skill-based assessments or competency-based assessments.

If you’re a business person searching for the best Oracle HCM cloud service, feel free to connect with Kovaion. As Oracle partners, we offer the best Oracle HCM cloud service at an affordable cost for enterprises to make their business effective and efficient.

Dileep Kumar Dasari
Oracle HCM Cloud Consultant | Kovaion Consulting

Oracle HCM Service

Implement, Enhance, Update & Support Oracle HCM at Zero Cost!

Read More