
Explore how Oracle fast formula customizes absences and payroll with input-driven calculations and validations. Learn to use database items, contexts, and functions to handle complex client requirements.
Explore how to use fast formulas for absence and payroll in Oracle, including creating an absence plan, accrual rules, variables, inputs, and attaching formulas to plans for Saudi Arabia scenarios.
Fast formula session 2 covers data types, default statements, and aliases, plus input and output definitions. It demonstrates days between, validation formulas, and leave accruals and terminations through practical examples.
Learn to build and validate fast formula for absence management in Oracle, including absence types, validations, error messages, and debugging using inputs like start date and maternity or sick leave.
Discover how fast formula uses context and barometers to fetch dynamic data, using get context and context blocks to derive effective dates, personality, and employment status.
Explore dynamic database items, including single versus multiple values stored by index or with no index, with looping to fetch multiple entries and effective start and end dates and history.
Learn to build conditional logic in Oracle fast formula by setting and changing date contexts, fetching values by effective dates, and distinguishing full-time from part-time statuses.
Master the basics of Oracle fast formulas for payroll by building a salary element, attaching inputs, and debugging with messages; explore direct versus indirect value flow.
Learn to compute gross and basic salaries using percentage inputs, fetch values via database items, manage element priorities, and bridge fast formula with HR data.
Explore fast formula session 6-2, applying and executing formulas across modes to determine a position name and output pay, using gross salary and basic salary calculations from inputs.
Learn how to fetch and calculate payroll balances in Oracle fast formula, including gross and net earnings, month-to-date and inception-to-date values, using dimensions and balance results.
This session demonstrates using bulk storage areas (WASC) to share values between payroll elements, creating local and global variables, fetching and deleting values, and building validation formulas for payroll elements.
Oracle is widely used ERP world wide and is being used by many small,medium and large scale industries to maintain the employee data, their absences, compensation details, running the payroll, reconciling the output through reports. As different businesses have different needs, Oracle has come up with fast formulas to satisfy individual business requirements or custom logic. These fast formulas can be written in all the modules of HR, like Absence, payroll, OTL, Compensation, Benefits. And to learn Fast formula is not at all a rocket science but a bit of aptitude need. Oracle does provide all that is needed in common across all businesses but for any custom payroll calculatio, Element entry validation, proration logic, Accrual calculation, Absence validation, carryover logic and what not, Fast formula comes handy Hope you will enjoy the sessions and be expert after going through the videos.
Introduction
1. Overview of Fast Formula
2. Uses of Fast Formula
3. Fast formula content
3.1 Formula Components
- Assignment Statements
- Return Statements
- Variables
- Input Statements
- Expressions
- Conditions
- Comments
3.2 Formula Statements
- Statement Types
- Ordering Statement
- Grouping Statement
3.3 Classes of Variables
- Input Variables
- Output Variables
- Local Variables
3.4 Naming Variables
- Reserved Words
- Formula Data Types
- Array Methods
3.5 Database Items
- Straight DBI’s
- Array DBI’s
3.6 Formula Operators
3.7 Literals
- Numeric
- Text
- Date
- Array
3.8 Formula Variable Types: How they are determined
3.9 Formula Contexts
3.10 Working Storage Area
4. Formula Types
4.1 Payroll
- Oracle Payroll
- Element Entry Validation
4.2 Absences
- Global Absence Accrual Matrix Formula
- Global Absence Entry Validation
5. Practice
- Plain Requirement
- Mid – Complex Requirement
- Complex Requirements