Category Archives: OTA Tables

Create Class API for OLM

By | January 7, 2015

This article of Oracle HRMS Overview is related to creation of Class API in OLM (Oracle Learning Management.) In previous article, I showed how to use Courses Creation API. Create Class Update Class Delete Class Create Class API – ota_event_api.create_class Notes for Using this API Your Course and Offering should be valid for the dates… Read More »

Question of the Day

By | January 1, 2015

Today’s Question is for Oracle HRMS Consultants. It is related to OLM. “Question of the Day” is an opportunity for Apps beginners and seasoned professionals to evaluate their knowledge by answering a question. On daily basis, we shall post one question for either Oracle Apps technical or Oracle HRMS (Human Resource Management System) Functional areas. Its very… Read More »

Oracle Learning Management – OLM Tables

By | December 16, 2014

Summary of Article Introduction Big List of OTA Tables ER Diagram Sample Catalog Objects Hierarchy Explanation with Sample Data Links SQL Queries for Catalog Objects SQL Queries for External Learning Download PDF Version of this Article Oracle Learning Management – OLM Tables In Oracle HRMS Overview Series of Articles, This is the first to one… Read More »

Course Delete API in OLM (ota_activity_version_api)

By | November 19, 2014

Course Delete API in OLM (ota_activity_version_api) Purpose of this API is to delete the courses in OLM as Course Cataoge Objects. First API removes the inclusion of a course in one or more categories and then its removes this course. declare l_activity_version_id number; l_act_vers_usages_del_flag number:= 1; –Get all courses that are to be deleted cursor c1… Read More »