Performance Issues: Retro-Notifications Report (Enhanced) - PDF
(Doc ID 2825906.1)
Last updated on JANUARY 24, 2022
Applies to:Oracle Payroll - Version 12.2.1 and later
Information in this document applies to any platform.
Performance issue with Retro-Notifications Report (Enhanced) - PDF:
Most expensive sql
SELECT MIN(CREATION_DATE), MAX(CREATION_DATE)
WHERE EVENT_UPDATE_ID = :B4 AND SURROGATE_KEY = :B3
AND ASSIGNMENT_ID IS NOT NULL AND ASSIGNMENT_ID = :B2
AND CHANGE_TYPE = NVL(:B1,CHANGE_TYPE)
The issue can be reproduced at will with the following steps:
1. In HRMS Manager responsibility
2. Navigate Process and Reports -> Submit Processes and Reports -> Single Report -> Retro-Notifications Report (Enhanced) - PDF
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