Poor Performance When Extracting From PAY_AU_ASG_ELEMENT_PAYMENTS_V On Custom Report And Also With Seeded Pay Advice (Australia)
(Doc ID 2044562.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle HRMS (Australia) - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP7 version, Australian Payroll

ACTUAL BEHAVIOR ---------------After applying <Patch 21267565> - STATUTORY UPDATES EFFECTIVE 1 JULY 2015, getting performance issue when generating custom report which extract data from pay_au_asg_element_payments_v. For the same set of parameters, the report now takes 3-4 hours while it used to take only 2-3 mins.