Skip to main content
Solved

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

  • September 7, 2023
  • 1 reply
  • 309 views

Forum|alt.badge.img+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.

Best answer by CovMayurJ

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

1 reply

Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • 18 replies
  • Answer
  • September 18, 2023

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