My Oracle Support Banner

Compile Valueset Hierarchies Program is Running Long and Affecting Performance (Doc ID 2762240.1)

Last updated on MARCH 07, 2024

Applies to:

Oracle Application Object Library - Version 12.2.6 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Descriptive flexfields (EXCEPT setup or Flexbuilder issues)

Address performance issue on Compile Valusest Hierarchies Program is running longer.

Previously it used to complete around 180 to 200 mins.

Recently we observed that its taking close to 10 hours to complete.

Environment has been patched with latest code.

Therefore Enhancement Bug 31739841: ‘COMPILE VALUE SET HIERARCHIES’ IS PERFORMING SLOW was logged for development's review.

Need to determine if there are steps that can be taken to identify the root cause for performance being slow.

 

Changes

 

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
Changes
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.