Element with skip rule ?

Oracle Human Resource (Core HR), Payroll, Time & Labor, Self Service HR, Advance Benefit, Talent Management (Performance Management, Competency Management, Performance Appraisal, Goal Management), iRecruitment, Compensation Workbench
Post Reply
rawaf
Posts: 8
Joined: Sun Apr 05, 2009 7:19 am
Location: Saudi Arabia

Element with skip rule ?

Post by rawaf »

Hi Every one,

Please I need your help.

I want to create new element but this element process one time every tow month (month YES another No),
So how can I created ? I try to create with skip rule to check if the element processed last month then skip, But I didn't found any database item to check.

Can you help me ?
eng_ahmad_2007
Posts: 258
Joined: Sun Oct 12, 2008 1:50 pm
Location: Saudi Arabia
Contact:

Post by eng_ahmad_2007 »

Dear Rawaf,

Follow the following steps:
1) Create a skip rule formula
2) Associate the skip rule to the Element Definition
Notice that there is no flag for processing every two months. but you can make use of the following code, you need two database items (PAY_PROC_PERIOD_END_DATE and EMP_HIRE_DATE).

processed = mod(trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE)), 2)
if processed = 0 then
SKIP_FLAG = 'Y'
ELSE IF processed = 1 then
SKIP_FLAG = 'N'

--> This will make the element processed in one month and skipped in another starting from employee Hire Date

Regards,
rawaf
Posts: 8
Joined: Sun Apr 05, 2009 7:19 am
Location: Saudi Arabia

Post by rawaf »

<b>Thank you Eng_ahmad_2007 [:)]</b>

Problem solved. and I will write The formula of skip role if any one need it:
==========================================
==========================================
/* Defaults Section */

default for SKIP_FLAG IS 'N'
Default For PAY_PROC_PERIOD_END_DATE is '4712/12/31 00:00:00'(date)
Default For EMP_HIRE_DATE is '0001/01/01 00:00:00'(date)

/* Formula Body */


processed = mod(trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE)), 2)
if processed = 1 then
SKIP_FLAG = 'Y'

ELSE IF processed = 0 then
SKIP_FLAG = 'N'

RETURN SKIP_FLAG

==========================================
==========================================
eng_ahmad_2007
Posts: 258
Joined: Sun Oct 12, 2008 1:50 pm
Location: Saudi Arabia
Contact:

Post by eng_ahmad_2007 »

You are most welcome Rawaf [:)]
I am happy that I helped. Let us make this forum the best for sharing HR Knowledge and experience.
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 0 guests