My Oracle Support Banner

Batch Detail And Batch Step: Performance issue when navigating between records post 12.2.9 upgrade (Doc ID 2710795.1)

Last updated on SEPTEMBER 21, 2020

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, Batch Details

ACTUAL BEHAVIOR
---------------
Performance issue in Batch Detail and Batch Step forms

After upgrading from 12.1.3 to 12.2.9, there are performance issues in the Batch Details and Batch Step forms when navigating between records. It is taking greater than 3 minutes when navigating between these records (both at Header and Details).


EXPECTED BEHAVIOR
-----------------------
Navigation between batch details and/or batch step records completes in a reasonable time

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

1. Navigate to Batch Details or Batch Step form
2. Query for a batch status
3. Navigate to second or third record
4. Screen will respond in about 3 minutes

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
References


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