AU: Performance Issue with Online Payslip

(Doc ID 2404266.1)

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 .

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')

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Login as Employee Self-Service
  2.  Go to Payslip
  3.  Observe the performance issue

 

Cause

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