Category Archives: Oracle Apps

Steps to Create Alert in Oracle HRMS

By | September 1, 2016

In this post, you will find the steps to create the alerts in oracle hrms. By default when you install Vision instance, Only few application are licensed. You need to license the required products in order to use it. If you are working on vision instance, Please find the steps to enable alerts license mentioned… Read More »

Step By Step Guide to Create EIT in Oracle HRMS

By | March 31, 2016

Extra Information Types Oracle defines EIT in following words. Extra Information Types (EITs) is a descriptive flexfield that facilitates us to add an unlimited number of information types to six available important entities in Oracle HRMS. EITs do not appear automatically in any responsibility. You must set up responsibility-level access for EITs. Extra Information types… Read More »

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 »

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 »

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 »

2 Simple Steps to make a Responsibility Read Only in Oracle Apps.

By | October 31, 2014

How to make a Responsibility Read Only in Oracle Apps? Solution Concept: By setting the profile option HR:Query Only Mode at responsibility level, you can make a responsibility read only. Step by Step solution: Login with System Administrator responsibility and navigate to Profile-> System menu as shown below in the picture Form for profile option… Read More »

Enable Diagnostic Examine Option in Oracle Apps

By | October 26, 2014

Problem Statement: While working in oracle, you might want to know the detail through Diagnostic->Examine option, but when you try to open the examine form, you end up with following message. Function not available to this responsibility: Change responsibilities or contact your system  Following is the error screen.. Cause: This error comes because, you don’t have… Read More »