Oracle Human Resource Tables [PDF]

This document contains a HRMS list of tables name and description.

you can download the oracle hrms table name from the following link:




Almost Everything you Wanted to Know about PTO – Paid Time Off [PDF]

In Oracle HRMS, accrual plans are based on elements, formulas, and a net accrual calculation.
All of these are available for you to configure so you have complete control over the rules
underlying your plans. Oracle HRMS does not store net accrual totals. It calculates gross
accruals dynamically by calling the Accrual formula. The net accrual calculation specifies the
element entries that should add to or subtract from this figure to create the net entitlement.

If you use Oracle Payroll, you can set up your accrual plan so that gross accruals are stored in a
payroll balance. Each payroll run retrieves the latest balance and calls the accrual formula to
calculate new accruals since the end of the last payroll period. This approach – using a payroll
balance – is optional but provides performance enhancements if you need to calculate accruals in a batch process

you can download the almost everything you wanted to know about pto from the following link:


Understanding and Using HRMS Security in Oracle HRMS [PDF]

The purpose of this paper is to introduce and describe the key components of HRMS Security, to provide a technical analysis to enable a better understanding of the processes involved, and to give pointers as to why HRMS Security might not be working as desired. For a more detailed examination of how to set up Security Rules for your enterprise, please refer to the manual Oracle HRMS Configuring, Reporting and System Administration Guide.

You can download understanding and using hrms security in oracle hrms document from the following link:


Why an ex-employee cannot be seen when a custom security profile is used?

Applies to:
Oracle Human Resources – Version: to 12.0.1 – Release: 11.5 to 12.0
Information in this document applies to any platform.
*** Checked for relevance on 28-NOV-2011***
Why an ex-employee cannot be seen when using a custom security profile?
If you use a security profile with a custom tab, you can use it in dynamic or in static mode .

You are in dynamic mode if you are using your custom security with ‘Restrict the people visible to each user using this profile’.

You are in static mode if you are using your custom security with ‘Restrict the People visible to the profile’.
1) For dynamic security.

Prior to 12.0.6, it is the normal behavior that you cannot see the ex-employees in dynamic mode.
If you are using your custom security using the ‘Restrict the people visible to each user using this profile’, then you cannot see ex-employees prior to R12.0.6. Prior to12.0.6 there is a limitation to user-based security, in that it doesn’t allow access to ex-employees with a Final Process Date. From 12.0.6 there is a profile option called HR: Ex-Employee Security Profile. Set the Profile to Yes to include Ex-Employees, Ex-Applicants, and Ex-Contingent Workers ,or No to retain original functionality. Doesn’t apply to Supervisor Security. See Note 394083.1 Understanding and Using HRMS Security in Oracle HRMS for futher information.

2) For static security.
If you are using your custom security ‘Restrict the People visible to the profile’ which uses Security List Maintenance to store the data in a static list, then you can see the ex-employees. But you need to run the Security List maintenance concurrent (SLM) to maintain the secured view PER_PERSON_LIST