My Oracle Support Banner

Duplicate table name MLOG$_MTH_ENTITY_SUSTAIN_ASPECT (Doc ID 2769170.1)

Last updated on OCTOBER 04, 2024

Applies to:

Oracle Manufacturing Operations Center - Version 12.2.10 and later
Information in this document applies to any platform.

Goal

Upgrading EBS from R12.1.3 to R12.2.10 and is finding issue in the report

DOC> **********************************************************************
DOC> SECTION-18 [full] - me
DOC> **********************************************************************
DOC> "Table name must be unique within the first 29 bytes."
DOC>
DOC> - P3: Duplicate table names may cause confusion as to which is the
DOC> "real" table. Tables that only differ in the 30th character
DOC> may have a conflict in their editioning view names.
DOC> - Fix: Rename table or drop unwanted table.
DOC>#

TABLE_NAME_TO_29_CHARS MATCHES
----------------------------- ----------
MLOG$_MTH_ENTITY_SUSTAIN_ASPE      2

Do we need to rename or drop MLOG$_MTH_ENTITY_SUSTAIN_ASPE?

We are not using MTH (Oracle Manufacturing Operations Center).

 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.