Applet Web Layout Editor (Preview) In WebTools Hangs When Opening (Doc ID 2528423.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Symptoms

(1) Login to Web Tools.
(2) Create/open any workspace.
(3) Go to [Applet] and select 'SIS Account Entry Applet'.
(4) Go to [Applet]->[Applet Web Template]->
(5) Click the pencil icon and try to open Applet Web Layout Editor.

The application hangs here and you can't do anything. The OM log shows that it is actually a performance issue and the following SQL was extremely slow:

SELECT
     T6.CONFLICT_ID,
     T6.LAST_UPD,
     T6.CREATED,
     T6.LAST_UPD_BY,
     T6.CREATED_BY,
     T6.MODIFICATION_NUM,
     T6.WS_SRC_ID,
     T3.GROUP_NAME,
     T3.HTML_ATTR,
     T3.SEQUENCE,
     T3.TMPL_ITMHOLDERNAME,
     T3.WEB_TMPL_NAME,
     T1.APP_CD,
     T6.COLUMN_SPAN,
     T1.COLUMN_SPAN,
     T6.COMMENTS,
     T6.CTRL_NAME,
     T6.EXPR,
     T4.MODULE_NAME,
     T2.APPLET_ID,
     T4.NAME,
     T6.GRID_PROPERTY,
     T4.UPG_ICL_PATH_CD,
     T6.INACTIVE_FLG,
     T6.ITEM_NUM,
     T1.ITEM_NUM,
     T1.LANG_CD,
     T6.MARKUP_LANG_CD,
     T6.MODE_CD,
     T6.MODULE_NAME,
     T6.NAME,
     T6.NAMESPACE,
     T1.NAMESPACE,
     T4.OBJ_LOCKED_LANG,
     T4.OBJ_LOCKED_FLG,
     T4.OBJ_LOCKED_BY,
     T6.APPL_WEB_TMPL_ID,
     T2.INACTIVE_FLG,
     T2.NAME,
     T4.PROJECT_ID,
     T5.LOCKED_FLG,
     T5.LOCKED_BY,
     T5.NAME,
     T5.UIFREEZE_FLG,
     T5.UIFREEZE_BY,
     T6.REPOSITORY_ID,
     T6.ROW_SPAN,
     T1.ROW_SPAN,
     T6.REPOS_TYPE,
     T4.UPG_BEHAVIOR,
     T3.EXPR,
     T6.EXTENSION_FLG,
     T6.ROW_ID,
     T6.WS_ID,
     T6.WS_OBJ_VER,
     T6.WS_DELETE_FLG,
     T3.WS_SRC_ID,
     T3.MODIFICATION_NUM,
     T3.CREATED_BY,
     T3.LAST_UPD_BY,
     T3.CREATED,
     T3.LAST_UPD,
     T3.CONFLICT_ID,
     T3.PAR_ROW_ID,
     T3.REPOSITORY_ID,
     T3.ROW_ID,
     T3.WS_ID,
     T3.WS_OBJ_VER,
     T3.WS_DELETE_FLG,
     T3.PAR_ROW_ID,
     :1
  FROM
      (SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APLT_WTI_INTL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APLT_WTI_INTL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T1,
      (SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPL_WEB_TMPL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPL_WEB_TMPL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T2,
      (SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPL_WT_IT_RX WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPL_WT_IT_RX WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T3,
      (SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPLET WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPLET WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T4,
      SIEBEL.S_PROJECT T5,
      (SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPL_WTMPL_IT WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPL_WTMPL_IT WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T6
  WHERE
     T2.APPLET_ID = T4.WS_SRC_ID AND
     T6.WS_SRC_ID = T1.APPL_WTMPL_IT_ID (+) AND T1.APP_CD (+) = :2 AND T1.INACTIVE_FLG (+) = 'N' AND T1.LANG_CD (+) = :3 AND
     T6.APPL_WEB_TMPL_ID = T2.WS_SRC_ID AND
     T4.PROJECT_ID = T5.ROW_ID (+) AND
     T6.WS_SRC_ID = T3.PAR_ROW_ID (+) AND
     (T6.EXTENSION_FLG = 'N' OR T6.EXTENSION_FLG IS NULL) AND
     (T6.APPL_WEB_TMPL_ID = :4)
  ORDER BY
     T6.APPL_WEB_TMPL_ID, T6.NAME

Changes

Cause

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