Solved

IFS Cloud 23 R1 upgrade error - ORA-00932: inconsistent datatypes: expected UDT got CLOB

  • 7 September 2023
  • 1 reply
  • 123 views

Badge +7

Hi,

I'm getting an error after upgrading IFS Cloud from 22.2 to 23.1 as below. No customizations.

 

Compilation errors for PACKAGE BODY IFSAPP.FRAMEWORK_SERVICES_SVC

Error: PL/SQL: ORA-00932: inconsistent datatypes: expected UDT got CLOB
Line: 1869
Text: KEY 'UserInformation'        VALUE user_info_          FORMAT JSON,

Error: PL/SQL: SQL Statement ignored
Line: 1867
Text: SELECT json_object(

So cannot log in to IFS Cloud.

 

Same error is at,

NAVIGATOR_SYS

NAVIGATOR_CONFIG_UTIL_API

FRAMEWORK_DEBUG_SERVICES_SVC

 

Please suggest a solution.

icon

Best answer by CovMayurJ 18 September 2023, 06:24

View original

1 reply

Badge +7

Oracle upgraded to 19.18 (from 19.3) solved the issues. 

Reply