My Oracle Support Banner

Slow Performance When Clicking on Update Button to Launch Time Definition Page (Doc ID 2603196.1)

Last updated on DECEMBER 11, 2023

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.
This note provides a brief overview of .

Symptoms

Problem Statement:

When clicking on the update button of the time definition, the page is taking time to load.

The most expensive query:

SQL ID: caku5vujvfxkd

SELECT NULL
FROM
PAY_RUN_RESULTS WHERE TIME_DEFINITION_ID = :B1

 

 

Steps to Reproduce:

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

  1.  Login as HRMS Manager responsibility
  2.  Go to Other Definitions > Dynamic Time Periods
  3.  Search for the time definition and click on the Update icon of the time definition.

 

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.