My Oracle Support Banner

Model Structure Page Takes Very Long Time to Load BOM Data (Doc ID 2728408.1)

Last updated on DECEMBER 04, 2020

Applies to:

Oracle Configurator Developer - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Runtime Core

ACTUAL BEHAVIOR
---------------
Poor performance with loading BOM data on the Configurator structure page.

From tkprof output, below sql is taking most of the time:

SELECT * FROM (select        
   PS_NODE_ID,
   NAME,
   PARENT_ID,
   INITIAL_VALUE,
   MINIMUM,
   MAXIMUM,
   PS_NODE_TYPE,
   FEATURE_TYPE,
   REFERENCE_ID,
   MINIMUM_SELECTED,
   MAXIMUM_SELECTED,
   psn_CREATION_DATE,
   psn_LAST_UPDATE_DATE,
   EFFECTIVE_USAGE_MASK,
   EFFECTIVE_FROM,
   EFFECTIVE_UNTIL,
   EFFECTIVITY_SET_ID,
   UI_OMIT,
   TREE_SEQ,
   INTL_TEXT_ID,
   TEXT_STR,
   child_model_expl_id,
   model_ref_expl_id,
   model_id,
   parent_expl_node_id,
   PSN_COMPONENT_ID as component_id,
   xpl_virtual_flag,
   Devl_project_id,
   CHECKOUT_USER,
   initial_num_value,
   PSN_CREATED_BY,
   PSN_LAST_UPDATED_BY,
   EFFECTIVE_PARENT_ID,
   PARENT_PSNODE_EXPL_ID,
   FULL_IMAGE_PATH as NODE_ICON,
   ALT_TEXT,
   attach_nodetype_alt_text,
   detailed_type_id,
   '0' as deleted_flag,
    ORGANIZATION_ID,
    INVENTORY_ITEM_ID,
    persistent_node_id,
    user_pref_node_label,
    user_pref_node_path,
    instantiable_flag,
    display_reorder_child_img,
    ( select DECODE(count (*),0,'N','Y') from dual where exists (
                   select 1 from cz_ps_nodes findchild where findchild.deleted_flag = '0' and (
                      (cz_explnodes_withimages_v.ps_node_type = 263 and cz_explnodes_withimages_v.reference_id = findchild.parent_id) or
           (cz_explnodes_withimages_v.ps_node_type = 264 and cz_explnodes_withimages_v.reference_id = findchild.ps_node_id) or
                   (cz_explnodes_withimages_v.ps_node_type not in (263, 264) and cz_explnodes_withimages_v.ps_node_id = findchild.parent_id)
                   )  
           )) as HasChildren
from
  cz_explnodes_withimages_v
where
  SUPPRESS_FLAG = '0') QRSLT  WHERE effective_parent_id = :1 and parent_psnode_expl_id = :2 and  model_id = :3 ORDER BY TREE_SEQ


EXPECTED BEHAVIOR
-----------------------
5-10 seconds to load the BOM in structure page

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Oracle and Navigate to Configurator Administrator
2. Open Model
3. Click on Structure tab. Page remains in Loading mode for a couple of minutes

Changes

Issue started to happen after upgrading instance from 12.1.3 to 12.2.8.

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
References


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