E-UPG Alter Audit errors: Alter failed due to an unknown column type -- for Timestamp and Clob

(Doc ID 1477666.1)

Last updated on DECEMBER 02, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.47 and later
Information in this document applies to any platform.
*****reviewed for currency Jan 2014*****

Goal

 

Performing an Upgrade:  PeopleSoft FSCM application from 8.9 to 9.1.  Received an error in the Running the Initial Alter Audit task. 

Source environment is FSCM 8.9 on PeopleTools 8.47.03 and Target environment is FSCM 9.1 on PeopleTools 8.52.06.

 

Running initial alter audit

Error was:

 

Error: PS_PC_INTOPC_SUM - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field DT_TIMESTAMP. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_1099C_CUST_DATA - Alter failed due to an unknown column type (CLOB) found for field DESCRLONG. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACCESS_GRP_LANG - Alter failed due to an unknown column type (CLOB) found for field DESCRLONG. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACCESS_GRP_TBL - Alter failed due to an unknown column type (CLOB) found for field DESCRLONG. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACQ_DET_TEOA - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field DTTM_STAMP. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACTION_LST - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field CONVER_DTTM_INIT. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACTION_TBL - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field LAST_MAINT_DTTM. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACTIONS_CNVR_WF - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field ADD_DTTM. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACTIONS_CR_WF - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field ADD_DTTM. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ACTIONS_ITEM_WF - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field ADD_DTTM. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ADB_ACT_LOG - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field DTTM_STAMP_SEC. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ADB_ACT_LOG_S - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field DTTM_STAMP_SEC. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ADB_AMT_ACCTS - Alter failed due to an unknown column type (TIMESTAMP(6)) found for field DTTM_STAMP_SEC. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ADB_DEFN_LANG - Alter failed due to an unknown column type (CLOB) found for field DESCRLONG. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_ADB_DEFN_TBL - Alter failed due to an unknown column type (CLOB) found for field DESCRLONG. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)

 

Are these true errors?  Or simply warnings that can be ‘bypassed’?

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