January 31, 2017

Oracle HRMS Extra Information Types

bishnupc / /

HRMS Extra Information Types(EIT)

Extra Information Types allow users to hold unlimited amounts of extra information on people, assignments, locations, positions, jobs and organizations.
The format of this data is defined by the user in descriptive flexfield structures and accessed via Extra Information forms that can be added to taskflows and menus.

Defining an Extra Information Type

You define EITs in the relevant descriptive flexfield. 
These are
Extra Assignment Info. Details
Extra Assignment Information
Extra Contact Info Details
Extra Job Info Details
Extra Job Information
Extra Location Info Details
Extra Location Information
Extra Person Information
Extra Previous Job Details
Extra Contact Information
Extra Document Info Details
Extra Document Information
Extra Position Information
Extra Previous Job Information
Extra Person Info. Details
Extra Position Info Details

Developer define the Context Reference Field on these flexfields is seeded with the value INFORMATION_TYPE. 

You create a new context value for each EIT you require.
Then create segments to hold the information you want to record, as you would for any other descriptive flexfield.
Then freeze the flexfield structure.

Registering an Extra Information Type

Each Extra Information Type needs to be registered in the relevant EIT table (example, PER_PEOPLE_INFO_TYPES for Person EITs).
This is done by running the concurrent process 'Register Extra Information Types (EITs)'.
The Parameter 'Table Name' uses a LOV which, as well as the table name, displays the EIT name associated with that table. After selecting the Table Name, you select the 'Information Type' which is the name of the dff context you created for this new EIT. Enter values for 'Multiple Rows' ('Yes' if more than one set of values can be entered for this EIT); 'Legislation Code'; and 'Description'.
If the new EIT is an Organization EIT then you can also restrict it to a single classification using the 'Organization Classification' parameter. It will then be available from the 'Others' button only for the relevant classifications.

Restricting Access to Extra Information Types

To allow a responsibility to access an EIT, you need to navigate to the Information Type Security form in HRMS
Security->Extra Information Security. 

Highlight the responsibility that should have access to the EIT and then pick in the EIT name in the Information Types zone.
Organization EITs are not visible in the Information Type Security form 
Security->Extra Information Security.
They are automatically accessible from the Others button in the Define Organization screen
Work Structures->Organization->Description for the relevant classification when the Register Extra Information Types (EITs) process is complete.

Adding Extra Information Types forms to a Taskflow

Task flow nodes for all EIT forms are seeded, but not included in any seeded task flows.
So you will need to either update an existing taskflow or create a new one in order to access the EIT forms.
Use the Define Task Flows screen  to create or update your task flow.
Navigate->Security->Task Flow->Definitions

Adding EIT forms to a Menu

It is necessary to create a function for a new task flow before it can be added to a menu.
In System Administrator 
Enter a function name and a user function name then enter the following parameter: WORKFLOW_NAME=""
Go to the Define Menu screen 
Query the menu that you wish to change. The value that you pick in the Function field will be what was entered as the User Function Name in the Define Function form.
There is also a seeded function for each EIT form that could be added to a menu.


Lets Take the example of Location form.
There is option for maintaining Extra Information for a location

Table & API Information

New contexts for the EIT descriptive flexfields are held in FND_DESCR_FLEX_CONTEXTS, and the segments are held in FND_DESCR_FLEX_COL_USAGE as with any other descriptive flexfield.

An EIT is registered by inserting a row into the relevant EIT table. The information here includes the EIT name, legislation code and whether the EIT allows single or multiple entry.
The EIT tables are:


For Organization EITs it is also necessary to link the EIT with an organization classification. This link is held in HR_ORG_INFO_TYPES_BY_CLASS.

PER_INFO_TYPE_SECURITY is used to hold the EITs that a responsibility may access (excluding organization EITs). This information is entered in the Information Type Security form 
Security->Extra Information Security.

The location of the data entered into EITs depends on the EIT type (eg Person EIT, Org EIT, etc).

The tables holding this data are:


There are a number of APIs which allow you to create, update and delete EIT information:




Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here