Category Archives: Apps Technical

Disable Self Service Personalization

By | February 2, 2015

Issue Description Is there any way we could ignore all self service personalization. We want to test a scenario where we want that system should work as per standard options and effect of all personalization should be ignored? Solution Login to System Admin Responsibility and click on system function following the navigation mentioned in figure… Read More »

10 Simple steps to implement XML Bursting Guide

By | February 1, 2015

In this Article, We shall cover following steps to understand and implement XML Bursting feature in Oracle Apps 1. Create RDF Report 2. Register Executable 3. Register Concurrent Program 4. Create XML bursting control file 5. Register data definition 6. Create RTF template File 7. Upload RTF file to data template 8. Place RTF File… Read More »

Useful Apps Technical SQL Queries

By | January 20, 2015

Summary Following is the list of SQL Queries that i have mentioned on this post. These are requirement that we often come across while we are on some support or implementation project. Therefore i decided to compile them in one place in ready to use format. Flashback Query to get old state of Data Get… Read More »

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 »

API to Create External Learning – OTA_NHS_API

By | December 14, 2014

Background of External Learning Create API In previous article we covered to create the courses through API and in this article we shall cover external learning for an employee. In OLM when an employees attends a course or training from outside of the organization, it is called external learning. We can use following API to… Read More »

Data Types for Constants and Variables in Oracle HRMS Fast Formula

By | December 1, 2014

Constants There are three types of constants that can be used in fast formula • numeric • text • date Numeric Constants Do not use commas or spaces in a number. So, for example, you cannot use 10,000 or 10 000.00 numeric constants. Examples of valid numeric constants are: • 83 • 6.55 • -7.3… 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 »

API to Create Course in OLM (ota_activity_category_api)

By | November 19, 2014

API to Upload Courses as Cataloge Objects in OLM ota_activity_version_api Purpose of this API is to create the master list of courses in OLM as Course Calaoge Objects. First API Creates Course and API called below includes it under a category.   declare errbuf VARCHAR2(200); retcode VARCHAR2(200); p_business_group_id NUMBER:= 83; p_validate VARCHAR2(10):= ‘FALSE’; l_activity_version_id NUMBER;… Read More »