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 can be created for following

1. Person Extra Information Type
2. Assignment Extra Information Type
3. Organization Extra Information type
4. Location Extra Information type
5. Job Extra Information Type
6. Position Extra Information Type

For example, as per your organization specific need , you want to store some additional information for your employees or your might want to use the EIT on Assignment to hold information about some project work within an assignment.

Note: Link for eBook for this article is available at the end of this post. If you wish to go to end of this post, Click Here.

Steps to Implement EIT at Person Level

Following are the steps for implementing Person Extra Information Type at Person Level

1. Create EIT Structure
2. Register EIT
3. Add EIT to Responsibility
4. Data Entry in EIT

1. Create EIT Structure

Go to Application Developer Responsibility

Oracle HRMS EIT 1

Go to following Navigation

Oracle HRMS EIT 2

Following screen will open

Oracle HRMS EIT 3

Search for Extra Person Information

Oracle HRMS EIT 4

Following Result will show

Orache HRMS EIT 5

Unfreeze the check box ‘Unfreeze Flexfield Definition’
Following message will appear

Orache HRMS EIT 6

Click OK and Click on New button in the toolbar

Orache HRMS EIT 7

screen will look like this

Orache HRMS EIT 8

Add the EIT Information as show below

Orache HRMS EIT 9

Click on Segments and enter the data as shown below

Orache HRMS EIT 10

Save the information

Orache HRMS EIT 11

Check the ‘Freeze Flexfield Definition’ check box. Following message will appear

Orache HRMS EIT 12

Back to top

2. Register EIT by Submitting Concurrent Program 

Now switch to responsibility ‘AE HRMS Manager’. This is the responsibility to which we want to attach this EIT.  In your instance, you can select resposnibility as per your organization. Mostly it should be a responsibility used by HRMS Manager.

Select the responsibility, Go to View and Submit Program

Orache HRMS EIT 13

Select the Single Request radio button

Orache HRMS EIT 14

Search for concurrent program ‘Register Extra Information Type’

Orache HRMS EIT 15

Enter the Parameters as mentioned below.

Orache HRMS EIT 16

Click OK to submit the concurrent program. Once it gets completed

Orache HRMS EIT 17


Back to top

3. Add EIT to Responsibility


In AE HRMS Responsibility, Click on following navigation
Orache HRMS EIT 18

Select the responsibility

Orache HRMS EIT 19

Add the newly created EIT

Orache HRMS EIT 20

Back to top

4. Data Entry in Newly Created EIT

In AE HRMS Responsibility, Go to following navigation

Orache HRMS EIT 21

Open the employee number 3

Orache HRMS EIT 22

click on Others button and select the Extra information Type option

It will show Passport Extra Information Type (EIT)

Orache HRMS EIT 24

Click on Details to open the field and enter the data
Orache HRMS EIT 25

and click OK and Save the Record
Orache HRMS EIT 26

Back to top

Tables and Query

Following are tables that contain information for Extra Informations

Sample Query to Get Person Extra Information

select ppei.*
from per_all_people_f ppf,per_people_extra_info ppei
where ppf.person_id = ppei.person_id
and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Back to top

Find eBook and MD50 and MD70 documents for same Article

For facilitation of users,  eBook for this article is available at scribid. Simply click any of the link to get the desired document.

eBook for this Article, MD 50 for this Article, MD 70 for this Article 

For Creation / Updation and Deletion of Data in Person Extra Information through API, read this article.

If you have liked contents in this post and you think it can be helpful to others, please share it at least once in your circle, in this way, you will join me in my cause to Learn Share and Grow. Come on, Lets Grow Together.

Related Article

API to Create / Update / Delete EIT
Payroll Processes and Relevant Tables
Payroll Mistakes Correction Methodology
Element Termination Rules
Get Free Evaluation of your HRMS Skills
9 Proven Steps to become Oracle Apps Consultant
XML Bursting Feature and its Solution files