Solved

Excel-migration does not support calls to methods?

  • 14 December 2021
  • 5 replies
  • 215 views

Userlevel 3
Badge +4

Hi!

Is it so that Excel-migration does not support calls to methods? Just supports Views and modify/insert?

I would like to use Issue Inventory Part -method through Excel-migration. Do not ask why:) In Apps 10 the issue method includes a BOOLEAN-parameter, so we needed to create a new method with VARCHAR2-parameter. The new version works ok with normal migration, but Excel-migration just gives error: "Error in executing job XXXXX".

I am suspecting that Excel does not support calling methods?

I tried to do the easiest possible to prove my point:

 

Debug-file did not really help me to figure out what is the problem.

 

Using Apps10 Update 10 and Excel-mig's Build Date is 2020-11-17.

regards,

Harri

icon

Best answer by dsj 15 December 2021, 07:18

View original

This topic has been closed for comments

5 replies

Userlevel 7
Badge +20

Hi @Harri Viitala 

 

Excel Migration supports methods. I see that you have not provided a view in the header and that could be the problem.

Here’s an example migration job setup using a method

Use the base view of the package and in the action select NoExecution for the New Modify.

Add your method as seq 20

Ex:

 

Cheers!

Damith

 

Userlevel 3
Badge +4

Thanks Damith!

I did it like this, but it still does not work:

Is there something I am missing? I just added the Seq 5, maybe I should redo the whole job from the beginning?

 

regards,

Harri

Userlevel 7
Badge +20

Thanks Damith!

I did it like this, but it still does not work:

Is there something I am missing? I just added the Seq 5, maybe I should redo the whole job from the beginning?

 

regards,

Harri

I think you better do it from beginning :)

 

 Here’s my source mapping looks like if you are wondering. I included the columns in the base view to get the input from excel since then I don’t have to worry about the data types and column descriptions. 

 

Cheers!

Damith

Userlevel 3
Badge +4

Damith, you know what? It worked! Thanks a million!

 

Userlevel 7
Badge +20

Damith, you know what? It worked! Thanks a million!

 

Nice to hear :) good luck!