HR and PAYROLL Interview Preparation - Part I

In the next few posts I’ll post a collection of Oracle HRMS related questions which might prove useful for interview preparation

1. Can you call pl/sql package functions from within a Fast Formula?

Yes, It is done through Define Function screen in HR. In this screen we can register the pl/sql as “External Function” and reference it in Fast formula definition

Payroll Fast Formula

Oracle Fast Formula is a simple way to write formulas using English words and basic mathematical functions. You can use information from your database in formulas without learning the database structure or a programming language.

Imp HR and Payroll Tables - Part V

>> PAY_INPUT_VALUES_F

Each defined element generally has one or multiple input segment, this DateTracked  payroll table holds the definitions of the input values associated with a specific element. Users can add or modify input values for non–legislative elements.

>> PAY_ELEMENT_ENTRIES_F

This payroll DateTracked table holds the list of element entries for each assignment. The actual values for each entry are held in PAY_ELEMENT_ENTRY_VALUES_F.