AU: Performance Issue with Online Payslip
Last updated on MAY 29, 2018
Applies to:Oracle HRMS (Australia) - Version 12.1 HRMS RUP10 and later
Information in this document applies to any platform.
This note provides a brief overview of
Opening online payslip takes time when accessing the payslip for the first time.
The most expensive query in the SQL trace is as follows.
Plan Hash: 3436226376
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
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