{"id":30996,"date":"2022-12-18T03:45:25","date_gmt":"2022-12-18T03:45:25","guid":{"rendered":"http:\/\/kovaion-new1.local\/oracle-learn-leaderboard-all-you-need-to-know\/"},"modified":"2026-01-06T12:53:05","modified_gmt":"2026-01-06T12:53:05","slug":"oracle-learn-leaderboard-all-you-need-to-know","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/oracle-learn-leaderboard-all-you-need-to-know\/","title":{"rendered":"Oracle Learn \u2013 Leaderboard | All You Need to Know"},"content":{"rendered":"<p>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.<\/p>\n<p>The administrator Leaderboard helps to monitor the user\u2019s performance in acquiring the courses and completing them. With this leaderboard, Learning Administrators can:<\/p>\n<ul>\n<li>View how many courses are completed by employees<\/li>\n<li>Which courses are assigned to them?<\/li>\n<li>How many points are awarded for a particular course?<\/li>\n<\/ul>\n<p>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.<\/p>\n<p>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\u2019 data.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Configurations pertinent to Leaderboard<\/strong><\/h2>\n<p>The Learning Administrators Leaderboard is configured as below.<\/p>\n<ul>\n<li>Learning Completion Track<\/li>\n<li>Learning Contribution Track<\/li>\n<li>Trophies<\/li>\n<li>Trophies Lists<\/li>\n<\/ul>\n<p>Let\u2019s explore the Oracle Learn \u2013 Leaderboard sequentially<\/p>\n<p>&nbsp;<\/p>\n<h3><strong>1. Learning Completion Track<\/strong><\/h3>\n<p>The Learning Completion Track on the Leaning Administrator Leaderboard will provide an overview of the learner\u2019s 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.<\/p>\n<h4><strong>To configure this learning completion track, follow the below-mentioned steps.<\/strong><\/h4>\n<ul>\n<li>Login into the application and navigate to the Tools\/Reports &amp; Analytics\/Browse Catalog\/Create\/Select the Analysis.<\/li>\n<li>Select Workforce Learning \u2013 Learning Management Real Time subject area to accomplish this requirement.<\/li>\n<li>Drag and drop all the columns which are required to represent in the Completion Track.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2462\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Learning-Completion-Track-Criteria-1024x482-1-300x141-1.png\" alt=\"Learning-Completion-Track-Learning-Completion-Track-Criteria\" width=\"634\" height=\"298\" \/><\/p>\n<p>Fig 1: Learning Completion Track Criteria<\/p>\n<ul>\n<li>In the results section, select the table view in the left corner under views.<\/li>\n<\/ul>\n<figure id=\"attachment_2461\" aria-describedby=\"caption-attachment-2461\" style=\"width: 617px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2461\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Selection-of-Table-View-1024x472-1-300x138-1.png\" alt=\"Learning-Completion-Track-Selection-of-Table-View-1024x472\" width=\"617\" height=\"284\" \/><figcaption id=\"caption-attachment-2461\" class=\"wp-caption-text\">Fig 2: Selection of Table<\/figcaption><\/figure>\n<ul>\n<li>The Alignments of texts, colors, and highlights can be done in the edit mode, which is highlighted in the above image.<\/li>\n<li>Users can also exclude or include the columns based on the requirement to represent on output.<\/li>\n<\/ul>\n<figure id=\"attachment_2460\" aria-describedby=\"caption-attachment-2460\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2460\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Formatting-the-Column-properties-1024x455-1-300x133-1.png\" alt=\"Learning-Completion-Track-Formatting-the-Column-properties\" width=\"600\" height=\"266\" \/><figcaption id=\"caption-attachment-2460\" class=\"wp-caption-text\">Fig 3: Formatting the Columns Properties<\/figcaption><\/figure>\n<ul>\n<li>After completing the changes based on your requirement, give Done and Save the output.<\/li>\n<\/ul>\n<p><strong>Note<\/strong>: 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.<\/p>\n<h4><strong>Sample Logic:<\/strong><\/h4>\n<p>Here is the basic\/sample logic for Awarded points column on the learning completion track table.(CASE WHEN (FILTER(\u201cLearning Record Measures\u201d.\u201dAssignment Record Count\u201d USING (\u201cAssignment Status\u201d.\u201dCode\u201d = \u2018ORA_ASSN_REC_COMPLETE\u2019)) = \u20181\u2019AND \u201cLearning Items\u201d.\u201dLearning Item Name\u201d = \u2018HTML\u2019 AND \u201cLearning Item Type\u201d.\u201dName\u201d = \u2018Offering\u2019) THEN 5 WHEN (FILTER(\u201cLearning Record Measures\u201d.\u201dAssignment Record Count\u201d USING (\u201cAssignment Status\u201d.\u201dCode\u201d = \u2018ORA_ASSN_REC_COMPLETE\u2019)) = \u20181\u2019AND \u201cLearning Items\u201d.\u201dLearning Item Name\u201d = \u2018HTML\u2019 AND \u201cLearning Item Type\u201d.\u201dName\u201d = \u2018Course\u2019) THEN 10 END)<\/p>\n<ul>\n<li>To get the Sum value for a particular column select the sum option in the Aggregate Lists mentioned in the below screenshot.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2459\" aria-describedby=\"caption-attachment-2459\" style=\"width: 611px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2459\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Selection-of-Aggregate-Rules-1024x458-1-300x134-1.png\" alt=\"Learning-Completion-Track-Selection-of-Aggregate-Rules\" width=\"611\" height=\"273\" \/><figcaption id=\"caption-attachment-2459\" class=\"wp-caption-text\">Fig 4: Selection of Aggregate Rules<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>To make the dashboard more magnificent users can also display the flags or any other images by writing some HTML code.<\/li>\n<li>For displaying images, select the Static option which is listed under views.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2458\" aria-describedby=\"caption-attachment-2458\" style=\"width: 616px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2458\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Selection-of-Static-Option-1024x453-1-300x133-1.png\" alt=\"Learning-Completion-Track-Selection-of-Static-Option-1024x453\" width=\"616\" height=\"273\" \/><figcaption id=\"caption-attachment-2458\" class=\"wp-caption-text\">Fig 5: Selection of Static option.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>HTML Code for sample flag image<\/li>\n<\/ul>\n<p><strong>Note<\/strong>: Any image can be added based on the user\u2019s requirement<\/p>\n<p>&lt;table style=\u201dbackground-color: #eeeeee;\u201d&gt;<br \/>\n&lt;tbody&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;&lt;imgsrc=\u201dhttps:\/\/&lt;instance details&gt;\/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytaw\/otk2\/~edisp\/ucmfa00996591.png\u201d height=\u201d180\u2033 width=\u201d180\u2033&gt;&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;\/tbody&gt;<br \/>\n&lt;\/table&gt;<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2457\" aria-describedby=\"caption-attachment-2457\" style=\"width: 577px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2457\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-HTML-Code-Placed-Area-1024x400-1-300x117-1.png\" alt=\"Learning-Completion-Track-HTML-Code-Placed-Area\" width=\"577\" height=\"225\" \/><figcaption id=\"caption-attachment-2457\" class=\"wp-caption-text\">Fig 6: HTML Code placed area<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2456\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Overview-of-Static-Flag-1024x462-1-300x135-1.png\" alt=\"Learning-Completion-Track-Overview-of-Static-Flag\" width=\"580\" height=\"261\" \/><\/p>\n<p>Fig 7: Overview of Static Flag image<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>In the above screenshot, the Completion Ratio is getting highlighted which will represent the employee\u2019s efficiency in utilizing the courses and completing them.<\/li>\n<li>To highlight any column in such a way, select the Performance Tile as same as Static text lists under views.<\/li>\n<\/ul>\n<figure id=\"attachment_2455\" aria-describedby=\"caption-attachment-2455\" style=\"width: 571px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2455\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Selection-of-Performance-Tile-1024x456-1-300x134-1.png\" alt=\"Learning-Completion-Track-Selection-of-Performance-Tile\" width=\"571\" height=\"255\" \/><figcaption id=\"caption-attachment-2455\" class=\"wp-caption-text\">Fig 8: Selection of Performance Tile<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>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.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2454\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Formatting-the-Performance-Tile-1024x468-1-300x137-1.png\" alt=\"Learning-Completion-Track-Formatting-the-Performance-Tile-\" width=\"567\" height=\"259\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>After making all the required changes, navigate to the result page to view the result.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2453\" aria-describedby=\"caption-attachment-2453\" style=\"width: 563px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2453\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Completion-Track-Overview-of-Learning-Completion-Track-1024x468-1-300x137-1.png\" alt=\"Learning-Completion-Track-Overview-of-Learning-Completion-Track-1024x468\" width=\"563\" height=\"257\" \/><figcaption id=\"caption-attachment-2453\" class=\"wp-caption-text\">Fig 9: Formatting the Performance Tile<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h2><strong>2. Learning Contribution Track<\/strong><\/h2>\n<p>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.<\/p>\n<p>To do this setup follow the same steps mentioned above and perform all the required changes.<\/p>\n<ul>\n<li>The Average Popularity is displayed based on the No.of visits, ratings, and recommendations.<\/li>\n<li>To display the average popularity, use the below sample code.Sample Logic for Average Popularity on Learning Contribution Track (CASE WHEN (FILTER(\u201cEvent\u201d.\u201dEvent Count\u201d USING (\u201cEvent Type\u201d.\u201dCode\u201d = \u2018ORA_LI_VISIT\u2019)) IS NULL) THEN 0 ELSE FILTER(\u201cEvent\u201d.\u201dEvent Count\u201d USING (\u201cEvent Type\u201d.\u201dCode\u201d = \u2018ORA_LI_VISIT\u2019)) END)+ (CASE WHEN \u201cRating\u201d.\u201dRatings\u201d IS NULL THEN 0 ELSE \u201cRating\u201d.\u201dRatings\u201d END)+ (CASE WHEN (FILTER(\u201cEvent\u201d.\u201dEvent Count\u201d USING (\u201cEvent Type\u201d.\u201dCode\u201d = \u2018ORA_RECOMMEND_ASSIGNMENT\u2019)) IS NULL) THEN 0 ELSE FILTER(\u201cEvent\u201d.\u201dEvent Count\u201d USING (\u201cEvent Type\u201d.\u201dCode\u201d = \u2018ORA_RECOMMEND_ASSIGNMENT\u2019)) END)\/100<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2452\" aria-describedby=\"caption-attachment-2452\" style=\"width: 596px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2452\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Contribution-Track-Overview-of-Learning-Contribution-Track-300x135.png\" alt=\"Learning-Contribution-Track-Overview-of-Learning-Contribution-Track\" width=\"596\" height=\"268\" \/><figcaption id=\"caption-attachment-2452\" class=\"wp-caption-text\">Fig 11: Overview of Learning Contribution Track.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p><strong>Note<\/strong>: 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.<\/p>\n<ul>\n<li>On the Learning Completion track report, click on the Person User Name settings icon\/Column Properties\/Interaction.<\/li>\n<li>On the value section, click on Add and browse the respective report ex: Learning Contribution Track.<\/li>\n<\/ul>\n<figure id=\"attachment_2451\" aria-describedby=\"caption-attachment-2451\" style=\"width: 630px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2451\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Learning-Contribution-Track-Linking-of-Twor-Reports-in-the-Interation-Tab-1024x576-1-300x169-1.png\" alt=\"Learning-Contribution-Track-Linking-of-Twor-Reports-in-the-Interation-Tab\" width=\"630\" height=\"355\" \/><figcaption id=\"caption-attachment-2451\" class=\"wp-caption-text\">Fig 12: Linking of Two Reports in the Interaction tab.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<h2><strong>3. Trophies<\/strong><\/h2>\n<p>The next on the queue on the Oracle Learn \u2013 Leaderboard is Trophies. Trophies will be awarded to the employees based on the maximum number of courses completed.<\/p>\n<p>To configure these trophies user needs to write a piece of HTML code along with the suitable conditions.<\/p>\n<ul>\n<li>In this setup, there is such type of configuration where,\n<ul>\n<li>If the user completes 2 to 3 courses, the Bronze Cup will be granted.<\/li>\n<li>If the user completes 4 to 5 courses, the Bowl Cup will be awarded.<\/li>\n<li>If the user completes 6 to 7 courses, the Silver Cup will be granted.<\/li>\n<li>If the user completes more than 7 courses, the Golden Cup will be awarded.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>The sample HTML code along with the conditions is mentioned below for users\u2019 reference.<\/p>\n<h3><strong>Sample Code for each type of trophies<\/strong><\/h3>\n<p>(CASE WHEN \u201cLearning Record Measures\u201d.\u201dCompletion Count\u201d IN (1,2) THEN \u2018&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;font size=\u201d6\u2033&gt;&amp;#129352;&amp;#129352;&amp;#129352;&lt;\/p&gt;&lt;\/font&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;img src=\u201dhttps:\/\/&lt;instance&gt;\/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002832.png\u201d&gt;\u2019||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style=\u201dcolor:GreenYellow;\u201d&gt;BRONZE IS STARTING STEP OF YOUR JOURNEY&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019 ELSE (CASE WHEN \u201cLearning Record Measures\u201d.\u201dCompletion Count\u201d IN (3,4) THEN \u2018&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;font size=\u201d6\u2033&gt;&amp;#129353;&amp;#129358;&amp;#129353;&lt;\/p&gt;&lt;\/font&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;img src=\u201dhttps:\/\/ &lt;instance&gt;\/\/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002839.png\u201d&gt;\u2019 ||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style=\u201dcolor:Orange;\u201d&gt;YOU ARE RUNNING LIKE A BALL&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019 ELSE (CASE WHEN \u201cLearning Record Measures\u201d.\u201dCompletion Count\u201d IN (5,6) THEN \u2018&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;font size=\u201d6\u2033&gt;&amp;#129352;&amp;#129355;&amp;#129352;&lt;\/p&gt;&lt;\/font&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;img src=\u201dhttps:\/\/&lt;instance&gt;\/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002830.png\u201d&gt;\u2019 ||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style=\u201dcolor:Chartreuse\u201d&gt;CONGRATULATIONS!\u2026&lt;\/h2&gt; &lt;h2 style=\u201dcolor:#3F3F3F;\u201d&gt;FOR SILVER TROPHY&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019 ELSE (CASE WHEN \u201cLearning Record Measures\u201d.\u201dCompletion Count\u201d &gt;=7 THEN \u2018&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;font size=\u201d6\u2033&gt;&amp;#10024;&amp;#10024;&amp;#10024;&lt;\/p&gt;&lt;\/font&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;img src=\u201dhttps:\/\/ \/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002831.png\u201d&gt;\u2019||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style=\u201dcolor:MediumSeaGreen;\u201d&gt;Hurry!\u2026&lt;\/h2&gt;&lt;h2 style=\u201dcolor:Orange;\u201d&gt;YOU WON A GOLDEN CUP&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019 END)END)END)END)<\/p>\n<ul>\n<li>Once the code runs successfully, then the respective person will be awarded as below. (This should be shifted below)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2450\" aria-describedby=\"caption-attachment-2450\" style=\"width: 600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2450\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Trophies-Creation-of-Trophies-1024x418-1-300x122-1.png\" alt=\"Trophies-Creation-of-Trophies-1024x418\" width=\"600\" height=\"244\" \/><figcaption id=\"caption-attachment-2450\" class=\"wp-caption-text\">Fig 13: Creation of Trophies.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2449\" aria-describedby=\"caption-attachment-2449\" style=\"width: 591px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2449\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Trophies-Overview-of-Trophies-1024x476-1-300x139-1.png\" alt=\"Trophies-Overview-of-Trophies-1024x476\" width=\"591\" height=\"274\" \/><figcaption id=\"caption-attachment-2449\" class=\"wp-caption-text\">Fig 14: Overview of Trophies.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Note: As mentioned above, the user needs to establish the connection between Learning Contribution Track and Trophies.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>4. Trophies Lists<\/strong><\/h2>\n<p>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.<\/p>\n<p>This process can be accomplished by writing HTML code along with conditions.<\/p>\n<p><strong>Note<\/strong>: Add the below sample code by clicking the setting icon near the Trophy option.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2448\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Trophies-List-Trohpies-List-Criteria-300x122.png\" alt=\"Trophies-List-Trohpies-List-Criteria\" width=\"772\" height=\"314\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Sample Code<\/strong><\/p>\n<p>CASE WHEN \u201cWorker\u201d.\u201dUser Name\u201d IS NOT NULL THEN \u2018&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style =\u201dcolor:Green;\u201d&gt;Entry Level..!&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;img src=\u201dhttps:\/\/\/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002832.png\u201d&gt;\u2019||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style =\u201dcolor:Orange;\u201d&gt;Second Level&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;img src=\u201dhttps:\/\/ \/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002839.png\u201d&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019 ||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style =\u201dcolor:#3F3F3F;\u201d&gt;Silver Cup for Experienced\u2026!&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;html&gt;&lt;body&gt;&lt;p&gt; &lt;img src=\u201dhttps:\/\/ cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002830.png\u201d&gt; &lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;html&gt;&lt;body&gt;&lt;p&gt;&lt;h2 style =\u201dcolor:Orange;\u201d&gt;Golden Cup for Professtionals..!&lt;\/h2&gt;&lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019||'&lt;html&gt;&lt;body&gt;&lt;p&gt; &lt;img src=\u201dhttps:\/\/&lt;instance&gt; \/cs\/groups\/ucm_spaces\/documents\/digitalmedia\/ytax\/mday\/~edisp\/ucmfa01002831.png\u201d&gt; &lt;\/p&gt;&lt;\/body&gt;&lt;\/html&gt;\u2019 ELSE \u2018123\u2019 END<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2447\" aria-describedby=\"caption-attachment-2447\" style=\"width: 809px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2447\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Trophies-List-Lists-1024x450-1-300x132-1.png\" alt=\"Trophies-List-Lists\" width=\"809\" height=\"356\" \/><figcaption id=\"caption-attachment-2447\" class=\"wp-caption-text\">Fig 15: Trophies Lists.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2446\" aria-describedby=\"caption-attachment-2446\" style=\"width: 663px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2446\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Trophies-Lies-List-300x134.png\" alt=\"Trophies-Lies-List\" width=\"663\" height=\"296\" \/><figcaption id=\"caption-attachment-2446\" class=\"wp-caption-text\">Fig 16: Trophies List.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Here follows the output for the written piece of code.<\/p>\n<p><strong>Note<\/strong>: It is not mandatory to establish the connection for listing Trophies.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Displaying all four reports in the Dashboard<\/strong><\/h2>\n<p>For Displaying Leaderboard details in the dashboard perform the steps mentioned below:<\/p>\n<ul>\n<li>Create one dashboard (Click on Create\/Dashboard).<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2445\" aria-describedby=\"caption-attachment-2445\" style=\"width: 677px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2445\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Configuring-the-Dashboard-980x303-1-300x93-1.png\" alt=\"Configuring-the-Dashboard-980x303\" width=\"677\" height=\"210\" \/><figcaption id=\"caption-attachment-2445\" class=\"wp-caption-text\">Fig 17: Configuring the Dashboard.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Drag and drop the four sets of Columns based on the requirement and each column with one section.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2444\" aria-describedby=\"caption-attachment-2444\" style=\"width: 659px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2444\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Drag-and-Drop-the-Reports-into-Dashboard-980x448-1-300x137-1.png\" alt=\"Drag-and-Drop-the-Reports-into-Dashboard-980x448\" width=\"659\" height=\"301\" \/><figcaption id=\"caption-attachment-2444\" class=\"wp-caption-text\">Fig 18: Drag and Drop the Reports.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Select the respective report and drag and drop over each column and run the report.<\/li>\n<\/ul>\n<p>Note: Users should create one common prompt for all three reports and drag it to the dashboard.<\/p>\n<ul>\n<li>Run the report to view the result below.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2443\" aria-describedby=\"caption-attachment-2443\" style=\"width: 689px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2443\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Overview-of-Administrative-Leaderboard-300x169.png\" alt=\"Overview-of-Administrative-Leaderboard\" width=\"689\" height=\"388\" \/><figcaption id=\"caption-attachment-2443\" class=\"wp-caption-text\">Fig 19: Overview of Administrative Leader Board.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>On the oracle learn \u2013 leaderboard module, Learning Administrators can search with person numbers to view the individual\u2019s data if required.<\/li>\n<\/ul>\n<p>It is also possible to configure this leaderboard only for the employee level, where only login users can view their data.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2442\" aria-describedby=\"caption-attachment-2442\" style=\"width: 636px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2442\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Employee-Level-Leaderboard-Configuring-the-Employee-Level-Leader-Board-300x118.png\" alt=\"Employee-Level-Leaderboard-Configuring-the-Employee-Level-Leader-Board.\" width=\"636\" height=\"250\" \/><figcaption id=\"caption-attachment-2442\" class=\"wp-caption-text\">Fig 20: Configuring the Employee Level Leader Board<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>For this, the user needs to set the session variable as USER in the Person User Name filter for each report.<\/p>\n<p><strong>Note<\/strong>: It is not mandatory to create the standard prompt, for the Employee level leaderboard<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2441\" aria-describedby=\"caption-attachment-2441\" style=\"width: 666px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2441\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Employee-Level-Leadeboard-Linking-Two-Reports-300x132.png\" alt=\"Employee-Level-Leadeboard-Linking-Two-Reports\" width=\"666\" height=\"293\" \/><figcaption id=\"caption-attachment-2441\" class=\"wp-caption-text\">Fig 21: Link between two reports.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>For the Employee level Leaderboard, the user should establish the connection between Learning Completion Track and Employee Trophies.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_2440\" aria-describedby=\"caption-attachment-2440\" style=\"width: 645px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2440\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Employee-Level-Leaderboard-Overview-of-Employee-Level-Leaderboard-1024x480-1-300x141-1.png\" alt=\"Employee-Level-Leaderboard-Overview-of-Employee-Level-Leaderboard-1024x480\" width=\"645\" height=\"303\" \/><figcaption id=\"caption-attachment-2440\" class=\"wp-caption-text\">Fig 22: Overview of Employee Level Leader Board.<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Perform the same actions mentioned above for creating and running the dashboard.<\/li>\n<li>If an employee doesn\u2019t complete any course, they will not be awarded any type of reward (Cups), and it is available as per the above screenshot.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>The bottom line<\/strong><\/h2>\n<p>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\u2019s through skill-based assessments or competency-based assessments.<\/p>\n<p>If you\u2019re 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.<\/p>\n<p><strong>Author<\/strong>:<br \/>\nDileep Kumar Dasari<br \/>\nOracle HCM Cloud Consultant | Kovaion Consulting<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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\u2019s performance in acquiring the courses and completing them. With this leaderboard, Learning Administrators can: View how many courses [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":21322,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-30996","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-hcm"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30996","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=30996"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30996\/revisions"}],"predecessor-version":[{"id":30997,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/30996\/revisions\/30997"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/21322"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=30996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=30996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=30996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}