Category Archives: Oracle

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 »

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 »

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 »

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 »

Oracle HRMS Fast Formula Overview

By | November 22, 2014

In this article of oracle hrms overview, We have provided the concepts of oracle hrms fast formula and its syntax. Working example and code is also given for your ready reference. Summary of Contents Oracle Fast Formula Overview Uses of Oracle Fast Formula In Payroll In Compensation and Benefits In People Management Oracle Fast Formula… Read More »

Oracle Apps Technical Interview Questions – Part 7

By | September 27, 2014

Following is List of articles for Oracle Apps Technical Questions Apps Technical Questions Part 1| Part 2 | Part 3 | Part 4 Part 5 |Part 6 | Part 7| Part 8 Alternatively, Go through the following Top 10 Oracle Apps Technical Questions List of Oracle Apps Technical Interview Questions – Part 7 1. Which… Read More »

How to debug long stored procedures and how to create backend logging mechanism?

By | September 25, 2014

Requirement Statement: Debug/ Investigation relevant Need While working in Oracle backend, there are times when you are debugging your long package procedures or functions and you want to see the values being generated in different variables at runtime. What is the best way to get these values at run time? Logging Related Need: Sometimes you… Read More »