Hi

I have just started my new job, and basically I have been asked to:

Reset the time carried over/time in lieu to 0 for absences in oracle hrms (no oracle payroll is used),

Via the HRMS super user Responsibility I can see two elements for absences:

one is annual leave (has start and end date values), and one is days remaining.

The first element is recurring, the second one is none recurring.

I can show screenshots of the exact elements, or write the values down for you on Monday (but i Can't hard code the element names because:)

They have also said in the md50, they don't want me to hard code the element in the plsql package I will write:

"Reset all time carried over at 31st March every year, don't hard code/use the element name as this is subject to change"

After this I have to write a Bi report showing the number of days carried over.

But resetting is difficult, as I don't know what std package name or table name I need to reset, and which column or global variable.

I really need some help on this.

I have googled all week for this, but can't find anything on this.

I have been told to create a plsql package for this.(registered as a conc request)

I dont know any std api's etc..

Thanks in advance.


Tovia

Ok, I have found the api for updating person absence information, but how do i update the accrual plan balance??

HR_PERSON_ABSENCE_API

Thanks in advance

Tovia

Accrual Plan Balances can be adjusted using Element Entries.

You will need to take a look at the Accrual Plan that has been set-up (Total Compensation > Basic > Accrual Plans). Query the plan that your trying to adjust and look at the Net Calculation Rules; this is where you can define an element which will be used in Adjusting the value held in the Accrual. Once you know what element you will be using I guess you can then use the Element Entry API (PAY_ELEMENT_ENTRIES_API licensed with HR) to add the element with the appropriate input values set (usually Effective Date (this is the date you want the adjustment to be applied) and Value (hours / days))...

Hope this makes sense and helps!
Gavin

Hi

Thanks,
Thankyou in advance:

Ok There is an api for updating the accrual plan I found:
HR_ACCRUAL_PLAN_API

PAY_ELEMENT_ENTRIES_API is for oracle payroll use?
I ask as we don't use oracle payroll.


A screenshot of my accrual plan, fast formula connected and elements is here(when you open each image link below please click on each of them again to view any cut of image like elements, you will have to click on again as left side is cut off):
Accrual plan
fast formula
Element time carried over

My requirments:
I must reset the no of days carried over to 0 by march 31st.
(As march 31st is the cut of date)

* I musn't reset time in leui (toil).
* I must only reset time carried over from previous year, that isn't used by 31st March of the current year.
* I cant hard code elements in my code, as they can change i have been told.

I am writing my design document, md050, and then will follow this with a md070 (technical doc).


My questions for you guys are:

1. Shall I use HR_ACCRUAL_PLAN_API or HR_PERSON_ABSENCE_API ?
2. Which dates do I need in my where clause?
3. Which condition will make sure i exclude Time off in lieu (toil), as I don't want to reset this.

I might be able to use a api hook for this.
I Can't find any exmaples on metalink.

Thanks in advance,

Tovia

Hi

Can anyone help me with the above, is there any way to reset the balance on the accrual plan for time carried over, (the balance basically shows time carried forward, remaining, however if not taken by 31st march then it needs to be reset).

Thanks in advance

Hi,

The carry over element should have an input value called 'Expiration Date' - this is the date by which the carry over days must be used. Any carry over days not used by this date will be lost and will not be reflected in the entitlement. You define the logic for the 'Expiration Date' in the underlying carry over formula e.g. in your example it should be set to the 31st March .

Regards,

Hi

Ok new to elemenst and formulas, but heres the fast formula attached to the accrual plan:


/**
** Fast Formula Name: XX_LONDON-METALS_ANNUAL_LEAVE_ACCRUAL_PLAN ( Type Accrual )
**
** Description
** ===========
**
** Accrual formula for LONDON-METALS Plan
**
** Change List
** ===========
**
** Date Author Reference Description
** -----------+----------+---------+---------------------------------
** 12-JUL-2011 Jamie V1.0 Initial Version.
**
** -----------+----------+---------+---------------------------------
*/

Default for EMP_HIRE_DATE is '1900/12/31 00:00:00' (date)
Default for ASG_FTE_VALUE is 1
Default for ASG_HOURS is 40

default for l_effective_Start_Date is '1900/12/31 00:00:00' (date)

Inputs are
calculation_date(date)


/* Set up start and end of year variables */

start_of_calc_year = to_date('0101'||to_char(Calculation_Date,'YYYY'),'DDMMYYYY')
end_of_calc_year = to_date('3112'||to_char(Calculation_Date,'YYYY'),'DDMMYYYY')

/* Get Accrued holiday as at input date */
Total_Accrued_PTO = SOFTPEDIA_EMEA_ANNUAL_LEAVE( calculation_date)

l_effective_Start_Date = GREATEST(EMP_HIRE_DATE,start_of_calc_year)

Effective_Start_Date = l_effective_Start_Date
effective_end_date = end_of_calc_year /*calculation_date*/
accrual_end_date = end_of_calc_year


Return Total_Accrued_PTO,effective_start_date,effective_end_date,accrual_end_date