Audit Report Performance Issue For PAY_ELEMENT_ENTRY_VALUES_F and PAY_ELEMENT_ENTRY_F tables
(Doc ID 3058697.1)
Last updated on NOVEMBER 11, 2024
Applies to:
Oracle Payroll - Version 12.2.11 and laterInformation in this document applies to any platform.
Symptoms
After 12.2 upgrade, There is performance issue with the Audit Report when run it for PAY_ELEMENT_ENTRY_VALUES_F or PAY_ELEMENT_ENTRY_VALUES_F even entered parameter for a user and 1 day as parameter. The record count in the shadow table for these parameters was 199. And it took around 9 hours to complete.
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 |