FNDNLINS.sql Runs Long On Maintain Multi-Lingual Tables
(Doc ID 2202367.1)
Last updated on APRIL 04, 2025
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)
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
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 |
| Cause |
| Solution |
| References |