PERFORMANCE ISSUE IN CHECK FUNDS VIEW RESULTS PAGE (Doc ID 2065063.1)

Last updated on OCTOBER 11, 2015

Applies to:

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

Symptoms

On : 12.1.3 version


ACTUAL BEHAVIOR
---------------
PERFORMANCE ISSUE IN CHECK FUNDS VIEW RESULTS PAGE

When multiple users check funds at the same time in Payables or Purchasing (Requisitions or Purchase Orders) results in multiple blockings on object PSA_BC_RESULTS2_GT.

EXPECTED BEHAVIOR
-----------------------
Do not expect performance issue when multiple users across applications (AP and PO) check funds

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Requisitions > Requisitions
2. Click on menu Tools-> Check Funds
3. If multiple users in AP and in PO are checking funds, then apparently blocking session is occurring and performance burden then ensues


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