9/23/2019 My Oracle World: How to create Extra information type (EIT) in Oracle HRMS
My Oracle World
This blog contains information about Oracle Core HR, Oracle Payroll, System Administration, Data Uploading, Functions and Troubleshooting in Oracle E-business Suite.
Home
How to create Extra information type (EIT) in
Oracle HRMS
TUESDAY, DECEMBER 11, 2012 10 comments
What is an EIT??
EIT is used to store some extra information about
Employee
Popular Posts
Assignments
Validation Type 'Table' in Value
Jobs
sets in Oracle
Positions
Locations
Previous Job
Using $FLEX$ in Value sets in
Contacts
Oracle
and some other as well.
How to get Net Entitlement of
Leaves in Oracle HRMS Payroll
Features:
EIT is a DFF. How to assign security profile to
a user in Oracle HRMS
EIT is used to store data, where same data is changed quite often.
How to create Special
EIT can be opened at Multiple levels, so very helpful in storing as detailed data as possible. information type (SIT) in Oracle
HRMS
How to create an EIT?? Using $PROFILES$ in Value
sets in Oracle
Navigation: System Administrator --> Application --> Flexfield --> Descriptive --> Segments
Search flexfield title by name Extra Person Information, as shown below. Retro Pay by Element in Oracle
HRMS Payroll
Proration formula in Oracle
HRMS Payroll
Retro Pay Setup in Oracle
HRMS Payroll
Taskflow Node Definitions in
Oracle HRMS
Total Pageviews
Unfreeze the key flexfield and add a new record under the Context Field Values section as shown below.
330,151
Powered by Blogger.
waqasora.blogspot.com/2012/12/how-to-create-extra-information-type.html 1/5
9/23/2019 My Oracle World: How to create Extra information type (EIT) in Oracle HRMS
Blog Archive
► 2013 (13)
▼ 2012 (98)
▼ December (23)
Retro Pay Setup in Oracle HRMS
Payroll
How to use profile value in report
integration in ...
Proration formula in Oracle HRMS
Payroll
How to create Extra information
type (EIT) in Orac...
Press the Segments button How to create Special information
type (SIT) in Or...
Create the number of segments as desired and attach validation sets to each field accordingly as shown below. Assignment Sets in Oracle HRMS
Payroll
How to get remaining months in a
fiscal year in Or...
How to get fiscal year end date in
Oracle HRMS Pay...
How to get fiscal year start date in
Oracle HRMS P...
Balances in Oracle HRMS Payroll
How to get number of years,
months, days between t...
APP-PAY-34024 You must enter a
Legal Employer for ...
How to Apply HRMS Legislation
Patch in Oracle
APP-PAY-6956 Element entry
overlaps with another e...
APP-07599 Supervisor is not valid
for the duration...
Save & Close. Don't forget to Freeze Flexfield Definition. ORA-06502: PL/SQL: numeric or
value error
Now switch to Global HRMS Manager Responsibility. ORA-01400: cannot insert NULL
into (string)
Now we need to run the concurrent Program named "Register Extra Information Types (EITs)"
How to integrate a report (RDF)
with Oracle Apps
Using $PROFILES$ in Value sets
in Oracle
Using $FLEX$ in Value sets in
Oracle
Validation type 'Translatable
Dependent' in Value ...
Validation type 'Translatable
Independent' in Valu...
Validation type 'Special' in Value
sets in Oracle
► November (75)
After the request is completed successfully, navigate to
Navigation: Global HRMS Manager --> Security --> Information Types Security
Search for your relevant responsibility, add the EIT under the selected responsibility as shown below.
waqasora.blogspot.com/2012/12/how-to-create-extra-information-type.html 2/5
9/23/2019 My Oracle World: How to create Extra information type (EIT) in Oracle HRMS
Let’s check that either SIT has been successfully registered or not.
Navigation: Global HRMS Manager --> People --> Enter & Maintain --> Others --> Extra Information
Query:
SELECT PEI_INFORMATION1 PASSPORT_NUMBER,
TO_DATE (SUBSTR (PEI_INFORMATION2, 1, INSTR (PEI_INFORMATION2, ' ') - 1),
'YYYY/MM/DD'
) PASSPORT_EXPIRY_DATE
FROM PER_PEOPLE_EXTRA_INFO
WHERE INFORMATION_TYPE = 'XX_EXAMPLE_EIT'
How to create Special Information Type (SIT) in Oracle HRMS
Kindly provide your feedback.
Leave a comment for any query.
10 comments:
surendar kesavan 17 September 2013 at 14:32
Thank you
Reply
inas elgohary 2 November 2013 at 15:47
This comment has been removed by the author.
waqasora.blogspot.com/2012/12/how-to-create-extra-information-type.html 3/5
9/23/2019 My Oracle World: How to create Extra information type (EIT) in Oracle HRMS
Reply
inas elgohary 2 November 2013 at 15:50
Thanks it helped a lot , but you have to put a prefix of the legislation instead of xx in the second screen
i.e , EG_EXAMPLE_EIT (for Egypt for example)
PA_EXAMPLE_EIT (for Pakistan for example)
Reply
Hussain Jaff 20 February 2014 at 10:48
Thanks
Reply
Perumal T 25 May 2015 at 16:42
Thank you for sharing this useful information and it is very effective for the people who are all looking to get
the details on Human Resource Management System..
Reply
shruti Rajput 12 February 2016 at 16:04
can you tell me why we are using SUBSTR (PEI_INFORMATION2, 1, INSTR (PEI_INFORMATION2
Reply
My Oracle Share Point 25 November 2016 at 22:15
Thanks, it was a soft landing paper.
Reply
Sridevi K 16 February 2017 at 11:10
Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL,
D2K at training@oracleappstechnical.com | +91 - 9581017828.
Reply
Passion 4 Oracle 22 June 2018 at 23:39
good and comprehensive article. helpful for oracle consultant
Reply
rajeev 11 August 2019 at 12:18
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check
https://www.oracleappstechnical.com
Reply
Enter your comment...
Comment as: msi.dhaka@gm Sign out
Publish Preview Notify me
Newer Post Home Older Post
waqasora.blogspot.com/2012/12/how-to-create-extra-information-type.html 4/5
9/23/2019 My Oracle World: How to create Extra information type (EIT) in Oracle HRMS
waqasora.blogspot.com/2012/12/how-to-create-extra-information-type.html 5/5
