Saturday Oct 12, 2013

Sick and Vacation Accrual

Here I am sharing useful code to find out Sick and Vacation net entitlement. User of this script should feed  following input to attached script.

  • Assignment Id
  • Period End Date
  • Business Group Id

Wednesday Mar 06, 2013

Bills of Materials (BOM)

Click here for BOM structure report.

Click here for the script to find out top level BOM component for any given child.

Saturday Oct 13, 2012

Date Tracking in Oracle HRMS

Update Date Track Modes

To maintain employee data effectively Oracle HCM is using a mechanism called date tracking.The main motive behind the date track mode is to maintain past,present and future data effectively.
The various update date track modes are:

CORRECTION : Over writes the data. No history will maintain.
UPDATE : Keeps the history and new change will effect as of effective date
UPDATE_CHANGE_INSERT : Inserts the record and preserves the future
UPDATE_OVERRIDE : Inserts the record and overrides the future

Action: Created Employee # 22 on 01-JAN-2012

The record in PER_ALL_PEOPLE_F is as shown below.

Effective Start Date

Effective End Date

Employee Number

Marital Status

Object Version Number

01-JAN-2012

31-DEC-4712

24


2

Action: Updated record in CORRECTION mode

Effective Start Date

Effective End Date

Employee Number

Marital Status

Object Version Number

01-JAN-2012

31-DEC-4712

24

Single

3

Action: Updated record in UPDATE mode effective 01-JUN-2012 and Marital Status = Married

Effective Start Date

Effective End Date

Employee Number

Marital Status

Object Version Number

01-JAN-2012

31-MAY-2012

24

Single

4

01-JUN-2012

31-DEC-4712

24

Married

5

Action: Updated record in UPDATE mode effective 01-SEP-2012 and Marital Status = Divorced

Effective Start Date

Effective End Date

Employee Number

Marital Status

Object Version Number

01-JAN-2012

31-MAY-2012

24

Single

4

01-JUN-2012

31-AUG-2012

24

Married

6

01-SEP-2012

31-DEC-4712

24

Divorced

7

Action: Updated record in UPDATE_CHANGE_INSERT mode effective 01-MAR-2012 and Marital Status = Living Together

Effective Start Date

Effective End Date

Employee Number

Marital Status

Object Version Number

01-JAN-2012

29-FEB-2012

24

Single

8

01-MAR-2012

31-MAY-2012

24

Living Together

9

01-JUN-2012

31-AUG-2012

24

Married

6

01-SEP-2012

31-DEC-4712

24

Divorced

7

Action: Updated record in UPDATE_OVERRIDE mode effective 01-AUG-2012 and Marital Status = Divorced

Effective Start Date

Effective End Date

Employee Number

Marital Status

Object Version Number

01-JAN-2012

29-FEB-2012

24

Single

8

01-MAR-2012

31-MAY-2012

24

Living Together

9

01-JUN-2012

31-JUL-2012

24

Married

10

01-AUG-2012

31-DEC-4712

24

Divorced

11

 Delete Date Track Modes

The various delete date track modes are

ZAP : wipes all records
DELETE : Deletes  current record
FUTURE_CHANGE : Deletes current and future changes.
DELETE_NEXT_CHANGE : Deletes next change

Element Entry records are shown below.

Effective Start Date

Effective End Date

Element Entry Id

Object Version Number

01-JAN-2012

12-OCT-2012

129831

3

13-OCT-2012

19-OCT-2012

129831

5

20-OCT-2012

31-DEC-4712

129831

6

Action: Delete record in ZAP mode effective 14-JAN-2012

No rows

Action: Delete record in DELETE mode effective 14-OCT-2012

Effective Start Date

Effective End Date

Element Entry Id

Object Version Number

01-JAN-2012

12-OCT-2012

129831

3

13-OCT-2012

14-OCT-2012

129831

6

Action: Delete record in FUTURE_CHANGE mode effective 14-JAN-2012

Effective Start Date

Effective End Date

Element Entry Id

Object Version Number

01-JAN-2012

31-DEC-4712

129831

4

Action: Delete record in NEXT_CHANGE mode effective 14-JAN-2012

Effective Start Date

Effective End Date

Element Entry Id

Object Version Number

01-JAN-2012

19-OCT-2012

129831

4

20-OCT-2012

31-DEC-4712

129831

6



Thursday Jul 12, 2012

Extra Information Types (EIT) in Oracle Applications

In this blog I will explain how to create EIT in Oracle HRMS.EITs are basically Descriptive Flexfields (DFF).Standard product has EIT DFFs defined in forms such as Person,Assignment,Job etc.We can add segments to the defined DFF based on our requirements so that it will appear in corresponding screen.Compared to SIT EIT has added security.We can enable EIT  for specific responsibility.

Following steps needs to be perform to create EIT.

1) Create the DFF segments.

Navigate to Application Developer > Flexfield > Descriptive > Segments.

Query for Extra Person Information under Human Resources application.

Uncheck Freeze Flexfield Definition and create the segment.

Click on Segments.Enter the segment details.

Click on save.In the Descriptive Flexfield Segments window check the Freeze Flexfield Definition.Save your work.

2) Register the Extra Information Types.

Navigate to Super HRMS Manager responsibility.Select Register Extra Information Types (EITs) standard concurrent program from the SRS window.Give appropriate values and submit.

3) Assign the EIT to responsibility.

Navigate to Security > Information Types Security under any HRMS responsibility.

Choose the appropriate responsibility (Here I am using Human Resources, Vision Enterprises). Assign the above created EIT.

Save your work.

4) Test the EIT.

Navigate to Human Resources, Vision Enterprises responsibility.Choose any person of type Employee.Click on Others and choose Extra Information.

Save your work.

The above entered information will get populated in PER_PEOPLE_EXTRA_INFO.

The API to create EIT information is HR_PERSON_EXTRA_INFO_API.

Special Information Types (SIT) in Oracle Applications

In this blog I will explain how to create SIT in Oracle HRMS Person screen.SIT is basically a KFF.This we can use to capture additional person information.The KFF which we are using here is Personal Analysis Keyflexfield.We can create and assign N number of SITs to a person.Once you enable the SIT it is available across the Application.

Following steps needs to be done to create a SIT.

1) Define a structure for the Personal Analysis Keyflexfield. For this you have to navigate to

Application Developer > Flexfield > Key > Segments

Query for Personal Analysis Flexfield.

2) Define the segments.

Click on Segments.Create the Segments based on your requirement.

In the Segments window check Allow Dynamic Inserts check box. Once you complete the segment definition check Freeze Flexfield Definition and save your work.

3) Enable the SIT.

For this navigate to

US Super HRMS Manager > Other Definitions > Special Information Types

Create a record for above created structure.Check the check box matrix where ever you want to show the SIT.In this example I am enabling it for Person.

Save your work.

4) Go to any HRMS responsibility.Open Enter and Maintain form.Click on Special Information.Query for above created structure.Enter the information into the segments.

The entry will get created in PER_PERSON_ANALYSES and PER_ANALYSIS_CRITERIA table.