Special Information Types -SIT in HRMS
Written by Anil Passi   
Wednesday, 15 November 2006
In this article, I will explain in steps :- How to create special information types in Oracle HRMS.


Once you have learnt the fundamentals of SIT, you can then also reference the article on migrating special information types into Oracle.

Before we dive into the special information type creation example, let’s first do some questions and answers.

Question: What is so special about special information types?
Answer : Nothing is special about SIT !!, it happens to be a Key FlexField, effectively a combination of segment/field values get attached to a person/hr record. In plain English, SIT is a mechanism by which you can create new fields, to capture additional information against an HRMS record.

Question : Why use an SIT when we can enable descriptive flexfields against the person record.
Answer : Various reasons, as listed below:-
A. Data in Descriptive Flexfield against an employee record will be visible to all the users that have access to the Employee creation/query screen.
On the contrary, using HR Workflow security, we can make SIT to become visible for the responsibility that we desire.
B. There is limited number of descriptive flex field columns available.
C. SIT let you logically group similar information together. For example, you may wish to capture "Medical illness history/details" and also Citizenship/Country Residency History" of your employees. In this case, you will create two different SIT.

Question : So, can we create multiple Special Information Types?
Answer: Indeed, you can define as many contexts as you desire for special information type key Flexfield in Oracle Apps.

Question : What are the steps in brief for setting up an SIT
Answer:
Analysis of sit requirement, which includes
A. Find additional fields that are required for your HRMS screen, and can be logically grouped to be enterable from one window.
B. The validations that will be required against each of the SIT fields. Note: some people prefer to call them segments instead of fields.  Anyway, for these validations you will need to create value sets, or will have to find an existing value set that can be reused.

Implementation: of special information type
A. Configure the key Flexfield
B. Add segments to the key flex field
C. Assign value sets to segments. Skip this step if you want your key flexfled segment to be free text. Value sets are attached to each such segment that requires validation.
D. In HRMS Superuser responsibility , enable the key flexfield context in screen "Define special information type"


Question : Give me the example of the SIT, to which we will migrate values.
Answer : For this training exercise, we will assume following SIT exists in Oracle Apps.
Sit name : "XX Medical History Of Person"
Sit Fields:
 Medical Condition
 Year of illness  
 Cured Flag (Yes/No)


Question: Show me the steps visually, using screenshots...
Answer: As below

First, go to Key Flexfield register screen and query to find the title of KFF. No changes are done in this screen,
Image


Go to application developer responsibility, and click on menu key flexfield segment.
Image


Query on the title in key flexfields segment screen.
Image


Add a new context/structure to this flexfield.
The name of this context is "XX Medical History Of Person" in our example.
Image

Click on segments, to add segments/fields for this special information type.
Add the three segments as below
Image

Freeze the structure (structure ,means combination of these 3 segments)
Also, ensure the Dynamic Inserts are Checked(Turned On)
Image

In HRMS responsibility , go to define special information types and create an entry for the context.
Image

Now go to person record, by finding for the person that we migrated in earlier article .
Image

Click on button labeled special Info
See the SIT in action here, finally
Image

Comments (18)add
...
written by kirankumar , December 20, 2006
how can we enter into payroll first
...
written by Anil Passi , December 20, 2006
Hi Kiran,

Please explain your question a little.
Do you wish to make a career in Oracle Payroll?

Thanks,
Anil Passi
...
written by kirankumar , December 20, 2006
how can we enter into payroll first
...
written by Anil Passi , December 20, 2006
Hi Kiran,

Please explain your question a little.
Do you wish to make a career in Oracle Payroll?

Thanks,
Anil Passi
...
written by Anil Passi , February 21, 2007
Hi Abhishek

Yours is a very commonly asked question. Hence I have now written a dedicated article to answer your question. Please see link http://oracle.anilpassi.com/di...-hrms.html

Thanks,
Anil Passi
...
written by uma , March 01, 2007
Anil,

can u say steps to do compensation and benifits....
...
written by uma , March 01, 2007
Hi Anil,

Can u please say what is proration and retroactive? And the steps to do that?

regards
uma
...
written by Sanjay Singh , March 06, 2007
Hi Anil

First of all I would like to thank you for making things clear 2 me regarding Apps.
Anil I m working on Oracle Apps HRMS module and would be very thankful if you can introduce some documents related to Accrulas and their processing in HRMS. As i m not clear about the same.

Thanks in Advance
Sanjay Singh
...
written by Niraj , April 25, 2007
Hi Anil
Thanks for a really good article. Can you explain how using HR Workflow security, we can make SIT to become visible for the responsibility that we desire ?? This is one of the requirement that I need to address. Thanks in advance

Regards
Niraj
...
written by Shah Alam , April 26, 2007
Hi Anil,

Thanks for the article.

My requirement is to show SIT in Manager Self Service, so that Manager can update it for their direct reportee.

Can you please explain how can I acheive this.

Cheers
Shah
...
written by Anil Passi , April 26, 2007
If managers have different responsibility, then you can use manager level personalizations to hide/show flexfield structures or their segments.

Thanks,
Anil
...
written by Rahul , May 03, 2007
Hi Anil,

How do we map SIT to Responsibilities. Suppose I have a SIT called TEST_SIT and responsibilty TEST_RESP, now I want to do the setup so that TEST_SIT is visible to TEST_RESP only.

Thanks
Rahul
...
written by Anil Passi , May 04, 2007
See if this link answers your question
http://oracle.anilpassi.com/di...hrms.html

Do let me know.

Thanks,
Anil
...
written by Baji , June 25, 2007
Hi Anil,

i need some help on HRMS, regarding the PAY_COST_ALLOCATION_API, to Insert the data based on the dates and by changing the proportion based in the department change with in the organization.

This should keep track of the Employee Details with in the organization.

waiting for ur reply

Regards
Baji Sk
...
written by Gowri , August 30, 2007
Hi Anil,
Great website and very good articles.
I have a specific question on KFF. You have written that Oracle will store a ID(key) for the KFF instead of individual values of segments. I understand that peice, But I do not understand When and How ID's are generated. Is it done dynamically on the fly, or at the time of creation of KFF.
Also, Say a KFF has 3 segments with 1st segment having a valueset of say 2 distinct values, 2nd with 3 distinct values, and 3rd with 2 distinct values. In that case, would oracle generate 2x3x2=12 combinations with ID's. What if one of the segment has a valueset of 100 values, or even say if it is free-text..
Would Oracle create all combinations and ID's, at the time of KFF creation and store in some place, Or would it create them dynamically when the actual value is stored in the table.
Obviously 2nd approach is a preferred one, but just want to confirm the same from you.

Thanks,
Gowri
...
written by Anil Passi , September 01, 2007
Hi Gowri

Hi Gowri

The unique ID is generated from a sequence.
When you register a Key Flex Field in Application developer responsibility, at that time ayou specify the UNIQUE ID COLUMN for the KFF.

The most common example is accounting flexfield, which uses a sequence named gl_code_combinations_s.nextval to generate the code_combination_id

Thanks,
Anil Passi
...
written by Habeni , December 12, 2007
Hi Anil,

I will like to know how to configure OAB and CWB from start to finish especially when the start of implementations.

Thanks in advance
Mapping between People and SIT
written by Ash , December 20, 2007
Please let me know what is the mapping between speacial information with the employee.
You must be logged in to a comment. Please register if you do not have an account yet.

busy