Learning
Discussion List
-
How can I get only the latest results when reporting on the status of a certain training?Summary: I try to report on the status of a certain required learning to see who has not completed it yet. If the learning was deployed this year, but also the year befo…Cora_Stanciu 31 views 3 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM -
Total Actual Effort in Learning by DepartmentSummary: I am trying to write an OTBI analysis where we are able to pull in the total headcount of a department, the total actual effort hours of learning for that depar…KatieH 93 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Infolet Report Failing / Erroring with Direct and Indirect Reporting LineHi all, I'm hoping someone can tell me if what I'm trying to achieve here is possible. The report itself should look at anyone who has learning that's due and then apply…
-
Remove additional links from the Certificate of completionSummary: When viewing a certificate of completion, does OTBI provide flexibility to Remove the following links: · Edit · Refresh · Export · Add to Briefing Book · Email …
-
Report on Learning Alerts Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas or BI tables that can be used to report on the learn notifications that are sent out using the Alert Comp…Mahesh_M123 162 views 4 comments 0 points Most recent by Swaraj_Sudhagonela Reporting and Analytics for HCM
-
Find courses not completed in a specialization - Activity SequencingSummary: Hi, I have reviewed the article which mentions this OTBI report for specialisation. This works for us in the PROD instance where we have not enabled Activity Se…Sathesh Ramaswamy 65 views 2 comments 0 points Most recent by Sathesh Ramaswamy Reporting and Analytics for HCM
-
How can I get mass results for Responses in Assessment?Summary: We assigned our organization (~7,200) a video to watch and asked everyone to answer a feedback question. All that was fine except now I am trying to report on a…Aaron Reynolds 31 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Degree Reporting - Item Code not available in Subject AreaSummary: Hello there, I'm trying to create a simple analysis that provides a full list of Degrees and the Item Code. There doesn't seem to be a "Item Code" option to sel…
-
Report on Training Hours for each learnerSummary: Hi all, We are trying to report on each learner's hours during one year - has anybody been successful in building this in OTBI? Thank you in advance for your re…Cora_Stanciu 31 views 3 comments 0 points Most recent by Emily Robinson 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 62 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 -
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 -
How to get Consolidated output using Bursting data modelSummary: Hi Team, I'm creating a custom email notification for overdue learning in the learning module. For that, I have built a SQL query with bursting. When I schedule…Dasari Dileep 151 views 3 comments 0 points Most recent by Bhaskar Konar 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
-
Course Completion ReportSummary: Looking for something similar to what we see in the Learners section of a course/transcript. I'm able to build off of completed activities, but when an offering…Jessica D 61 views 2 comments 0 points Most recent by Abdul Rauf Mohammad-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
-
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 51 views 2 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM -
How to calculate Learning Assignment Creation Date + 7 Days in OTBISummary: First, I apologize, as I am not a reporting guru like you all so this question may seem rudimentary! I am the main administrator for our HCM Learning app. I oft…Angie Elliott 31 views 3 comments 0 points Most recent by Bhaskar Konar 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
-
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 103 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
-
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 21 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 11 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… -
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