1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Fast Formula

Discussion in 'Oracle HRMS & Payroll' started by ajay, Dec 26, 2009.

  1. ajay

    ajay Guest

    Hi All,

    I need help in Fast Formula, the logic for that is If my net pay is 11220 then I will be paid 11300 . I need to floor(net pay) but I am not getting where to write the formula.


    Thanks
    Ajay
     
  2. aheli

    aheli Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    Location:
    Kolkata, WESTBENGAL
    Use the following in ur sql statement or in pl/sql block to get as required,

    Code (SQL):
    SELECT TRUNC(<column_name>,-2)+100
    FROM DUAL;
     eg,
    SELECT TRUNC(11220,-2)+100
    FROM DUAL;
     
  3. nktech

    nktech Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Mississauga, Canada
    Code (SQL):
    SELECT salary+(100-rem(sal,100)) FROM TABLE_NAME.
     
  4. m_muzamil_khan

    m_muzamil_khan Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    75
    Hi,
    I am trying to write the following fast formula example for you as you are not know how to write fast formula so that's why I try my level best to provide the whole example from defining the values till geneate the payslip:


    For example I will Truncate the Basic Salary of an Employee, the value of Basic Salary Define in the system is : see attached image 1.jpeg
    1.JPG
    Now write the Fast Formula to truncate the basic Salary:
    Open the Write Formula window and paste the following code:
    --------------------------------------------------------------------
    DEFAULT FOR BASIC_SALARY_PAY_VALUE_START_DATE IS '28-OCT-1974' (Date)
    DEFAULT FOR BASIC_SALARY_PAY_VALUE_END_DATE IS '01-JAN-3000' (Date)
    DEFAULT FOR BASIC_SALARY_ASG_ITD IS 0
    DEFAULT FOR FIXED_SALARY_ASG_RUN IS 0
    DEFAULT FOR MONTHLY_AMOUNT IS 0
    DEFAULT FOR ABSENCES_SALARY_PAY IS '0'
    DEFAULT FOR GROUP_KF_ACTIVITY_TYPE IS '0'
    ALIAS FIXED_SALARY_ASG_RUN AS Fxd_Sal_Amt
    ALIAS BASIC_SALARY_PAY_VALUE_START_DATE AS E_Start_Date
    ALIAS BASIC_SALARY_PAY_VALUE_END_DATE AS E_End_Date
    ALIAS BASIC_SALARY_ASG_ITD AS B_IT
    ALIAS GROUP_KF_ACTIVITY_TYPE AS Activity_Type
    Inputs ARE Monthly_Amount


    Days_In_Current_Period = DAYS_BETWEEN(P_End_Date,P_Start_Date)+ 1
    Actual_Value=Monthly_Amount
    Pay_Amount = TRUNC(Monthly_Amount,-2)+100
    mess='Fast Formula TRUNC Example' || TO_CHAR(Pay_Amount)
    Return Actual_Value,Pay_Amount,mess
    -----------------------------------------------------------------------------------------------------------------------
    Link the output of Fast formula to the Basic Salary Element : see attached image 2.jpeg
    2.JPG

    Run the Quick pay to check the output of your Fast Formula result: see the attached image 3.jpeg
    3.JPG
    Click the View Result Button and select the “Run Results” from the popup window: see the attached image 4.jpeg
    4.JPG

    Then select the Basic Salary Element from the Element Name List and press the “Run Result Values” Button, following window will be display: see the attached image 5.jpeg

    5.JPG


    Hope this will help you.

    Regards,
    Muzamil Khan (muzzamil.khan@gmail.com)
     
  5. anna575

    anna575 Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    Hey, I have been also using this formula, it's very easy and informative. These Fast Formulas are very helpful in Oracle Payroll. You can use it easily. Thanks..
     
    m_muzamil_khan likes this.
  6. mramadhani

    mramadhani Active Member

    Messages:
    27
    Likes Received:
    3
    Trophy Points:
    185
    Location:
    Dar Es Salaam
    Dear Muzamil Khan

    I have seen your useful fastformula example above, I am newbie on that domain of writing fastformula.
    would u like to share some knowledge with me....? kindly please send me more notice or any e-books etc..
    mramadhani@email.com