BI Publisher
Discussion List
-
BI query returning learner activity score returns blank after Redwood implementationSummary: We have implemented Redwood 24D release this month. A query that was initially returning scores of employees is now returning blank data Content (please ensure … -
Impact of overriding OBSOLETE with ERROR status in WLF_LEARNING_EVENTSummary: Impact of overriding OBSOLETE with ERROR status in WLF_LEARNING_EVENT Content (please ensure you mask any confidential information): Hi Team, Greetings! We have… -
Selection Methods in Learning InitiativesSummary: Need SQL Query to extract Selection Methods in Learning Initiatives When you edit an initiative, there's an option Selection Methods in the step 2
-
learning initiatives querySummary: When you edit an initiative, there's an option to use an Analysis in the step 2 Select Learners. Is there a way to pull all the courses, initiatives and the cor…
-
Oracle Learning Cloud Bulk Processingwe need to have details about the ESS Oracle Learning Cloud Bulk Processing, which has been running in production. Is it possible to get these details via query? Do you …
-
Can we hide or disable the Hourly/Minute frequency while schedule BIP Reports?Summary: Can we hide or disable the Hourly/Minute frequency while schedule BIP Reports? We have identified users that have used the scheduling option to have reports run…
-
How to get items list along with Inventory organization associationSummary: How to get items list along with Inventory organization association Content (please ensure you mask any confidential information): We need list of items along w…
-
Past Attempt Details of LearnersIssue: We would like to view the learner's past attempts for specific courses through BIP. Description: We encountered an issue where a learner completes a course or off…Mohammed Waseem Akram S 43 views 2 comments 0 points Most recent by Mohammed Waseem Akram S Learning
-
Need to capture individual feedback responses of multiple instructors in one offeringSummary Need to capture individual feedback responses of multiple instructors in one offering for the instructors dashboardContent Need a solution for a below usecase in…
-
Need table where Learning Outcome Details are storedSummary Need table where Learning Outcome Details are storedContent Hi, I am trying to find out the table where Learning Outcomes are stored but could not succeed. Can y… -
How to create an OTBI report to pull information on learning assignment deleted date?Summary: How to create an OTBI report ( or what are the subject areas ) that helps to pull information regarding learning assignment deleted date? As part of 24 C New fe…
-
Tables to fetch activity evaluation detailsHi Team, I am trying to fetch activity evaluation details in BIP report , please let me know which table I should be looking into. Navigation: Learning > Courses > Offer…
-
Unique Learner Record - Learning Records Real TimeSummary: I am needing to produce results that provide a unique set of learner records for each training title in the analysis. I need the formula to produce the record t… -
SQL to retrieve all learner records with community and course taken detailsHi, How to generate a report with all learner learning records along with their course taken details and the associated Category Community and Topic Community? I am unab…
-
How to Fetch Data from SCORM Assessments in Oracle Fusion HCMHi, I am working on a report in Oracle Fusion HCM where I need to fetch data related to SCORM assessments. Specifically, I want to retrieve information such as patterns … -
Need an SQL Query to get the questions in learning module evaluation section shown in image?Navigation in user login:- Me→ Learning→ select any completed course→in default section select evaluation and click on review attempt We can see the questions in above n…
-
Extract Completion Type of Learning Evaluation activity in an offeringSummary: We're trying to report on the COMPLETION_TYPE (Required or Optional) of all activities in an offering. We've made use of WLF_LI_ACTIVITIES_F table to query the …
-
How to generate .ics file using BIP report?Summary: We are trying to generate an ics file and want to send it to the learner's email for their assigned activity Content (required): Version (include the version yo…
-
How to add ICS file in custom alert/notification?Summary: How to add an ICS file in a custom alert/notification? We have created a BI Publisher report for customized notifications in which we are using RTF templates. C…
-
Report to extract all Dynamic Group/Analysis Criteria and the filters applied to it.Summary: We have Dynamic Group/Analysis Criteria created in Oracle Learning. Is there a report we can use to extract all Dynamic Group/Analysis Criteria and the filters …
-
IP address when an employee completes a courseSummary: Please let us know if there is a way to capture the IP address when an employee completes a course or any where in table the IP address is captured when employe…
-
Report to extract initiatives associated to Learning ItemsHello all, We're trying to create a report which should extract for each learning item (specialization, course, offer etc) the initiative(s) created and its status (acti…
-
sql to get learner pass fail status along with course completionHello, Does any one know which table stores the Learner course completion status (complete/not complete) along with pass/fail status? @Sricharan Monigari @MandeepGupta @… -
1Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Descriptive flexfield WLF_LEARNING_REQUEST_DFFHi to all, We have created descriptive flexfield fields on the WLF_LEARNING_REQUEST_DFF code, in which BI table are they contained? Thank You Claudio
-
Table name to join course with competency/skill/certification details direclySummary: Hi Team, I have one requirement where we need to fetch course wise skill/competency/certification details. Please help to apply direct join to the skill/compete…
-
Alert statistics and execution details ReportHi, We've a requirement to list how the OLC alerts are executed everyday and how many associates are getting notifications etc. Can you please suggest if it can be achie… -
How to remove the 'price' field from the overview of the course details?Hi everyone, I need to remove the 'price' field from the overview of the course details because the employee should not be able to see it (see the attachment). It is pos… -
Report course. where we receive reports without information about who made them?Summary: Content (please ensure you mask any confidential information): regarding the reporting functionality in courses, where we receive reports without information ab… -
How to add SQL query in where statement for creating parameters and the list of valuesSummary: Hi I need to create parameter for country can anyone help me how to write the line in where statement and list of values , Select PAPF.PERSON_NUMBER, per_extrac…