Performance improvement for Workflow Directory Services User/Role Validation(FNDWFDSURV) (Doc ID 2207257.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Symptoms

On : 12.1.3 version, Workflow Directory Service (users and responsibilities)

ACTUAL BEHAVIOR
---------------
When running Workflow Directory Services User/Role Validation Concurrent Program against multiple users ,
there is a significant performance degradation WF_UR_VALIDATE_STG phase in
procedure WF_MAINTENANCE.ValidateUserRoles().

This issue occurs easily when Workflow Directory Services has huge volume.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to EBS as sysadmin
2. Choose System Administrator Responsibility
3. Submit Concurrent program Workflow Directory Services User/Role Validation for a user

Cause

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