My Oracle Support Banner

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 later
Information 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


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