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
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 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 @KLNADEESH Could you please follow the below community thread and check whether you asking the same behavior?Setting Default Values in Aurena | IFS Community Hi Kelum,can you provide me the “manual” directly because we have no access to “partners-only”-area.Thanks in Advance!Best regards,Andreas
The issue was due to the Archive Expire Days being set to 2000 in Payment Report Definition. Many thanks, this helped me to solve my problem with scheduled reports. Best regards,Andreas
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.