My Oracle Support Banner

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.

Symptoms

Problem Statement:
After TYE19 Patch, RTI - Earlier Year Update Process (EYU) is running for days

The following script was identified as causing the performance issue:

SELECT ACTION_INFORMATION13
FROM
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)


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.