Performance Issue on Payroll Processes (PAYWSACT) form
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Payroll - Version 12.1.1 and later
Information in this document applies to any platform.
This note provides a brief overview of
Performance issue occurs when querying processes in Payroll Processes form (PAYWSACT.fmb).
SQL Trace shows the following query as the most costly statement.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Open Payroll Processes form with HR responsibility.
(N) View > Payroll Process Results
- Click on Find button with or without specifying search criteria (Payroll, From, To, Action Type)
- Observe the performance issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms