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

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.2.4 and later
Oracle Process Manufacturing Financials - Version 12.2.4 and later
Information in this document applies to any platform.

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

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