UK RTI: Earlier Year Update Has Performance Issues
(Doc ID 2586862.1)
Last updated on SEPTEMBER 10, 2019
Applies to:Oracle HRMS (UK) - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.
After TYE19 Patch, RTI - Earlier Year Update Process (EYU) is running for days
The following script was identified as causing the performance issue:
PAY_ACTION_INFORMATION PAI ,PAY_ASSIGNMENT_ACTIONS PAA ,PAY_PAYROLL_ACTIONS
PPA WHERE PAI.ACTION_INFORMATION15 = :B2 AND PAI.ACTION_INFORMATION14 = 'Y'
AND PAI.ACTION_INFORMATION30 = 'Y' AND PAI.ACTION_INFORMATION_CATEGORY =
'GB_RTI_FPS_ASG_DET1' AND PAI.ACTION_CONTEXT_TYPE = 'AAP' AND
PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.ASSIGNMENT_ID IN (
SELECT ASSIGNMENT_ID FROM PER_ALL_ASSIGNMENTS_F PAAF WHERE PERSON_ID = :B3
AND ASSIGNMENT_TYPE = 'E' AND PAAF.BUSINESS_GROUP_ID =
PPA.BUSINESS_GROUP_ID ) AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.REPORT_TYPE LIKE 'RTI_FPS_REP%' AND PPA.EFFECTIVE_DATE >= :B1
Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Run RTI - Earlier Year Update Process (EYU)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document