Maintain Multi-lingual Tables: Performance Problem With CSNLINS.sql

(Doc ID 1483706.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

When running the Maintain Multi-Lingual tables option in ADADMIN to add a language, the following insert statement from script CSNLINS.sql has a performance problem and takes hours to complete.

INSERT INTO CS_INCIDENTS_AUDIT_TL
  (INCIDENT_AUDIT_ID,
  INCIDENT_ID,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY,
  LAST_UPDATE_LOGIN,
  CHANGE_DESCRIPTION,
  LANGUAGE,
  SOURCE_LANG)
  SELECT B.INCIDENT_AUDIT_ID,
  B.INCIDENT_ID,
  B.LAST_UPDATE_DATE,
  B.LAST_UPDATED_BY,
  B.CREATION_DATE,
  B.CREATED_BY,
  B.LAST_UPDATE_LOGIN,
  B.CHANGE_DESCRIPTION,
  L.LANGUAGE_CODE,
  B.SOURCE_LANG
  FROM CS_INCIDENTS_AUDIT_TL B, FND_LANGUAGES L
  WHERE L.INSTALLED_FLAG IN ('I', 'B')
  AND B.LANGUAGE = USERENV('LANG')
  AND NOT EXISTS (SELECT NULL
  FROM CS_INCIDENTS_AUDIT_TL T
  WHERE T.INCIDENT_AUDIT_ID = B.INCIDENT_AUDIT_ID
  AND T.LANGUAGE = L.LANGUAGE_CODE)

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