My Oracle Support Banner

Performance Problem With CSNLINS.sql When Running Maintain Multi-Lingual tables to Add Language in Adadmin (Doc ID 1483706.1)

Last updated on SEPTEMBER 03, 2020

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)

Changes

 

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.