Skip to main content
Solved

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

  • September 7, 2023
  • 1 reply
  • 293 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. 

View original
Did this topic help you find an answer to your question?

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

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings