ERPstuff - Oracle EBS Community

Dears,

I need a help to define the following element in payroll.

Now i need this element to deduct 2% from the basic salary in the first run for this element.

In the second, third and fourth run i want this element to be paused.

In the fifth, sixth, seventh,.........etc. run i want this element to deduct 0.5% from the basic salary.

Can anyone help me on this????? Please i need your help : (

Ibrahim
HRMS Implementer

Skip Rule can reslove this matter.
Put the clause 1st run value =1.5% and define if this is 5th run then process ,5% ELSE skip

Take chill man -:)
Thanx
Shawaiz Khan --Pakistan

Dear Abdilhaq,

Use the following Skip Rule:

==========================================
==========================================
/* 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 */


no_of_months =trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE))

if no_of_months <= 1 then
SKIP_FLAG = 'N'

ELSE IF no_of_months > 1 and no_of_months <=4 then
SKIP_FLAG = 'Y'

ELSE IF no_of_months > 4 then
SKIP_FLAG = 'N'

RETURN SKIP_FLAG

==========================================
==========================================

Also In Element Formula, put the calculation logic to deduct 2% on the first run, and 0.5 % on the fifth and above. Use the same function above.

I hope that helped...

Regards,

Ahmad Ghanem
Senior Oracle HRMS Consultant

<b><font face="Verdana">Dear Ahmad Ghanem,

Thank you so much for your reply...

But the problem is that i need this element to deduct 2% from the Basic Salary starting from the date that you entered that element and not the date of hiring i mean that no_of_months =trunc(months_between(PAY_PROC_PERIOD_END_DATE, EMP_HIRE_DATE)) will not work because it depends on the Hire Date and not the date of the element effective date...

Please help...</font id="Verdana"></b>

Dear Abdilhaq,

You are most welcome dear. This forum is for sharing knwoledge, experience and opinions.

In my solution, I assumed that the element is entered starting from Employee Hire Date. If this is not the case then you can use Database Items such as "BASIC_SALARY_PAY_VALUE_START_DATE" to capture the start date of the bay value and include it in the FastFormula.

Alternativley, you can create a function that captures the effective start date of this element entry and use it in the Fast Formula that I suggested. Notice that this element should have an input value such as a sequence_id that is automatically generated to distinguish it when retrieving its date in the function, thus, the function should have a parameter of this sequence id.

I hope this helped
If you still have any queries, feel free to ask...

Best Regards,

Ahmad Ghanem
Senior Oracle HRMS Consultant

<font color="blue">Dear Abdil Haq
Do u want to deduct from the basic salary whenever u rcieved instruction to do? if YES so solution is Make Balance of ASG_RUN (for Basic Salary) which will be passed in formula as an input (By this solution u will not have to create any function).
Remaining Skip rule will cater for the 1st & 5th run issue.</font id="blue">

<font color="maroon">Thanx
Shawaiz Khan --Pakistan</font id="maroon">