Performance Issue with Maintain Multilingual Tables EGONLINS.sql And INVNLINS.sql Taking Long Time (Doc ID 1391050.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Product Hub - Version 12.1.2 and later
Information in this document applies to any platform.
*** Checked for relevance on 03-Dec-2014 ***

Symptoms

ACTUAL BEHAVIOR
1. Run adadmin > 2. Maintain Applications Database Entities-> 3. Maintain multi-lingual tables
Internally EGONLINS.sql and INVNLINS.sql take 9 and 20 hours respectively.
Customer would like assistance in enhancing the performance of the noted sql scripts.

STEPS
1. Run adadmin
2. Maintain Applications Database Entities
3. Maintain multi-lingual tables

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