AU: Performance Issue with Online Payslip
(Doc ID 2404266.1)
Last updated on DECEMBER 11, 2023
Applies to:
Oracle HRMS (Australia) - Version 12.1 HRMS RUP10 and laterInformation in this document applies to any platform.
This note provides a brief overview of
Symptoms
Problem Statement:
Opening online payslip takes time when accessing the payslip for the first time.
The most expensive query in the SQL trace is as follows.
SQL ID: fkpzy1fmsq789
Plan Hash: 3436226376
SELECT PAA_PRE.ASSIGNMENT_ACTION_ID
FROM
PAY_ACTION_INTERLOCKS PAI_RUN, PAY_ACTION_INTERLOCKS PAI_PRE,
PAY_ASSIGNMENT_ACTIONS PAA_PRE, PAY_PAYROLL_ACTIONS PPA_PRE WHERE
PAI_RUN.LOCKING_ACTION_ID = :B1 AND PAI_PRE.LOCKED_ACTION_ID =
PAI_RUN.LOCKED_ACTION_ID AND PAA_PRE.ASSIGNMENT_ACTION_ID =
PAI_PRE.LOCKING_ACTION_ID AND PPA_PRE.PAYROLL_ACTION_ID =
PAA_PRE.PAYROLL_ACTION_ID AND PPA_PRE.ACTION_TYPE IN ('P', 'U')
Plan Hash: 3436226376
SELECT PAA_PRE.ASSIGNMENT_ACTION_ID
FROM
PAY_ACTION_INTERLOCKS PAI_RUN, PAY_ACTION_INTERLOCKS PAI_PRE,
PAY_ASSIGNMENT_ACTIONS PAA_PRE, PAY_PAYROLL_ACTIONS PPA_PRE WHERE
PAI_RUN.LOCKING_ACTION_ID = :B1 AND PAI_PRE.LOCKED_ACTION_ID =
PAI_RUN.LOCKED_ACTION_ID AND PAA_PRE.ASSIGNMENT_ACTION_ID =
PAI_PRE.LOCKING_ACTION_ID AND PPA_PRE.PAYROLL_ACTION_ID =
PAA_PRE.PAYROLL_ACTION_ID AND PPA_PRE.ACTION_TYPE IN ('P', 'U')
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Login as Employee Self-Service
- Go to Payslip
- Observe the performance issue
Changes
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 |
Changes |
Cause |
Solution |
References |