Question

Can Data Migration Tool (APP10) support CLOB Data Type?

  • 10 May 2022
  • 1 reply
  • 102 views

Badge +2

Customer needs to create Quick Reports through Data Migration Tool and need to specify the Query column which is a CLOB type, here it won’t allow.

 

 

Is there a way to migrate the CLOB data type?

 


1 reply

Userlevel 4
Badge +10

Hi @udenig ,
 

In APPS10 the CLOB type columns are not be supported in Data Migration Tool. Only capable of handling up to the max limit of VARCHAR2.

Foundation documentation gives information about this limitation

https://docs.ifs.com/techdocs/foundation1/040_administration/260_data_management/050_data_migration/009_references/known_limitations/default.htm

If there is no function in the api you could create a script for transferring the data

Reply