GMF.CM_CMPT_MST_TL Table Structure Issue and Column COST_CMPNTCLS_DESC#1 (Doc ID 2062588.1)

Last updated on APRIL 01, 2022

Applies to:

Goal

After upgrading from 12.0 to 12.2, the following queries return different table structures. Why?

describe CM_CMPT_MST_TL

SQL> desc CM_CMPT_MST_TL
Name Null? Type
----------------------------------------- -------- ----------------------------
COST_CMPNTCLS_ID NOT NULL NUMBER(10)
LANGUAGE NOT NULL VARCHAR2(4)
SOURCE_LANG NOT NULL VARCHAR2(4)
COST_CMPNTCLS_DESC NOT NULL VARCHAR2(240)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN NUMBER(15)

describe GMF.CM_CMPT_MST_TL

SQL> desc GMF.CM_CMPT_MST_TL;
Name Null? Type
----------------------------------------- -------- ----------------------------
COST_CMPNTCLS_ID NOT NULL NUMBER(10)
LANGUAGE NOT NULL VARCHAR2(4)
SOURCE_LANG NOT NULL VARCHAR2(4)
COST_CMPNTCLS_DESC NOT NULL VARCHAR2(40)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN NUMBER(15)
COST_CMPNTCLS_DESC#1 NOT NULL VARCHAR2(240) --- This column is not shown by the previous describe
 

Solution

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