How to create Special information type (SIT) in Oracle HRMS

What is an SIT??

SIT Stands for Special information type. When you want to save a particular type of data for which there is no interface provided by Oracle, you can create a SIT to store data.

Features:

1) SIT is a KFF (Key flex field)

2) You can store data in a date tracked manner.

3) It is used to cater frequent data change. e.g. You can use it to store training data whenever a training is conducted.

How to create an SIT??

Navigation: System Administrator --> Application --> Flexfield --> Key --> Segments

Search flexfield title by name Personal Analysis Flexfield, as shown below.

Unfreeze the key flexfield and add a new record under the Structures section as shown below.

Press the Segments button

Create the number of segments as desired and attach validation sets to each field accordingly as shown below

Save & Close. Don't forget to Freeze Flexfield Definition.

Now switch to Global HRMS Manager Responsibility.

Navigation: Global HRMS Manager --> Other Definitions --> Special Information Types

Select the special information types you want to use in your Business Group.

Enable each type by checking the Enabled check box.

Check the other boxes to specify how you plan to use the special information type. This makes it available in the list of values in other windows as follows:

ü  Job: in the Job Requirements window

ü  Position: in the Position Requirements window

ü  Other: in the Special Information window

ü  Skill: in the Skill Provisions and Search for Event windows in Oracle Training Administration

The OSHA and ADA check boxes are for US users only.

Refer to screenshot below for details

Lets check that either SIT has been successfully registered or not.

Navigation: Global HRMS Manager --> People --> Enter & Maintain 

Search for an employee and press "Special Info" button on People window.

Here is the Result

As you can see in screenshot above, XX_EXAMPLE_SIT is showing.

Drawback:

Per_analysis_criteria table contains the possible combinations of the data stored in a particular data.

Per_Person_Analyses contains the actual data.

Whenever a new record is updated, and in response to updation, a new combination is created. What will system do is, first it will create a combination in Personal_analysis_criteria table then it will insert actual data in Per_Person_Analyses . So a little bit of Performance issue. But in this era, we have machines with so much specs, so not a big issue..:)

How to create Extra information type (EIT) in Oracle HRMS

Kindly provide your feedback.

Leave a comment for any query.