Category Archives: HRMS Questions

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 »

How to Enable Oracle Alerts License on Vision Instance

By | August 21, 2016

This article is written for those who are working on their vision instance and want to use the alert functionality first time on vision instance. By default when you install Vision instance, Only few application are licensed. You need to license the required products in order to use it. It is very easy to license… Read More »

Great Opportunity For Oracle Apps Beginners

By | May 13, 2015

Problems faced by Beginners and its Solution This is my second article written specifically for Oracle Apps beginners. In my first article 9 Steps to become Oracle apps Consultant, I had shared the techniques that should be followed in order to make target oriented  efforts to become Oracle Apps Consultant. In this article, I shall… Read More »

Create/ Update / Delete EIT through API (HR_PERSON_EXTRA_INFO_API)

By | April 20, 2015

In this article of Oracle HRMS Overview, i shall cover API for creating, updating and deleting Person EIT (Extra Information Type for an employee). In order to read about Extra Information Types (EITs) in Oracle HRMS Read following Step by Step Guide to Learn EITs. Create EIT API HR_PERSON_EXTRA_INFO_API.CREATE_PERSON_EXTRA_INFO (Create EIT API Sample Code) Update… Read More »

Oracle Payroll Process Locking Concepts

By | April 1, 2015

In previous article of Oracle HRMS Overview series, i had explained the oracle payroll processes and their relevant tables along with impact of each payroll process on tables. In this article, i am sharing the locking concepts for payroll processes. This article can be used by both Oracle Functional and Technical Consultants as locking is… Read More »

Core HR SQL Queries

By | February 24, 2015

Organization through Organization Hierarchy Find the Parent Organization of a Particular Type through Organization Hierarchy on the basis of any organization. For Example I need the Branch Name on the basis of any organization (Department, Sub Department or Section under it. Download Org Hierachy Query Find Organization Manager Query There is one screen which hold… Read More »

Free Oracle Self Service (SSHR) Online Test

By | February 22, 2015

You need to login to view this content. Please Login. Not a Member? Join Us

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 »