Author Archives: Syed Farhan Ashraf

About Syed Farhan Ashraf

This site is for sharing knowledge of Oracle HRMS. It mainly focuses on stuff for oracle apps starters and gives them a step by step guideline.

Rollback a Self Service Transaction through API (hr_transaction_api.rollback_transaction)

By | June 27, 2015

In this article of Oracle HRMS Overview, I am going to share API to rollback a self service transaction. This will purge the data from self service transaction main tables and its relevant PQH history tables. This API is used normally when any transaction gets hanged due to session hang or any workflow error and… Read More »

Steps to Create Dependent Value Set in Oracle Apps

By | June 18, 2015

In this article of Oracle HRMS Overview, i am going to show the steps to create dependent value set. In this example i have used value sets with validation type of Table. There are different type of validation types that can be used as per the requirement basis. In Example, we are going to first… Read More »

Example of Using Profile Values in Value Sets

By | May 21, 2015

In my previous article i shared the steps to use profile values in Forms Personalization. In this article of Oracle HRMS Overview, i shall share the steps for using profile values in value sets. Syntax to Use Profile Values in Value Sets Following Diagram shows the syntax to use the profiles values within the value… 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 »

Oracle Apps Interview Questions

By | May 4, 2015

Introduction Find 100 + Oracle Apps interview questions. Earlier i had published the questions available in form of parts approachable on different pages but as i have received several emails where learners has provided the feedback to put all oracle apps questions in one page, It will be easy for reading and searching the relevant… Read More »

Learning Path and Learning Certification in OLM

By | April 30, 2015

In previous article of Oracle HRMS Overview series, i had talked about catalog objects at high level. In this article we shall discuss in details about Learning Path, Learning Certification, Forums and Chats and Web Conferences. If you are not familiar with OLM catalog objects, you can make yourself familiarize from following articles. OLM Overview… 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 Apps Trainers Pool – Individuals

By | April 13, 2015

Recommended Individual Trainers This page of Oracle HRMS Overview is dedicated to all those who are interested in Oracle Apps Training either technical or functional. It does matter even if these individuals are maintaining their individual blogs or website. This will be an additional source of free advertisement for them. Concept behind this motive is… 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 »