FNDNLINS.sql Runs Long On Maintain Multi-Lingual Tables

(Doc ID 2202367.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Workflow - Version 12.2.4 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Running maintain multi-lingual tables adding a new language to the System,
script FNDNLINS.sql runs for hours on:

INSERT /*+ append parallel */ INTO WF_MESSAGE_ATTRIBUTES_TL ( MESSAGE_TYPE,
 MESSAGE_NAME, NAME, DISPLAY_NAME, PROTECT_LEVEL, CUSTOM_LEVEL, DESCRIPTION,
 LANGUAGE, SOURCE_LANG ) SELECT B.MESSAGE_TYPE, B.MESSAGE_NAME, B.NAME,
 B.DISPLAY_NAME, B.PROTECT_LEVEL, B.CUSTOM_LEVEL, B.DESCRIPTION, L.CODE,
 B.SOURCE_LANG FROM WF_MESSAGE_ATTRIBUTES_TL B, WF_LANGUAGES L WHERE
 L.INSTALLED_FLAG = 'Y' AND B.LANGUAGE = USERENV('LANG') AND (
 B.MESSAGE_NAME,B.MESSAGE_TYPE, B.NAME , L.CODE) NOT IN (SELECT /*+ hash_aj
 index_ffs(T,WF_MESSAGE_ATTRIBUTES_TL_PK) */ T.MESSAGE_NAME ,T.MESSAGE_TYPE ,
 T.NAME ,T.LANGUAGE FROM WF_MESSAGE_ATTRIBUTES_TL T)

 

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