Archive for the ‘Oracle HRMS E-Business Suite’ Category

Oracle Payroll Costing Concept

June 5, 2012

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.


Muzzamil Khan ( Team Lead HRMS)

Oracle HRMS Payroll Interview Questions

June 29, 2010

Q1) What is the difference between a Job and a Position?

Job is general one, whereas Position is specific term to its role and responsibilities.

 JOB:            MANAGER (generic term), SOFTWARE DEVELOPER

 POSITION:  Finance Manager, HR Manager, Junior SOFTWARE ENGINEER, (this is position which is                               specific to the role to be played.

Q2) What are the difference between extra information type (EIT) and special information type (SIT)?

EIT and SIT Both are provided by Oracle to Capture Extra Information. Basic differences would be EIT is similar like a DFF and also defined using DFF Definition Screen. SIT is KFF and defined using Personal Analysis KFF Definition screen.

SIT generally used at Person Level, EIT can be defined at PERSON, ASSIGNMENT, CONTACT, ELEMENT, LOCATION and JOB LEVEL.

There are 2 columns date_to and date_from in SIT while no such columns are there in EIT.

Q3) Tell me the name of important Key Flex-Fields (KFFs) in Oracle HRMS?

  • Job KFF,
  • Grade KFF,
  • People Group KFF,
  • Position KFF,
  • Cost Allocation KFF,
  • Comptence KFF

Q4) List of some Important Tables in HRMS


Q5) What is the difference between both SECURED VIEWS and NON SECURED VIEWS?

1.Secured views display information only for the current period

2.Unsecured views is used to get the information from the entire rows

Q6) Define APIs and use in Oracle HRMS?

API’s are used in HR to insert the data into the Base tables. As it’s very secured system, the user does not have the facility to copy the data directly into the Base tables. When we write the inbound interfaces / use WebAdI, the systems will use the APIs to store the data into system. The API are published by oracle with number of parameters. The different types of parameters are IN / INOUT / OUT of these parameters few are mandatory, without which the process won’t complete. Generally when we use API we give data FOR : Object Version Number, Effective Date, P_Validate

HR_EMOYEE_api example: hr_employee_api.create_employee
hr_organization_api Example: hr_organization_api.create_organization

Q7) What are processing types of element?

Elements are nothing but the components of the salary.

For Example: Basic Salary, House Allowance, Transport Earning, Bonus, Loan Recovery etc.

There are 2 types of Processing

1. Recurring: if an entry of this element applies in every period until the entry is ended

2. Non Recurring: if an entry applies in one pay period only.

Q8) What are termination roles of an element?

Termination Rules of an Element:
a).Actual Termination:  For a nonrecurring element, select Actual Termination if you want the entries to close down at the end of the pay period in which the employee leaves.
b).Final Close: if you want the entries to stay open beyond the employee's leaving date so that you can continue to pay the employee.
c).The Last Standard Process date defaults to the last day of the pay period in which the employee is terminated, but you can set it to a later period when you terminate an employee.


Q9) What is costing?

Recording the costs of an assignment for accounting or reporting purposes, Using Oracle Payroll, you can calculate and transfer costing information to your general ledger and into systems for project management or labor distribution.


Q10) What are 2 modes of date track in Oracle APPS?

There are two Date Track modes are as follow:

Q11) Can a job has multiple positions? 

Job is generic. Yes a job can have multiple positions.

Q12) Can you call PL/SQL Package functions from within a Fast Formula?
Yes you can
–>how do we do this?
There is a Define Function screen in HR. In this screen you will register the PL/SQL as “External Function”.

Q13) Can we want to pass a parameter PAYROLL_ID to this external PL/SQL Function, how do we do it?
The “Define Function” screen has a button named “Context Usage”. This button opens up a window in which you can register the parameters.

Q14)  How do you debug a Fast Formula?
You can create a message variable in Fast Formula.
This message variable must also be registered as a Formula Result ( In “Formula Result Rule” window).

Q15)  What are the various levels where you can Set up Payroll Costing Accounts?Which levels take the highest precedence?
Element Entry => Highest
Assignment => Second Highest
Organization => Third Highest
Element Link => Fourth Highest
Payroll => Fifth Highest

Q16) Technically speaking, how do you know from tables that an Employee has been terminated?
(a) The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP
(b) A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null

Q17) How can you make Employee Number generation Automated based on business rule etc?
Use Fast Formula.

Q18) What is the difference between per_people_f and per_all_people_f?
 PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The secure view uses an API hr_security.show_person. This API internally checks for an entry in table PER_PERSON_LIST for the logged in person’s security profile. A concurrent program named “Security List Maintainence program” will insert records in PER_PERSON_LIST.

Q19) If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?
Responsibility level. Responsibility level will override FUNCTION level personalization’s.

Q20) Say you have done a lot of Personalization’s to Self Service Screens. But all these Personalization’s were done in DEVELOPMENT environment. How will you migrate these personalization’s to PRODUCTION environment?
Before 11.5.7
This is a java program given by Oracle. This is the only way you can script it.
In DEV you will do AKLOAD DOWNLOAD ( & other parameters)
In PRD you will do AKLOAD UPLOAD ( & other parameters)
On or after 11.5.10 Use responsibility “Functional Administrator”, then click
on Personalization Tab, and then click on Import/Export.
Next select the documents to be exported.
Go to the UNIX box and tar the personalization’s into a .tar file.
On the Production environment unzip this tar file in location as entered in profile “FND: Personalization Document Root Path”.
Setting up of this profile is mandatory or else Oracle Framework wouldn’t know where to search for the files to be imported.

Q21) How to restrict iRecruitment external visitors to access only responsibilities on the external server?

Set the Server Trust Level for the server to External, Set the Trust Level of the iRecruitment external responsibilities to External too.

Q22) Is SSHR a dependency for iRecruitment?

iRecruitment has no dependence on SSHR

Q23) Does iRecruitment support “Candidate Qualifying Questionnaires” where the candidate must answer vacancy-specific questions correctly prior to submitting an application?

iRecruitment currently does not support this function, For now this can be achieved by having a set of simple questions using flexfield to get those responses and a user hook to validate them as part of the apply process.

Q24) Do we track vacancy history?

iRecruitment does not track changes to the vacancy. If changes to a field are to be traced use the Audit capability in APPs.


Get every new post delivered to your Inbox.