Skip Headers

Oracle E-Business Suite Extensions for Oracle Endeca Integration and System Administration Guide
Release 12.1 V5
Part Number E37993-08
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Oracle Learning Management Extensions for Oracle Endeca

This chapter covers the following topics:

Overview

You can use Oracle Learning Management for Oracle Endeca to add filters to browse and search for new training in the Course Catalog.

You can search using Oracle Learning Management Extensions pages and Endeca Information Discovery (EID) design tools. These pages are hosted in an EID environment, and called from new container pages in EBS.

Oracle Learning Management Extensions for Oracle Endeca User Interface and Integration

Course Catalog Page

The Course Catalog page enables learners to search for Learning Management data using various filtering options. The page displays information and data graphically and in tabular format. The results you can view are based on the keywords you entered in the Learner Home page.

the picture is described in the document text

Region Components
Learning This consists of the following tabs:
  • Courses

    • Course

    • Class

    • Category

    • Delivery Mode

    • Class Start Date

    • Location

    • Language

  • Certifications

    • Certification

    • Category

    • Complete In

    • Valid For

  • Learning Paths

    • Learning Path

    • Category

    • Completion Target

  • Chats

    • Chat

    • Category

    • Start Date

    • Start Time

  • Forums

    • Forum

    • Category

    • Start Date


You can also print all these details.

Oracle Learning Management Extensions for Oracle Endeca Product Configuration

Oracle Learning Management Extensions for Oracle Endeca Product Configuration

Once you have completed installation and common configurations as described in Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1), you must complete the Oracle Learning Management Extensions for Oracle Endeca product configuration setup as detailed in this section.

Setting Up Oracle Learning Management Extensions for Oracle Endeca Product Configuration

To set up Oracle Learning Management Extensions for Oracle Endeca Product Configuration, complete the following steps:

  1. Add the Learner Endeca Catalog Search (OTA_LRNR_ENDECA_ACCESS_ROLE) role to any predefined or custom Learning Self-Service responsibility.

    See: Oracle E-Business Suite System Administrator's Guide - Security for more information on how to assign roles.

    See: Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1) for more information on roles in Oracle E-Business Suite Extensions for Oracle Endeca.

  2. Run the Full Load Configuration Graph.

    See: Running the Full Load Configuration Graph

  3. Schedule the set up for Incremental Endeca Refresh.

    See: Setting Up the Scheduler to Load Incremental Graphs

Loading Oracle Learning Management Extensions Data into the Endeca Data Store

Clover ETL within Endeca queries Oracle Learning Management Extensions Views and does a full data load to the ota-objects data store in Endeca. After the first data load, full data load or incremental data load can be performed periodically. Incremental data load will update all the records in Endeca Learning Management Extensions data store which were updated in EBS after the last load. After the data has been loaded in the Oracle Learning Management Extensions data store, it can be queried and shown in the Oracle Learning Management Extensions pages.

Oracle Learning Management Extensions Data Sources

The following data sources are defined in the Learning Management Extensions data store in Endeca and are used to query data in different tabs in Learning Management Extensions. These data sources include:

Running the Full Load Configuration Graph

Once you have run the full load graph in accordance with the Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1), attribute configuration is loaded for all seeded attributes. Additionally, you need to run the following full data loads as follows:

To run the Full Load Configuration Graph

  1. Login to Integrator server using your Clover login.

  2. Click the Scheduling tab.

  3. Select the New Schedule link.

  4. Enter a Description for the scheduler, for example, Learning Management Full Load Scheduler.

  5. Select Periodic as the Type.

  6. Select by interval as the Periodicity.

  7. Enter a start date and time in the Not active before date/time field.

  8. Enter an end date and time in the Not active after date/time field.

  9. Enter a value in the Interval (minutes) field.

  10. Ensure you select the Fire misfired event as soon as possible check box.

  11. Select Execute graph from the Task Type list.

  12. Select ota-objects from the Sandbox list.

  13. Select graph/FullLoadConfig.grf from the Graph list.

  14. Click Create to set the scheduler.

Setting Up the Scheduler to Load Incremental Graphs

Once the Full graph is run in accordance with the Installing Oracle E-Business Suite Extensions for Oracle Endeca, Release 12.1 V5 document (Doc ID: 1683053.1), initial data load for Learning Management is complete. For incremental refresh, you must determine how often the Endeca data should be refreshed from EBS depending upon your organizational requirements. Oracle recommends that you keep this near real time. As the data is updated in the EBS, you need to ensure it is updated in the endeca MDEX server. You set up the Scheduler to load incremental graphs depending on the volume of information requiring update.

To set up the scheduler

  1. Login to Integrator server using your Clover login.

  2. Click the Scheduling tab.

  3. Select the New Schedule link.

  4. Enter a Description for the scheduler, for example, Learning Management Incremental Load Scheduler.

  5. Select Periodic as the Type.

  6. Select by interval as the Periodicity.

  7. Enter a start date and time in the Not active before date/time field.

  8. Enter an end date and time in the Not active after date/time field.

  9. Enter a value in the Interval (minutes) field.

  10. Ensure you select the Fire misfired event as soon as possible check box.

  11. Select Start a graph from the Task Type list.

  12. Select ota-objects from the Sandbox list.

  13. Select graph/IncrementalLoadConfig.grf from the Graph list.

  14. Click Create to set the scheduler.

Technical Integration Components

Roles in Oracle Learning Management Extensions for Oracle Endeca

Grants in Oracle Learning Management Extensions for Oracle Endeca

Views and Joins to Load Oracle Learning Management Extensions for Oracle Endeca Job Search

The following views are used by the ETL layer in Oracle Endeca to load and display Oracle Learning Management Extensions for Oracle Endeca data to the Oracle Endeca data store:

Menus and Functions in Oracle Learning Management Extensions for Oracle Endeca

The following functions are available for the Learner Application Menu (OTA_LEARNER_APPLICATION_MENU) in Oracle Learning Management Extensions for Oracle Endeca:

Function Code User Function Name Function Type Web HTML Call
OTA_EID_OBJ_SEARCH OTA Endeca Catalog Search JSP GWY.jsp?targetAppType=Endeca&targetPage=web/ota/ota-eid-obj-search