My Oracle Support Banner

Payroll "Rollback Run" Performance Issue in the Requests Form After Upgrade To Release 12.2.11 (Doc ID 2940925.1)

Last updated on APRIL 13, 2023

Applies to:

Oracle Payroll - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

After upgrading application to Release 12.2.11 a performance issue is observed in the Requests form when trying to run the "Rollback Run" process. It takes long time (more than 2 hours) to complete.

Sorted TKPROF shows the below as the most expensive query.

SELECT NULL
FROM
 DUAL WHERE NOT EXISTS (SELECT NULL FROM PAY_ACTION_CLASSIFICATIONS CLASS,
  PAY_PAYROLL_ACTIONS PACT, PAY_ASSIGNMENT_ACTIONS ACT, PER_ALL_ASSIGNMENTS_F

  ASS, PER_PERIODS_OF_SERVICE POS WHERE POS.PERSON_ID = :B2 AND
  ASS.PERIOD_OF_SERVICE_ID = POS.PERIOD_OF_SERVICE_ID AND ACT.ASSIGNMENT_ID =

  ASS.ASSIGNMENT_ID AND ACT.ACTION_SEQUENCE > :B1 AND ACT.ACTION_STATUS IN
  ('C', 'S', 'M') AND ACT.PAYROLL_ACTION_ID = PACT.PAYROLL_ACTION_ID AND
  PACT.ACTION_TYPE = CLASS.ACTION_TYPE AND CLASS.CLASSIFICATION_NAME =
  'SEQUENCED' AND (INSTR(NVL(PACT.LEGISLATIVE_PARAMETERS,'TEST'),'PAY_SIM') =

  0))

Steps to Reproduce:

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

1. Upgrade the application to Release 12.2.11.

2. Go to HRMS Manager responsibility.

3. Navigate to View > Requests > Submit a New Request.

4. Run 'Rollback Run' process.

5. Observe the performance issue.

Changes

Upgrade Application to Release 12.2.11.

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


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