Retro Pay Setup in Oracle HRMS Payroll

 Enable dynamic triggers:

1. Navigate to the Dynamic Triggers window.

2. Enable any dynamic triggers that the application generates. It is important to enable these triggers to ensure your payroll processing updates each database table correctly. The recommended minimum list of triggers to enable for the Retro-Notifications report is as follows:

Table Name Trigger Type

PAY_ELEMENT_ENTRY_VALUES_F Update

Press Find

 

PAY_ELEMENT_ENTRIES_F Update

Press Find

PAY_ELEMENT_ENTRIES_F Insert

PAY_ELEMENT_ENTRIES_F Delete Trigger

Define an Event Group:

1. Navigate to the Table Event Group window. (Global HRMS Manager-->Other Definitions --> Event Groups)

2. Enter a name for your Event Group, for example, Retro-Notification Events.

3. Select Retro as your event groups type.

4. Save your entries.

5. Select the events that will produce notification if retrospective changes occur. Specify the following    information to identify the type of update and the database table to which it applies:

• Update Type

• Base Table Name

• Column Name

For example:

Update Type	Table	Column Name
DateTrack Correction	PAY_ELEMENT_ENTRY_VALUES_F	SCREEN_ENTRY_VALUE
DateTrack Update	PAY_ELEMENT_ENTRIES_F	EFFECTIVE_START_DATE
DateTrack Update	PAY_ELEMENT_ENTRIES_F	EFFECTIVE_END_DATE
DateTrack End Date	PAY_ELEMENT_ENTRIES_F
DateTrack Insert	PAY_ELEMENT_ENTRIES_F
DateTrack Delete	PAY_ELEMENT_ENTRIES_F

Enable the Incident Register:

1. Navigate to the Functional Area Maintenance window.  (Global HRMS Manager-->Other Definitions --> Functional Areas)

2. Query the Incident Register and ensure that you have triggers defined.

3. Decide whether to capture the triggers by legislation, business group, or payroll. Navigate to each tab to make your selection.

A caution will be shown on selecting Legislation and Business Group as below.

Setup is complete now.

See Retro Pay by Element

Kindly provide your feedback.

Leave comment for any query.

How to use profile value in report integration in Oracle Apps

Sometimes we need to display the username of the user who ran the concurrent program. USER_ID is stored in Profile Values.

Let's see how is it used...


How to integrate a report (RDF) with Oracle Apps

Go to Parameters Window..

Other profile Values which are commonly used are.. ORG_ID, PER_PERSON_ID, RESP_ID etc


Use the following code to use in report.

Create a Formula Column and use the code below.

    p_user_name varchar2(200);

begin

    select user_name into p_user_name from fnd_user where user_id = :P_USER_ID;

   

    return p_user_name ||' On ' || to_char(sysdate,'DD-MON-RRRR HH24:MI:SS');

   

Exception when others then return null;

Kindly provide your feedback.

Leave a comment for any query.

Proration formula in Oracle HRMS Payroll

Usage:

It is a very common requirement in Oracle payroll, that when a specific event occurs, e.g. Salary change, Salary of that particular period should be prorated.

Steps:

1) Create an element

2) Create Element Links

3) Create an Event Group

4) Create a payroll formula

5) Create a formula of type 'Payroll Run Proration'

6) Attach Event group and Proration formula to element

7) Salary Change

8) Run Quick pay or Payroll

Step (1) Create Element

Step (2) Create Element Link

Change element link criteria accordingly.

Step (3) Create Event Group

Update Type          Table                                        Column Name

Datetrack Update    PAY_ELEMENT_ENTRIES_F    EFFECTIVE_END_DATE
Datetrack Update    PAY_ELEMENT_ENTRIES_F    EFFECTIVE_START_DATE
Datetrack Update    PER_PAY_PROPOSALS            PROPOSED_SALARY_N

Step (4) Create a Payroll formula

DEFAULT FOR ASG_SALARY IS 0

DEFAULT FOR PAY_PROC_PERIOD_START_DATE IS '4712/12/31 00:00:00' (DATE)

DEFAULT FOR PAY_PROC_PERIOD_END_DATE IS '4712/12/31 00:00:00' (DATE)

RESULT =      ASG_SALARY

START_DATE =  PAY_PROC_PERIOD_START_DATE

END_DATE   =  PAY_PROC_PERIOD_END_DATE

RETURN RESULT, START_DATE , END_DATE

Step (5) Create a Proration formula

INPUTS ARE BASIC_SALARY,

PRORATE_START(DATE),

PRORATE_END(DATE)

DEFAULT FOR PAY_PROC_PERIOD_START_DATE IS '01-JAN-0001' (DATE)

DEFAULT FOR PAY_PROC_PERIOD_END_DATE IS '31-JAN-4712'(DATE)

L_PERIOD_START(DATE) =   PAY_PROC_PERIOD_START_DATE

L_PERIOD_END(DATE)   =   PAY_PROC_PERIOD_END_DATE

L_TOTAL_DAYS         =   DAYS_BETWEEN(L_PERIOD_END,L_PERIOD_START) +1

L_WORKED_DAYS = DAYS_BETWEEN(PRORATE_END,PRORATE_START) +1

PAY_VALUE = (BASIC_SALARY/L_TOTAL_DAYS) * L_WORKED_DAYS

START_DATE = PRORATE_START

END_DATE = PRORATE_END

RETURN PAY_VALUE , START_DATE , END_DATE

Step (6) Attach Event group and Proration formula to element

Step (7) Salary Change

Global HRMS Manager --> People --> Enter and Maintain --> Assignment --> Salary

Step (8) Run Quick Pay

 Two element will be shown in Run results. Oracle splits the element execution on change date.

Element 1

Element 2

So we achieved our goal. Hope you enjoyed the post.

Kindly provide your feedback.

Leave a comment for any query.

Balances in Oracle Payroll

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

What is an EIT??

EIT is used to store some extra information about

• Employee
• Assignments
• Jobs
• Positions
• Locations
• Previous Job
• Contacts

and some other as well.

Features:

EIT is a DFF.

EIT is used to store data, where same data is changed quite often.

EIT can be opened at Multiple levels, so very helpful in storing as detailed data as possible.

How to create an EIT??

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

Search flexfield title by name Extra Person Information, as shown below.

Unfreeze the key flexfield and add a new record under the Context Field Values 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.

Now we need to run the concurrent Program named "Register Extra Information Types (EITs)"

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.

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.

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.