EMM9.2: While Upgrading to FSCM 9.2 PUM Image 36 or Higher Getting "The data types of the result-expressions of a CASE expression or DECODE function are not compatible. SQLSTATE=42804" Error For WM_ASSET_SD_VW View
(Doc ID 2694359.1)
Last updated on JUNE 17, 2022
Applies to:PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]
DB2 for Linux Unix and Windows - Version 9.1 to 10.5
Information in this document applies to any platform.
While upgrading to FSCM 9.2 Image 36 or higher getting below error for WM_ASSET_SD_VW while running the Change Assistant step for creating views:
Steps to Replicate:
- Apply FSCM 9.2 PUM Image 36 or higher using change assistant.
- Run the Change Assistant step corresponding to create Views.
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