Skip to main content
Solved

Excel-migration does not support calls to methods?

  • December 14, 2021
  • 5 replies
  • 259 views
H
Sidekick (Employee)
Forum|alt.badge.img+7

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

Best answer by dsj

Harri Viitala wrote:

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

View original
This topic has been closed for comments

5 replies

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Ultimate Hero (Partner)
  • 862 replies
  • December 15, 2021

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

 

DSJ - https://dsj23.me
H
Sidekick (Employee)
Forum|alt.badge.img+7
  • Harri Viitala
  • Author
  • Sidekick (Employee)
  • 27 replies
  • December 15, 2021

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

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Ultimate Hero (Partner)
  • 862 replies
  • Answer
  • December 15, 2021
Harri Viitala wrote:

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

DSJ - https://dsj23.me
H
Sidekick (Employee)
Forum|alt.badge.img+7
  • Harri Viitala
  • Author
  • Sidekick (Employee)
  • 27 replies
  • December 15, 2021

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

 

dsj
1 person likes this
  • dsj
    dsj
dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Ultimate Hero (Partner)
  • 862 replies
  • December 15, 2021
Harri Viitala wrote:

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

 

Nice to hear :) good luck!

DSJ - https://dsj23.me
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