Min-Max Planning Report Has Performance Issue (Doc ID 556982.1)

Last updated on NOVEMBER 19, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

Performance issues with min-max planning report.

Trace and TKPROF show performance issue in tables
MTL_CATEGORIES, MTL_ITEM_CATEGORIES, MTL_SYSTEM_ITEMS_VL, MTL_PARAMETERS

For Tracing and TKPROF details, see

Note 296559.1 "Tracing FAQ: Common Tracing"
Note 117129.1 "How to get a Trace for And Begin to Analyze a Performance Issue" - Basic Overview)

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