Solved

BUSINESS_OPPORTUNITY_API.Write_Note_ error in Mig Job

  • 13 December 2022
  • 5 replies
  • 129 views
L
Rank
Badge +2

Hi together,

we are currently in an Upgrade Project to 22R2 and we want to migrate Notes.
We found the topic Job migration of Business Opportunity - Note issue | IFS Community but when we enter the method BUSINESS_OPPORTUNITY_API.Write_Note_ in the Method List of the Mig Job we get the following error.
 

So we checked the API in PL/SQL Developer and saw that the datatype for rowid_ is ROWID. This seems wrong.


Does anybody have the same issue? Do you know how to fix that error?
Thanks in Advance for any help!

Best regards,
Andreas

icon

Best answer by Jens 13 December 2022, 16:04

View original

5 replies

Link
Rank
Userlevel 7
Badge +22

Hi @lpktysack 

what kind of notes do you want to migrate? Sticky notes fromt Apps 9 to IFS Cloud?

Kind regards
Jens
Rank
Userlevel 4
Badge +8

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

L
Rank
Badge +2

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

L
Rank
Badge +2

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

L
Rank
Badge +2

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

Reply


Terms & ConditionsCookie settings