Scribd Logo
Upload

Welcome to Scribd!

  • 147 views

    OracleFastFormulaToSupportBusiness PPT

    Uploaded by

    mahendhirang
    This document discusses leveraging Oracle Fast Formula features to support business needs seamlessly. Oracle Fast Formula allows writing formulas using English words and basic math functions without needing to learn database structures or programming. It was used to customize seeded formulas for base payroll and create new formulas for vacation hours and shift premiums. Key features discussed include global values, user tables, database items, calling custom functions, and migrating formulas between environments. The presentation provides examples of customizing an existing formula and creating a new formula to calculate values for payroll elements.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    OracleFastFormulaToSupportBusiness PPT

    Uploaded by

    mahendhirang
    147 views25 pages
    This document discusses leveraging Oracle Fast Formula features to support business needs seamlessly. Oracle Fast Formula allows writing formulas using English words and basic math functions without needing to learn database structures or programming. It was used to customize seeded formulas for base payroll and create new formulas for vacation hours and shift premiums. Key features discussed include global values, user tables, database items, calling custom functions, and migrating formulas between environments. The presentation provides examples of customizing an existing formula and creating a new formula to calculate values for payroll elements.

    Original Description:

    How to leverage Oracle Fast Formula to support the changing business needs.

    Original Title

    OracleFastFormulaToSupportBusiness_PPT

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses leveraging Oracle Fast Formula features to support business needs seamlessly. Oracle Fast Formula allows writing formulas using English words and basic math functions without needing to learn database structures or programming. It was used to customize seeded formulas for base payroll and create new formulas for vacation hours and shift premiums. Key features discussed include global values, user tables, database items, calling custom functions, and migrating formulas between environments. The presentation provides examples of customizing an existing formula and creating a new formula to calculate values for payroll elements.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    147 views25 pages

    OracleFastFormulaToSupportBusiness PPT

    Uploaded by

    mahendhirang
    This document discusses leveraging Oracle Fast Formula features to support business needs seamlessly. Oracle Fast Formula allows writing formulas using English words and basic math functions without needing to learn database structures or programming. It was used to customize seeded formulas for base payroll and create new formulas for vacation hours and shift premiums. Key features discussed include global values, user tables, database items, calling custom functions, and migrating formulas between environments. The presentation provides examples of customizing an existing formula and creating a new formula to calculate values for payroll elements.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 25

    Oracle Fast Formula To

    Support Business

    Session ID: 10465


    Leverage Oracle Fast Formula
    Features to Support Business
    Seamlessly

    Prepared by:
    Mahendhiran Ganesan
    Software Developer
    Worthington Industries
    [email protected]

    Mahendhiran Ganesan About Me


    14 years of work experience in Oracle E-Business
    Suite Applications in different capacity.
    Expertise in Oracle E-Business Suite Human Capital
    Management Modules and Supply Chain Modules
    Expertise in Oracle Fusion Middleware Technology
    Oracle University Certifications
    Oracle E-Business Suite 12 Supply Chain Certified
    Implementation Specialist: Oracle Order Management
    Oracle E-Business Suite R12 Human Capital Management
    Certified Implementation Specialist
    Oracle Service Oriented Architecture Infrastructure
    Implementation Certified Expert
    Oracle PL/SQL Developer Certified Associate

    Company Overview

    Market-leading metals manufacturing


    company serving more than 5,000 customers
    Domestic leader in flat rolled metal processing
    Leading global manufacturer of pressure
    cylinders for consumer, industrial, alternative
    fuel, energy and cryogenics markets
    Leading independent provider of customengineered operator cabs for heavy mobile
    equipment
    Market-leading joint ventures serving
    construction and automotive end-markets
    Publicly traded and investment grade
    NYSE Symbol: WOR
    3

    Agenda

    Introduction to Oracle Fast Formula


    Benefits of Oracle Fast Formula
    Features of Oracle Fast Formula
    Implement Oracle Fast Formula
    Q&A

    Introduction to Oracle 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. Oracle Fast Formula is a techno functional
    module that makes complex calculations easier by
    leveraging its powerful features. We have used Oracle
    Fast Formula in the following Oracle Human Capital
    Management Modules.
    Core HR
    Payroll
    Compensation and Benefits

    Benefits of Oracle Fast Formula

    Simple and Easy to understand and write


    Less Implementation and maintenance cost
    Support multiple versions
    No downtime required for deployment
    Reusable for different business groups
    Technical knowledge is required only for writing
    custom database function

    Features of Oracle Fast Formula

    Date Tracked Fast Formula versions


    Date Tracked Global Values
    Date Tracked User Tables
    Static and Dynamic Database Items
    Supports Call to Oracle seeded functions
    Fast Formula Results to Feed Other Elements
    Call to Custom Functions and Contexts
    Register Custom Database Functions
    Call to Fast Formula in Database Packages

    Implement Oracle Fast Formula


    As per our Oracle Human Resource Management System and
    Payroll Implementation for Canada business group, we created
    new fast formula and modified the seeded fast formulas to
    support base payroll, vacation and shift premium calculations by
    the call to database functions. We leveraged global values,
    database items, formula results and user table features to
    support the demanding business changes seamlessly. In this
    presentation, have illustrated the ways to customize seeded
    Oracle Fast Formula and create new custom Oracle Fast
    Formula using US HRMS Manager responsibility.
    Note: This presentation highlights on leveraging the powerful
    features of Oracle Fast Formula, to get the detailed information
    on Oracle Fast Formula, please refer to the following link
    https://docs.oracle.com/cd/E18727_01/doc.121/e14567/T1774T
    1776.htm
    8

    Implement Oracle Fast Formula Customize seeded Oracle Fast Formula


    Requirement
    Calculate Shift Premium based on Base Pay using
    Shift Differentials

    Design
    Configure User Table to hold shift differentials and
    multiples
    Customize seeded Oracle Base Pay Fast Formula
    using Oracle seeded functions and database items
    Assign Base Pay Results to feed Shift Premium
    element

    Implementation

    Implement Oracle Fast Formula Customize seeded Oracle Fast Formula


    Configure Date Track User Table to hold shift
    differentials
    Navigation: Other Definitions -> Table Values

    10

    Implement Oracle Fast Formula Customize seeded Oracle Fast Formula


    Get the seeded Oracle Fast Formula name
    associated to Base Pay Element
    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Fast Formula Results

    11

    Implement Oracle Fast Formula Customize seeded Oracle Fast Formula


    Download/Copy the date tracked seeded Oracle Fast
    Formula Version in any text editor
    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Write Formula (Note: Fast Formula can also
    be downloaded using Fast Formula Assistant)

    12

    Implement Oracle Fast Formula Customize seeded Oracle Fast Formula


    Customize seeded Oracle Base Pay Fast Formula
    Add the Input Values in Input Section
    Call the Oracle Seeded function in the Calculation
    Section and Pass the Input Values and Database Items
    as parameters
    Pass the calculated values in the Return Section

    13

    Implement Oracle Fast Formula Customize seeded Oracle Fast Formula


    Assign the Base Pay Fast Formula Results to Shift
    Premium Element
    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Formula Results

    14

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Requirement
    Calculate Vacation hours based on Employee Length of
    Service(LOS) in the organization

    Design
    Create a New Custom Database Function to get LOS
    Register the New Database Function and parameters
    Configure Global Values to hold the Default Vacation
    Hours based on Hire Date
    Configure the User Table to hold the Vacation Hours
    based on Hire Date and different Business Unit policies
    Create the New Custom Oracle Fast Formula by calling
    Custom Function, seeded Oracle Functions and
    Database Items
    Assign the New Custom Oracle Fast Formula to
    Vacation Element

    Implementation

    15

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Create the New Custom Database Function
    Code Snippet

    Note: Oracle Custom Database Functions has to be


    deployed through any Code migration process in the
    target instance, then Oracle Fast Formula that calls to that
    Oracle Custom Database Functions can be compiled and
    verified in the target instance.
    16

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Register the New Database Function and parameters
    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Formula Functions

    17

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Configure Date Track Global Value to hold the Default
    Vacation Value
    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Global Values

    18

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Configure Date Track User Table to hold the Vacation
    Hours
    Navigation: Other Definitions -> Table Values

    19

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Create the Oracle Fast Formula by selecting
    appropriate Oracle Fast Formula Type for the
    Effective Date
    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Write Formula

    20

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Create the Oracle Fast Formula in any text editor
    Write the Oracle Fast Formula using IF and ASSIGN
    Statements
    Call the New Custom Database Function and Pass the
    Input Values and Database Items as parameters
    Pass the calculated values in the Return Section

    21

    Implement Oracle Fast Formula - New


    Custom Oracle Fast Formula
    Attach the New Custom Oracle Fast Formula to the
    Vacation Accrual Element
    Navigation: Total Compensation -> Basic -> Accrual
    Plans

    22

    Implement Oracle Fast Formula - Migrate


    Oracle Fast Formula
    Oracle Fast Formula can be migrated in two ways
    Date Track Mode
    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Write Formula

    Non - Date Track Mode


    Navigation: Total Compensation -> Basic -> Fast
    Formula -> Fast Formula Assistant

    Note : To user Fast Formula Assistant, Fast Formula


    Transaction Manager should be up and running.

    23

    Recap Q&A

    Simple and Easy to understand and write


    Date Track Features
    Configurable setups to support changes seamlessly
    Database items and functions
    Easy Implementation and Deployment

    24

    Please complete the session


    evaluation
    Session Id: 10465
    Presenter: Mahendhiran Ganesan

    We appreciate your feedback and insight


    Thank You !!!

    You might also like