Wednesday, February 15, 2012

Oracle Payroll Costing Concept

To understand Payroll Costing concept, I would first discuss the Costing Allocation Key Flex field, during the business group definition it is being created and map with Cost Allocation KFF with following segments normally

• Company
• Cost Centre
• Natural Account

During the configuration of Cost Allocation KFF the most important concept is to set the Flex Field Qualifiers at each segment level, we have the five levels available for each segment i.e.

• Payroll
• Balancing
• Organization
• Element Link
• Assignment
• Element Entry

For the Company segment following setting can be applied

Payroll Checked
Balancing Checked

This setting will explain that the Company Account will be input at Payroll level (debit information) and balancing information will goes into credit information and on every segment level it is mandatory to define Balancing.

For the Cost Centre segment, I can set the following setting

Payroll Checked
Organization checked
Balancing checked

This setting will explain that the Cost Centre Account information will be input at Payroll and Organization level (debit information) and balancing information will goes into credit information and on every segment level it is mandatory to define Balancing.

For the Natural Account segment, I can choose the following setting

Element Link Checked
Assignment Checked
Element Entry Checked
Balancing Checked

This setting will explain that the Natural Account information will be input at following levels

Element Link
Element Entry

Element Link, Assignment, Element Entry level information will directly hit the debit account and balancing information will goes into credit Account and on every segment level it is mandatory to define Balancing.

After this step we map Cost Allocation KFF Segments with GL Flex field Segments

In Oracle payroll, Costing information can be input at five levels

• Payroll
• Organization
• Element Link
• Assignment
• Element Entry

Now based on the above configuration, the following codes will be define at Payroll level

Company 01
Cost Centre 000

For example if Business Group has four Departments i.e. Finance, HR, IT, Operations then on every organization the following information will be define at the Organization level

Finance Cost Centre 001
HR Cost Centre 002
IT Cost Centre 003
Operations Cost Centre 004

Note: Here the Cost Centre information will override with information available on Payroll Level

Payroll Level 000
Finance Org Level 001

So the system will pick the value of 001 instead of 000.

Finally following information need to define at every Element Link level, for example if Business Group has only three elements links then Natural Account need to define at every link

Basic Salary 2345
Housing Allowance 2346
Transport Allowance 2347

For Assignment and Element Entry levels, the Natural Accounts codes will not be defined at these levels , but if need to override the link level information then the Natural Account can be enter at assignment or Entry Level. Following the is Override information, if we defined all segment on every level then

The following Entry will be hit to GL

Debit 04.003.2222
Credit 01.000.6766

Because Element Entry Level will override all the above mention levels but this is only for example, if we see this table in our scenario then the value will be shown like this

In this case the following Entry will hit to GL accounts

Debit 01.001.2222
Credit 01.000.6766

Now based on the above configuration the Cost Breakdown report will be shown like this

Cost Summary Breakdown Report– Cost Centre wide

Cost Centre Code Cost Centre Amount
001 Finance xxxx
002 HR xxxx
003 IT xxxx
004 Operation xxxx
Total xxxx.xx

Cost Breakdown Report– Element wide

Wednesday, November 16, 2011

Create SIT Applications in Oracle SSHR - Part2

Step 4 – Map Function with Menu

Next is to add this function (Medical Reimbursement) to the Menu for TEST Employee Self Service.

Then we also need to open the menu "Global Self Service Functions Custom". And add our function to it as well under the function column.

Next we now navigate to our function and we have to personalize the page for it.

Step 5 – Personalize the Page

After this, we have to personalize the page:


to only show our SIT at functional level.

To do this, we will click on our new function in SSHR. But this will show all of the SIT's available which is quite a lot.
So on this page, we click on the "Personalization" link at the top.

Then from here, we find the column "Flex: Key flex for Sit" near the very bottom click the pen image to personalize the page.
Now, on the next page that shows up, find the "Segment List" column.

For this field, we enter values under the function header in the format:

STRUCTURE 1|Segment 1|Segment 2||Structure 3|Segment 7|Segment 8

So for our example we can have:

MEDICAL_REIMBURSEMENT_KFF | Employee Name | Date | Amount | Hospital Name | Details of Sickness

Step 6 – Setting up AME

The final thing to do is to setup AME rules for this workflow process:

Login as "Approvals Management Business Analyst" and create a new Rule under TEST HR

Combination, Header,


Actions - Supervisory (one level up) or whatever we want it to be.

Step 7 – Transfer Amounts to Payroll

For transfer these amount into employee payroll elements you create a PL/SQL Procedure which will be run at the end of every month or whatever cut off date you can run the transfer these amount to payroll.

Create SIT Applications in Oracle SSHR - Part1

Create Applications with Special Information Types in Oracle
Task – To create a Medical Reimbursement form on SSHR screen so the employees can easily update their medical bills every month and their manager can approve these bills and at the end of the month a process have to be run which will transfer these bills into employee’s payroll elements so before payroll run these bill should be updated

Step 1 – Creating SIT

Login in as System Administrator -> Flexfield -> Key -> Segments

Search for Application (Human Resources) and Flexfield Title (Personal Analysis Flexfield)

Define a new row, we can call it MEDICAL_REIMBURSEMENT_KFF and the description can be Job Requests.

Next we click on "Segments" to define the form fields to be used in the application.

Field - ValueSet
Employee Name LOV
Nature of Sickness LOV
Details of Sickness 30Char
Hospital Name 30Char
Amount Allowed CRL_YES_NO
Amount Number

Then we save and compile.

Next, login as Global Super HRMS Manager. And look for the function "Define Special Information Type". Find the one we just created MEDICAL_REIMBURSEMENT_KFF and check the "Enabled" and "Other" checkboxes and save.

Step 2 – Configure WorkFlow Process

Change the node attribute of HR_SIT_JSP_PRC seeded WF to Yes or Yes Dynamic


Copy the seeded workflow

open Workflow builder, login Open the HR item type. Under processes, find HR_SIT_JSP_PRC workflow process as a template Copy it, and paste. When pasting, the internal name should be MEDICAL_REIMBURSEMENT_SIT_PROC_JSP_P (i.e the name of our new workflow process). The display name can be Medical Reimbursement.

Save the workflow locally and upload it via WFLoad command

Step 3 – Define Function

After this, we go back into SysAdmin and go to Application -> Function

The function can be:

Function, User Function Name, Description
MEDICAL_REIMBURSEMENT_PROCESS., TEST Job Request Process, Special Information Types

Under the properties tab, we have:

Function, Type, Maintenance Mode, Context dependence

Under the Form tab we have


Under the Web HTML tab, we have


MEDICAL_REIMBURSEMENT_SIT_PROC_JSP_P is the name of the workflow process we created earlier.

pCalledFrom and OAFunc must be the function name

save & Exit.

To be continue....