R12:Performance issue when run Workflow Background Process program

(Doc ID 2176384.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Other-MiscIss & KeyIndReport

ACTUAL BEHAVIOR
---------------
Workflow Background Process running too long due to AP_WEB_INACTIVE_EMP_WF_PKG.FINDACTIVEMANAGER

EXPECTED BEHAVIOR
--------------------
there should not be any performance issue.

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

1. Submit concurrent request 'Workflow Background Process' with following
parameters:
  Item Type:
  Process Deferred: Yes
  Process TimeOut: Yes
  Process Stuck: Yes
2. Runs very long time and does not complete.

3. Submit same process with following parameters (Exclude TimeOuts):
  Item Type:
  Process Deferred: Yes
  Process TimeOut: No
  Process Stuck: Yes
  Works fine without any issues.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the program does not complete causing workflows not to complete.

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