Hi @lpktysack
what kind of notes do you want to migrate? Sticky notes fromt Apps 9 to IFS Cloud?
Hi @lpktysack,
the are two problems in this case:
ROWID and CLOB are data types which you can’t use in the migration tool and a known limitation, only NUMBER/VARCHAR2/DATE are valid data types.
By the way: ROWID is a valid datatype in Oracle.
For your example you can use the procedure BUSINESS_OPPORTUNITY_API.Write_Note_Excel__ but keep in mind that you only have 4000 characters available for your notes field.
I hope this will solve your problem.
/Jens
Hi @lpktysack
what kind of notes do you want to migrate? Sticky notes fromt Apps 9 to IFS Cloud?
Hi Isy,
we want to migrate notes from our CRM system into IFS, so no sticky notes.
Best regards,
Andreas
Hi @lpktysack,
the are two problems in this case:
ROWID and CLOB are data types which you can’t use in the migration tool and a known limitation, only NUMBER/VARCHAR2/DATE are valid data types.
By the way: ROWID is a valid datatype in Oracle.
For your example you can use the procedure BUSINESS_OPPORTUNITY_API.Write_Note_Excel__ but keep in mind that you only have 4000 characters available for your notes field.
I hope this will solve your problem.
/Jens
Hi Jens,
we will test that tomorrow. The limitation to 4000 characters is known and no problem.
Best regards,
Andreas
Hi @lpktysack,
the are two problems in this case:
ROWID and CLOB are data types which you can’t use in the migration tool and a known limitation, only NUMBER/VARCHAR2/DATE are valid data types.
By the way: ROWID is a valid datatype in Oracle.
For your example you can use the procedure BUSINESS_OPPORTUNITY_API.Write_Note_Excel__ but keep in mind that you only have 4000 characters available for your notes field.
I hope this will solve your problem.
/Jens
Hi @Jens,
your solution worked fine for us.
We have to import/migrate the opportunities first and then use BUSINESS_OPPORTUNITY_API.Write_Note_Excel__ in a second update migration job.
But this is absolutely fine for us.
Best regards,
Andreas
