Writing a Skip Rule Formula in Oracle HRMS Payroll

Sometimes it is a requirement that a formula is processed when a certain condition is met. For instance, your company would pay an allowance every quarter. So to achieve this goal, there a functionality available of writing Skip Rule Formula.

Here is the element window and where we specify the Skip Rule.

Navigation: Global HRMS Manager -> Total Compensation -> Basic-> Element Description

Element Description - Skip Rule

Now Let's write the Skip Rule Formula.

Navigation: Global HRMS Manager -> Total Compensation -> Basic-> Write Formulas

Write Formula - Skip Rule

Choose Edit and write your formula as follows:

Default for PAY_PROC_PERIOD_NUMBER is 0

skip_flag = 'y'

IF
PAY_PROC_PERIOD_NUMBER=1 OR
PAY_PROC_PERIOD_NUMBER=4 OR
PAY_PROC_PERIOD_NUMBER=7 OR
PAY_PROC_PERIOD_NUMBER=10 THEN
(
skip_flag='n'
)

Return skip_flag


Verify the formula, close the Edit window, and save your work.

Formula Code - Skip Rule


Now navigate back to Element screen.

Navigation: Global HRMS Manager -> Total Compensation -> Basic-> Element Description

Now select the skip rule formula field as shown in Screenshot 1.

For any query, leave your comment.





7 comments:

  1. Thats great, please write fast formula for automatic employee number generation through some number deffer logic.

    ReplyDelete
  2. Hi sir, It's very useful. please define advance pay and how to assign them. thanks in advance

    ReplyDelete
  3. rul skip rule works only for multiple items without income?

    ReplyDelete
  4. Awesome post! Personally I like your site. . I am so impressed to read your content. I am looking forward for the next valuable and informative concept in your blog. Overall outstanding post. Carry on :) Well done!
    If you want Digital Marketing Serives :-
    online bookkeeping tool

    ReplyDelete
  5. Nice Information, your blog is sharing unique information...
    Thanks for sharing!!!

    CCSU BA 1st Year Result 2022
    CCSU BA 2nd Year Result 2022
    CCSU BA 3rd Year Result 2022

    ReplyDelete