Allocation Calculation Performance Is Slow With Multiple Concurrent Users

(Doc ID 2228067.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Retail Allocation - Version 14.0.3 to 14.0.4 [Release 14.0]
Information in this document applies to any platform.

Symptoms

Problem Description

When submitting multiple calculation jobs (>3 jobs) in Allocation, the related database sessions run long for several hours (>7hrs).

Steps to Recreate

  1. Create 4 or more allocations with multiple users
  2. Calculate the allocations approximately the same time
  3. Note that the calculations can take several hours to complete.

 

Changes

 

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