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!

Scheduling period alert on 1st and 15th of every month

Discussion in 'Oracle HRMS & Payroll' started by Anilshavkaru, Dec 29, 2015.

  1. Anilshavkaru

    Anilshavkaru Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Hi All,

    can you please let me know how can I schedule a period alert on 1st and 15th of every month?

    Thanks,
    Anil S
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    I guess you can't.

    we can schedule it for On the day of month and value as 1.

    Then it willl run on every month day 1.

    But you need to run on 15th also.

    So create one more alert which is as same as existing alert and schedule it on 15th.


    Hope this will help you...
     
  3. Joseph Wesley

    Joseph Wesley Starter

    Messages:
    1
    Likes Received:
    1
    Trophy Points:
    10
    Location:
    Muscat
    control through the script like (to_char(proposed_date,'DD') = 15 OR to_char(proposed_date,'DD') = 30 ) take care of leave year.
     
    Anilshavkaru likes this.