Data Migration

I am looking for a way to update Safety Stock, Planner, or any parameters in the inventory part screen. I would like to enter these changes in Excel and mass upload them to IFS 7.5 for now. We migrating to the cloud in January but, I would like to make this mass change in IFS 7.5 for now. Thanks in advance. 

I want to know how to get the Sales Price List by API. When registering a Customer Orders in the migration job, I want to use the API to retrieve the sales price from the sales price list. Because the migration job does not appear to be referencing the sales price list.

Hi All,I’m trying to create a data migration job for the Product Structure Header.When the structure type is ‘Manufacturing’ and if the record is already exists, I get an error ‘ORA-20112: ProdStructureHead.FND_RECORD_EXIST: The Prod Structure Head already exists.’ I have enabled modify option but it’s not letting me updating the record.I would really appreciate it if there’s any other ways we can try to make this work, please. Already tried to get the idea from the below post and unfortunately it didn’t work for me.Create Migration Jobs to Update Custom Fields(CF) | IFS Community also tried the bellow API call in objid fieldINTFACE_METHOD_LIST_API.GET_OBJID_FROM_KEY('PROD_STRUCTURE_HEAD', 'CONTRACT;PART_NO;ENG_CHG_LEVEL;BOM_TYPE_DB', CONTRACT||';'||PART_NO||';'||ENG_CHG_LEVEL||';'||BOM_TYPE_DB||';')Thank you in Advance!

What are some of the methods to export the photos in the Attachment DB in MWM as a file?

I’m new to IFS and currently exploring the Excel Plugin in V8 and the Excel Add-in in IFS Cloud.I successfully created an Excel migration job for the COUNTING_REPORT view (Count Report Transaction), exported the data, made necessary changes, validated and executed the job using the Excel Add-in. The changes were reflected in IFS as expected.However, when I followed the same process for the COUNTING_REPORT_LINE_EXTENDED view (Count Per Count Report Transaction), the changes did not reflect in IFS after execution.Could you please advise if there are any specific steps or configurations required for the physical inventory process when using the Excel Add-in with this view? Is there a limitation or approval workflow that I should be aware of?Thank you for your support.Best regards,Gowtham

Hi Everyone,In Cloud 25R1, we have 10 companies in one instance, and we are in a process to migrate/carve out one company (for ex: Company A) to a fresh instance and to remove that company (Company A) data from the existing instance.Is there an easy way to achieve this? your suggestions will be very helpful.And an easy way to know the list of screens/tabs which has that Company (Company A) data to be carved out.In other words:Is there a method to get a list of screens pertaining to the company that should be taken into consideration when carving off a company from our current instance and inserting it into a new instance? 

Here goes a question for all of you who have some expertise deploying containers in the Data Migration Manager (or experienced in any type of migration tool with PAYMENT_ADDRESS as the destination).I’m trying to understand why, upon deploying PAYMENT_ADDRESS, I get the following error:Method NEW failed : ORA-20124: Error.NULLVALUE: Field [MAPPING_TYPE] is mandatory for Payment Address and requires a value. I am providing a value for MAPPING_TYPE as you can see in the screenshot:Error on Data Migration Manager. Notice the field has MAPPING_TYPE has data! I tried changing the value of mapping type to other values to see if that could be the reason (I tested with values such as “CHK” or “PAYMENTADDRESS”) but I always get the same error.I tried to insert manually and it seems to work.Entering the data manually seems to workIn this post (https://community.ifs.com/data-migration-333/data-migration-payment-address-56748?tid=56748&fid=333) I see someone reported something similar and the q

Hi everyone,I need to replace a large number of skills on standard tasks, but doing it manually is not feasible. I tried using Excel Migration, but I encountered an error and it seems this method might not be supported for deletions.As an alternative, I’m considering uploading the new skills in bulk and removing the old ones. Does anyone know how to properly remove skills using Excel Migration? Any guidance or examples would be greatly appreciated.Thanks in advance!Best regards,Stefania 

Hello everyone, I want to update the supplier association number using a data migration job.I have identified the relevant package to use: Supplier_Info_General_API.Modify__.When I call this package through a PL/SQL script, it works as expected and successfully updates the value.the package is called by the crud_update method :supplier_handling_svc.crud_update(                '*',                v_supplier_id,                'ASSOCIATION_NO' || chr(31) || v_association_no || chr(30),                'DO',                supplier_info_general## => ''            );However, when I run the same operation through the data migration job, no changes occur. Any idea why please?The select statement generated by the datamigration job do return the correct value : Datamigration Job Details : The ATTR_ value used is :  'ASSOCIATION_NO'|| chr(31)|| IC_I_SUPP_ASSOC_UPDATE_TAB.association_no|| chr(30)

Hi,I am using Data Migration Manager.An error message is generating in the Deployment Container:Template: CUST_ORD_CUSTOMER_ENTError: Field [RECEIVE_PACK_SIZE_CHG] is mandatory for Customer and requires a value.RECEIVE_PACK_SIZE_CHG is not in the Target Table Definition, but RECEIVE_PACK_SIZE_CHG_DB is.RECEIVE_PACK_SIZE_CHG_DB is not mandatory.Has anyone previously come across this and found a resolution?

Hello, I'm Markus and I'm new here in this community, and this is my first post.One of my tasks is to prepare the master data from the old ERP and migrate it to the IFS cloud. Of course, a lot of mapping is necessary, as we don't have this many columns and tables in the old ERP.I learned from our consulting to use these data migration tools: Migration Job for LOAD and for MIGI have a VPN to the IFS cloud and can select the data VIEWS via ORACLE SQL Developer to reconcile the column names and fields for the migration job files or to build the mapping for this.Is there a best practice for the migration of master datafrom our old ERP to our IFS cloud?Thank you very much for your knowledgeGreetingsMarkus 

What method should I use to change the status Plannable to Tentative? Thanks in advance,

Hello ​@Jens ,I am trying to migrate some data to the Purchase Part screen using Source Migration.I also want to migrate the document text value.Do I need to have a separate job for Document Text?Can you please help me out by providing your suggestion. Thanks,Thean

Hi Community,I was trying to Migrate the Translation for Customs Statistics Number. in screen Basic Data Translation for English and PROG Data will alredy exist.I am trying to migrate the data for french Language via Excel Migration Getting error ORA-20110: BasicDataTranslation.PROGNOTEXIST: Corresponding basic data does not exist for attribute key  Any idea how to solve this error?Thank You

After upgrading from App8 to cloud, the ‘Close Shop’ operation has been changed to ‘Park’. Does anyone have any insights or information regarding this change?

Has anyone seen this error message when loading or validating data for jobs with the Excel addin?  Last week we could load data the COA to the worksheet without error.  This week we are getting the above error for any of the migration jobs.  Office365Aurena  

when using Excel add-in for data work with IFS - I can’t perform any functions in the spreadsheet as the buttons disappear.Does anyone have a solution please?When I first log in - the buttons & mig job tree is available:After the first interaction, say load data - everything disappears: 

I am trying to run a migration job to the customer credit limit table. I am using the excel add-in tool. We have to update some customer credit limits in bulk. The problem is the job keeps telling me that I am trying to update the PARTY_TYPE and that I’m not allowed to. I do not care to modify the party type, as it should remain Customer. I have tried to modify the migration job by eliminating the source code (column) for Party_Type and/or Party_TypeDB, and set up defaults as “CUSTOMER’ and ‘Customer’ and all possible combinations of such. No matter what, the system is convinced I am trying to “update” the party type, when all I want to do is update credit limits. Any advice or resources? This is for IFS Cloud 24R1. I was pointed to IFS Apps 10 - IFS Data Migration Excel Add-in Overview and Demo | GoToStage.com and Excel Migration - Technical Documentation For IFS Cloud for resources, but these have not been able to assist me with this particular issue. Thank you!

Hi, I would like to update the list price in the view SALES_PART with the data migration. When i try, i have the same message on everyline when i launch the MIGRATE_SOURCE_DATA: ORA-20122: SalesPart.UPDATE: Field [CATALOG_TYPE] in Sales Part may not be modified. The value of [CATALOG_TYPE] is ‘NON’. Is it possible to proceed so ? Thank’s Julien.    

Apps 10 update 12:I am trying to load some new Inventory Locations.  The migration job is pretty straight forward, see below.When I try and execute, the first row is successful but second and subsequent rows fail.  The error is:Insert into WAREHOUSE_BAY_BIN_TAB failed - ORA-20112: WarehouseBayBin.FND_RECORD_EXIST: The Warehouse Bay Bin already exists. (Error caused by line: 3)It appears that there is a LOCATION_SEQUENCE which retrieves from a sequence (if the field is empty in the attribute string).  Looking at the output of the failures, it is trying to use the same LOCATION_SEQUENCE value for each record.  Anybody have any ideas or have been successful in data migrating inventory locations?Thanks in advance,Dom

I am using Excel add-in for data migration most of the time no issues.in a few examples i need to do some data retrieval/lookup and have used an expression in the ‘default value’ column in the migration job.However, as yet i am struggling to do the same with a simple SQL select. Is it not possible or is my syntax incorrect. I have no guidance so I am making it up as a I go, I could be doing it incorrectly.I did write a select first in quick reports to prove it was correct, although it is so simple I did not really need to.When I click validate or execute - I don’t get any feedback, (the debug feature does not work) - but if I remove the select my other data updates - so something about my approach is failing. Thank you for any suggestions!  

I’m looking for some sort of materials to get trained on how to use the excel add-in tools for data migration. Would love to learn more about designing migration jobs, setting defaults, strategy, and more. I can’t seem to find anything on Community or Academy for resources. Where do you go to learn?

Hi, I wan’t to update only certain fields (the adresses) of the customer info adress view by data migration. Is it possible ? What do I hace to do to recuperate the other fields that I don’t wan’t to update ?How can I construct the field “Adress” that seems to countains the new address ?Thank’s.Julien.  

Dear Experts, I’m trying to build an Excel Migration job that would need to:create some functional objects - EQUIPMENT_OBJECT_API apply a parameter template after the functional object is created - Asset_Param_Template_Util_API.Apply_TemplateBelow is the Medthod List The problem I have is how to pass EQUIPMENT_OBJECT_SEQ when applying the parameter template.This method expects EQUIPMENT_OBJECT_SEQ which is created by method 10 - EQUIPMENT_OBJECT_API. However it seems that at the point of executing method20 the equipment_object_seq is not available.In Mig Jobs - migrate source data it was possible to set a COMMIT rule - I was thinking if such a thing is possible for Excel migration - for example to commit after each method. Any ideas how I could fetch the equipment_object_seq created through method 10?​@dsj ​@Jens When I try to validate the Mig Job data in Excel I get no result / no error either. When I execute I also get no result. It’s like nothing happens. If I remove method20 and it

Hi CommunityI have created a Excel Migration for Invoice planning screen.I have given the default value for Invoice sequence- Every time when I load the data to excel the field gets too wider, is there any way to adjust the column width in excel and also to remove the timestamp? Thanks in advance,Thean