Learning
Discussion List
- 
             How do I show all completions for same Course Title in OTBI report?Summary: OTBI report to show completions only shows first completion if title is the same. Need to get OTBI report to show the same data as the View Transcript (which ca…Aaron Reynolds 71 views 6 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM How do I show all completions for same Course Title in OTBI report?Summary: OTBI report to show completions only shows first completion if title is the same. Need to get OTBI report to show the same data as the View Transcript (which ca…Aaron Reynolds 71 views 6 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM
- 
             OTBI Learning records report for a Line Manager including not only Direct but also IndirectSummary: Content (required): Hi there, i cannot find an answer to the above question. We have line managers who want to see the learning completions of the direct report…Bobby Jourdan 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM OTBI Learning records report for a Line Manager including not only Direct but also IndirectSummary: Content (required): Hi there, i cannot find an answer to the above question. We have line managers who want to see the learning completions of the direct report…Bobby Jourdan 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Learning Records Subject Area - How to remove duplicate linesSummary: In the new Learning Records Real Time Subject Area, I am trying to produce a report for the following data, but when I add the Activity Details start and end ti…Mark Stoker 101 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM Learning Records Subject Area - How to remove duplicate linesSummary: In the new Learning Records Real Time Subject Area, I am trying to produce a report for the following data, but when I add the Activity Details start and end ti…Mark Stoker 101 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
- 
             Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
- 
             BIP - Non Catalog Item Report (Learning)Does anyone know how to fetch creation date using BIP? Please see screenshot below:Hazel De Castro 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM BIP - Non Catalog Item Report (Learning)Does anyone know how to fetch creation date using BIP? Please see screenshot below:Hazel De Castro 41 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom… Link to the offer in the personalized notificationSummary: Content (required): Good morning everyone, we are developing a package of custom notifications on rtf templates and excel attachments to be provided to a custom…
- 
             Report on Assessment in LearningSummary: Hi Reporting Experts, Is it possible to build a report on assessment for OLC in which we can determine who has changed assessment questions and date and time of…Saurabh Pratap Singh 52 views 2 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM Report on Assessment in LearningSummary: Hi Reporting Experts, Is it possible to build a report on assessment for OLC in which we can determine who has changed assessment questions and date and time of…Saurabh Pratap Singh 52 views 2 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM
- 
             Ability to track the number of times learner retook/reviewed an already completed learning itemSummary: Looking to create a report that gives the number of times a learner has reviewed or retaken an already completed learning item. Is this information recorded, an…KatHugh 41 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM Ability to track the number of times learner retook/reviewed an already completed learning itemSummary: Looking to create a report that gives the number of times a learner has reviewed or retaken an already completed learning item. Is this information recorded, an…KatHugh 41 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
- 
             Different Learning Metrics - Existing dashboard resource?Summary: Content (required): Hi there at the end of the year we need a number of learning reports. I have a few organised but I was wondering if there is any resource re…Bobby Jourdan 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Different Learning Metrics - Existing dashboard resource?Summary: Content (required): Hi there at the end of the year we need a number of learning reports. I have a few organised but I was wondering if there is any resource re…Bobby Jourdan 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             Calculated item for Actual Time spent in LearningSummary: Content (required): Hi there, the actual time spent for a learning item is measured in 0.5, 0.75, etc. We want to prepare a calculated item column in OTBI repor… Calculated item for Actual Time spent in LearningSummary: Content (required): Hi there, the actual time spent for a learning item is measured in 0.5, 0.75, etc. We want to prepare a calculated item column in OTBI repor…
- 
             BIP - Non-catalog item reportSummary: Hello, Have anyone tried creating a Non-catalog item report in Learning? Do you know where I can get these details below? (Column name, tables in BIP) Your help…Hazel De Castro 101 views 6 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM BIP - Non-catalog item reportSummary: Hello, Have anyone tried creating a Non-catalog item report in Learning? Do you know where I can get these details below? (Column name, tables in BIP) Your help…Hazel De Castro 101 views 6 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
- 
             Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S…Bobby Jourdan 61 views 9 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S…Bobby Jourdan 61 views 9 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM
- 
             How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Enter values for lexical referencesSummary: Content (required): Hello everybody, We are having issues using this query to extract information from the learning module. I suppose that the error is given by…Gerardo Peluso 26 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM Enter values for lexical referencesSummary: Content (required): Hello everybody, We are having issues using this query to extract information from the learning module. I suppose that the error is given by…Gerardo Peluso 26 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
- 
             Restrict results to appear only after a completion date - LearningSummary: Content (required): Hi there, we have a custom field on the course level that tracks specific credits given by a completion of a course. Let’s say Course A give…Bobby Jourdan 12 views 1 comment 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM Restrict results to appear only after a completion date - LearningSummary: Content (required): Hi there, we have a custom field on the course level that tracks specific credits given by a completion of a course. Let’s say Course A give…Bobby Jourdan 12 views 1 comment 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM
- 
             Can anyone assist with joining two tables in Learning? WLF_EVENT_ASSIGNMENTS_F and WLF_LEARNING_ITEMSummary: I am trying to join the course and the associated initiative information from the two base tables in Learning. Content (required): Joining the learning_item_num…Thulasi Ram 102 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM Can anyone assist with joining two tables in Learning? WLF_EVENT_ASSIGNMENTS_F and WLF_LEARNING_ITEMSummary: I am trying to join the course and the associated initiative information from the two base tables in Learning. Content (required): Joining the learning_item_num…Thulasi Ram 102 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             Learning Completion Summary Report Pivot TableSummary: Total shown in Learning Completion Summary Report Pivot Table Content (required): I have a requirement to do a learning completion summary report for people who…Ridma Karunanathan 51 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM Learning Completion Summary Report Pivot TableSummary: Total shown in Learning Completion Summary Report Pivot Table Content (required): I have a requirement to do a learning completion summary report for people who…Ridma Karunanathan 51 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
- 
             OTBI filter to compare two attributesHello, We're building an OTBI Analysis that compares, for each employee, the competency’s rating given by his/her line manager in a Performance Document and the minimum …gguittini 61 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM OTBI filter to compare two attributesHello, We're building an OTBI Analysis that compares, for each employee, the competency’s rating given by his/her line manager in a Performance Document and the minimum …gguittini 61 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
- 
             Can you please help me with SQL Query to fetch Assignment Rules at Course LevelSummary: Can you please help me with SQL Query to fetch Assignment Rules at Course Level Content (required): Can you please help me with SQL Query to fetch Assignment Ru… Can you please help me with SQL Query to fetch Assignment Rules at Course LevelSummary: Can you please help me with SQL Query to fetch Assignment Rules at Course Level Content (required): Can you please help me with SQL Query to fetch Assignment Ru…
- 
             Learn Overdue CountSummary: I am trying to pull a report for Learners having more than 5 or more training overdue. So I created one report to get the count and the other report to pull the…Anita 21 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM Learn Overdue CountSummary: I am trying to pull a report for Learners having more than 5 or more training overdue. So I created one report to get the count and the other report to pull the…Anita 21 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Ability to resize Dashboard on a pageSummary: Hi - my organization is currently working on implementing Oracle Learning and I was playing around with the Administrator Dashboard: The goal was to see if we c… Ability to resize Dashboard on a pageSummary: Hi - my organization is currently working on implementing Oracle Learning and I was playing around with the Administrator Dashboard: The goal was to see if we c…
- 
             Need a report to find Learning InitiativesHello Team, I am looking for a report to fetch the learning Initiatives data(Setup data). That would be great if anyone can help. Thanks, Minatiminati_behera-Oracle 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM Need a report to find Learning InitiativesHello Team, I am looking for a report to fetch the learning Initiatives data(Setup data). That would be great if anyone can help. Thanks, Minatiminati_behera-Oracle 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             Report that pulls performance evaluations on Goals and CompetenciesSummary: Hello, Our customer needs a report that pulls evaluations for each goal and competency included in performance documents. Unfortunately we're not finding the ri… Report that pulls performance evaluations on Goals and CompetenciesSummary: Hello, Our customer needs a report that pulls evaluations for each goal and competency included in performance documents. Unfortunately we're not finding the ri…
- 
             Query - Classroom at activity level in LearningSummary: Hello, does anyone have a query how to get the classroom at activity level in Learning? Thank you so much. Content (required): Version (include the version you …Hazel De Castro 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM Query - Classroom at activity level in LearningSummary: Hello, does anyone have a query how to get the classroom at activity level in Learning? Thank you so much. Content (required): Version (include the version you …Hazel De Castro 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …Thulasi Ram 72 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …Thulasi Ram 72 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Time to complete self-paced learningSummary: Is there a way to report on the time taken from launching a piece of self paces learning to the point it is finished? We have a lot of compliance offerings whic…Elizabeth Docherty 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM Time to complete self-paced learningSummary: Is there a way to report on the time taken from launching a piece of self paces learning to the point it is finished? We have a lot of compliance offerings whic…Elizabeth Docherty 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Learning Audit ReportSummary: Our client has a requirement to be able to audit on the following objects in Oracle Learning Cloud. currently oracle dont provide an out of the box solution to …Nirupa Gnanendran 132 views 2 comments 1 point Most recent by Nirupa Gnanendran Reporting and Analytics for HCM Learning Audit ReportSummary: Our client has a requirement to be able to audit on the following objects in Oracle Learning Cloud. currently oracle dont provide an out of the box solution to …Nirupa Gnanendran 132 views 2 comments 1 point Most recent by Nirupa Gnanendran Reporting and Analytics for HCM
- 
             How do you join WLF_ATTACHED_DOCUMENTS with other learn tables of coure? For example WLF_LEARNING_ITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Bhasha Desai 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM How do you join WLF_ATTACHED_DOCUMENTS with other learn tables of coure? For example WLF_LEARNING_ITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Bhasha Desai 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             Learning Initiative associated with a courseHello everyone, we would need to know if a course has an initiative attached to it and possibly the number of that initiative. However, among the documentation we could …User_2025-02-07-06-30-13-200 11 views 1 comment 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM Learning Initiative associated with a courseHello everyone, we would need to know if a course has an initiative attached to it and possibly the number of that initiative. However, among the documentation we could …User_2025-02-07-06-30-13-200 11 views 1 comment 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
- 
             Total sum of three custom calculated columns is not calculating data correctlySummary I am working on learning report where I need to sum three custom calculated columns to get the total completion of 3 set of courses. I am performing sum of all t…Kamini Kaushik-Oracle 21 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM Total sum of three custom calculated columns is not calculating data correctlySummary I am working on learning report where I need to sum three custom calculated columns to get the total completion of 3 set of courses. I am performing sum of all t…Kamini Kaushik-Oracle 21 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM