My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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