Extremely slow performance seen with Report: Benefits Confirmation and Summary Report.
Last updated on DECEMBER 14, 2016
Applies to:Oracle Advanced Benefits - Version 126.96.36.199 and later
Information in this document applies to any platform.
On RDBMS versions 10.2.0.2 and higher:
Extremely slow performance seen with concurrent request "Benefits Reports Wrapper Process", Report Name: Benefits Confirmation and Summary Report.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Go to responsibility HRMS Manager.
2. Navigate to Processes and Reports > Submit Processes and Reports > Single Request.
3. Select request name "Benefits Reports Wrapper Process" and choose the report name "Benefits Confirmation and Summary Report".
- Submission on 12/23/09 for 1000 participants has yet to complete.
- Submissions for 1 to 6 employees at a time takes between 10-20 minutes but eventually completes.
- This is unacceptable timing.
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