Performance Issue When 'Request More Information' Is Used OR A Blank Value Is Shown For A Role In Workflow Participant (Doc ID 1235664.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Workflow - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

The problem is seen on 11i, 12, and R12.1 instances.

Steps to reproduce:
1. Go to the Worklist.
2. Click on any notification to open the notification details page.
3. From there click on the 'Request for Information' button. On click of the button either the page times out or it takes a while to load the Request for More Information Page. Sometimes, click of 'Request for Information' button in Notification Details Page is resulting in 'Internal Server Error'.

Note that this only happens if the volume of data in Workflow Runtime Tables are relatively higher.

OR

1. Invoice initiated for Approval.
2. Invoice Approval History.
3. Log in with Auditors User name.
4. Instead of Rejection the Invoice, Select additional information.
5. No Workflow participant listed in the LOV.


Cause

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