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
Did this topic help you find an answer to your question?
This topic has been closed for comments

5 replies

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • dsj
  • Ultimate Hero (Partner)
  • 855 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
1 person likes this
  • H
    Harri Viitala
H
Sidekick (Employee)
Forum|alt.badge.img+7
  • Harri Viitala
  • Author
  • Sidekick (Employee)
  • 26 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)
  • 855 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)
  • 26 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)
  • 855 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
H
1 person likes this
  • H
    Harri Viitala
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