Skip to main content
Solved

BUSINESS_OPPORTUNITY_API.Write_Note_ error in Mig Job

  • December 13, 2022
  • 5 replies
  • 177 views
L
Do Gooder (Customer)
Forum|alt.badge.img+3

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

Best answer by Jens

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

View original

5 replies

L
Superhero (Customer)
Forum|alt.badge.img+23
  • Link
  • Superhero (Customer)
  • 1169 replies
  • December 13, 2022

Hi @lpktysack 

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

Kind regards
Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Jens
  • Hero (Employee)
  • 123 replies
  • Answer
  • December 13, 2022

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
Do Gooder (Customer)
Forum|alt.badge.img+3
  • lpktysack
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • December 13, 2022
Link wrote:

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
Do Gooder (Customer)
Forum|alt.badge.img+3
  • lpktysack
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • December 13, 2022
Jens wrote:

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
Do Gooder (Customer)
Forum|alt.badge.img+3
  • lpktysack
  • Author
  • Do Gooder (Customer)
  • 6 replies
  • December 14, 2022
Jens wrote:

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

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