Data Migration

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,

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

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!

How to execute a IAL view/ quick report and export its out put to file location?I know we have two migration tools in IFS cloud 24 R2. Data Migration and DMM. I see the options to do that using Data Migration but I don’t have access to it. Not sure if it has to do with licensing. However, I have access to DMM. How to achieve this task using DMM? I used DMM for importing CSV files and move the data from source to target tables. Any thoughts on this would be helpul.

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

We are on IFS Cloud 25.1.2.  Microsoft just forced updated Office to 2507 (19029.20136) which broke our IFS Excel add-ins.  Users that stayed on 2506 are still OK.Issue is, when you click login, the add-in panel briefly flashes and does not bring up the login window for IFS cloud.Anyone else have this issue? 

We are trying to migrate Open stock  which I am trying to do using migration job , the data is loaded successfully and can see it under “Inventory Parts in Stock “, what are the next steps to transfer the balance to GL please? I am trying “ Transfer Inventory Transactions “  option but I can’t see any transactions generated ,is there a step in between I am missing here to generate the inventory transactions so that they can be transferred to GL? I can’t see any data under Inventory transaction history as well so looks like I am missing a step here  

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.  

Hi,I recently got a new 25R1 repository in IFS Scope Tool and I downloaded the 25R1-Data Tracker Template File.What I found is that values are missing in Basic Data sheet - column K (Global/Company/Site). This is very valuable information for us since we are going to implement IFS to a multi Country/Company solution.Also we are also missing the entire Master Data Tracker sheet.My question is if there will be a second release of 25R1 Data Tracker Template including the missing values and the Master Data sheet?Kind Regards,Christian 

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

Hi.There’s an existing thread on this with a fix here, but following it I was unable to get the migration job working and I’m still receiving the same error. We’re aiming to update only the CODE_F field with a migration job, but running the MIGRATE_SOURCE_DATA job after the CREATE_TABLE_FROM_FILE results in the ORA-20111: Site.NOTEXIST2: The Site object does not exist. error for every line in the file. As  mentioned in the post above, I’ve attempted to add the CONTRACT field into the file mapping, but sadly it has not solved the issue. Any help here would be appreciated.  

We have an existing migration job that worked until Update 20 was applied. The job adds lines to a sales quotation. Now the lines are added successfully only for rows where the customers price list has a value in the Discount Type field for the part in question. The job looks like this:The error returned is “Field [DISCOUNT_TYPE] is mandatory for Order Quote Line Discount and requires a value.”. The migration job doesn’t currently include a method list entry for the Order Quote Line Discount view so it isn’t possible to add a default value for this field: What we would like is to be able to add a default value if there isn’t one on the price list. Is there a way of doing this?

Hi all.My client is upgrading fron IFS App 10 to IFS Cloud 24.2.In IFS Apps 10 they share the consults that are saved with others users and it is a good functionality for them. They asked me if this functionality is allowed in Cloud and I do not find anything related to that.So, is it possible to share the bookmarks? I’m not meanning to export/import functionality between profiles but share the bookmark when you set it up.

Hi All, I’m having an issue with migrating persistent custom fields using the data migration manager. Seems like the objid and version in the deployment container is not passing even if I set it to in scope and  set auto generated flags on.in the deployment container it doesn't show the generated objid and version once the master record is deployed. this is related to part catalog (master part). master record deployed correctly but not the custom fields.  am i missing anything here or do we have any issues migrating custom field data using the DMM ? IFS cloud 24R2 Kind Regards!Niyo 

Hi.We’re hoping to create an OnServer CREATE_OUTPUT_FILE type migration job that would return all active employees in our organization, including the address data for their listed company work locations. Work location data already exists in the table, but the address data for the work location doesn’t. This is a copy of an older migration job that returns other employee results, and based on that I’ve created a SELECT statement in the File Mapping tab as follows: (SELECT ADDRESS FROM IFSAPP.PERS_COMMS4 WHERE COMPANY_ID = IFSAPP.COMPANY_PERSON.COMPANY_ID AND PERSON_ID = IFSAPP.COMPANY_PERSON.PERSON_ID) With this query, the job runs but returns only partial results and the following error: ORA-01427: single-row subquery returns more than one row As I understand it the Address field is a concatenation of multiple Address fields (Address1, Address2 etc). Is there a viable workaround this issue due to the nature of the Address field?I’ve also attempted a JOIN clause in the Database Informat