Migration Job Using procedures

Hi Community, 

I want to create a migration Job which calls the procedure Confirm_Alternates from Engineering Transfer_API view.
 

The Parameter Structure_rec_ is a variable for the above procedure
 

Can anyone help me on how to use this as a parameter in migration job?

Best Regards,
Thean

@Thean  since the structure_rec is  record type i dont think that you will be able to call this procedure directly.  is it possible to find a prior method which calls this method ?  

if you can give more data about what you are trying to do from the front end i might be able to help you  :).

I'm not sure about the functionality what you are trying to simulate from the front end.

Kind Regards!

Niyomal.

Hi @NiyomalN ,

Appreciate your quick response!

My actual requirement is, I want to create a Migration Job for the screen: “Engineering Revision Transfer Work in Progress”.

In the migration Job by passing the parameter Site and Job_Id, I want to set the status “Confirm”.
 

Please let me know if you have any queries, hope you can help me out of this.

Thank You
Thean

@NiyomalN , Yes It worked for me!!

Thank you for helping me on this.

Best Regards,
Thean

Hi @NiyomalN ,

I want to update the employee status from ** to * (Active).

Could you please let me know which procedure should I use ?

Thanks,
Thean

Sorry I just saw this,

to activate employees we need to add a new record to the EMPLOYEE_STATUS_DETAILS tab  :). create a job and add the record there. 

Kind Regards!

Niyomal.

Hi ​@NiyomalN ,

I Want to migrate the Unit costs value in Inventory Part. Could you pls help me out to identify which procedure to be used?
 

Thanks in advance,
Thean

Hello ​@NiyomalN 

Thanks for your answers. 

In general, I have a question about understanding something. With migration jobs, I can call up some methods such as Activate__ or remove__ or build__ etc.  In other words, the methods that end with a double underscore. And they work pretty well.

However, there are also procedures such as those above or here:

PROCEDURE Copy_All_Part_Manufacturers --> You can find these under the Supplier for Purchase Parts / Manufacturer tab. 

My concern is how to incorporate these types of procedures into the migration jobs. Could you help me with this?

I would like to do it in IFS CLoud

solved: PURCHASE_PART_SUPPL_MANUF_API.Copy_All_Part_Manufacturers 
and fetch the 3 Keys:

Contract
Vendor_no
part_no