Poor Performance When Doing Leave Balance Extract Using Hr_au_holidays.get_accrual_entitlement (Doc ID 1627412.1)

Last updated on JULY 14, 2016

Applies to:

Oracle HRMS (Australia) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You are extracting leave balance of 20+ accrual plans for around 12,000 employees.  It is taking 35+ hours to complete.

Upon analysis found that hr_au_holidays.get_accrual_entitlement is calling per_accrual_calc_functions.get_net_accrual procedure twice though calculation date are same
( calculation date variables are l_entitlement_period_end_date and l_calculation_date are same in hr_au_holidays.get_accrual_entitlement ).


EXPECTED BEHAVIOR
-----------------------
Expect this to complete in reasonable time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms