Data Migration

Has anyone used the IFS Data Migration Manager ETL tool for actual migration projects? I’m looking for feedback on the user experience and the tool’s practical applications. 1of30responses

Hi,After generated new Manifest for IFS Cloud 24R2SU1 i have this message on Excel Migration Jobs, Created in a earlier release of IFS Cloud in Excel  when I select the Migration Job and select Load:“Please load a migration job to sheet appear in IFS 24R2SU1”It have the selected migration job, ref. logs”12:23 - Getting Migration Jobs”, but it does not open it in new Excel Sheet.How can I avoid this and use existing Excel Migrations Jobs?/Geir

Hi,can any one tell me how i can put a default language for my users data migration, because the field PreferredLanguage is not the vue FND_USER ?i made a bpa to update the filed, but when i have more than 20 users i get an error message( i think it’s a limitation of workflows when we have lots of lines).Regards. 

In DMM, I’m trying to load a file from Server and getting the following error. When loading the identical file On Client, everything succeeds so I’m assuming there is a bug in DMM in 24R2. This is the error returned when loading from On Server:Unable to Start LOAD_LEGACY_SER_FILE - ORA20110: DatLegacyDataUtil. LOADFILEERR: Legacy file load error. ORA20110: DatServerFile. NOTABEXT: External Table not created. ORA20110 DatServerFile NOTAB: Table not created: ORA00911: invalid characterTried loading a file with *.csv extension and no extension and the same error incurs. Bug? Me thinks so.

Hi Expert, The DMM documentation says that the installation environment should be PROD, and the reason is that DB links cannot be created to PROD. ・Why can't I create a DBLINK to PROD environment?・Is there a problem with the method of preparing DMM in the TEST environment and then transferring data from the TEST environment to the PROD environment when migrating data?  ーーーーDefine Migration Project - Technical Documentation For IFS Cloud

Is a MDW still maintained? Where can I download the version for 24R2? This toolset is not listed under [https://downloads.axiossystems.com/index.html] even if my profile qualifies for this product.

Is there a defined location where we can get the Project Template files for Data Migration Manager for the latest release?  The training says it is recommended to use them, but as Partners I cant see where we would get them from.There is a topic where someone has kindly shared the files for 22r1 But this is now out of date as 23r1 has been released.It would be preferred if these template files were made available in a known place for Partners so we can use them in our Customer Projects.In the meantime, can anyone share the 23r1 Project Template?Gareth

Hi,Does anyone know where (or whether) a link is recorded between two related/opposite inventory transactions in the database? This is for reporting purposes on stock movements.For example, if I move some stock from one location to another location, two transactions are created: an INVM-OUT transaction at the location the stock was moved from, and an INVM-IN transaction at the location it was moved to.However, I’ve been unable to find anywhere in the database that actually links these two transaction IDs, making reporting difficult when I want to show both the From and To Locations for a single stock movement.Is there a link between these transactions in the database? If so, I imagine this would be stored in a mapping table, but I haven’t been able to find one so far.I’d appreciate any input anyone could provide.Thanks!Wilf

Good afternoon,I want to create an IFS Workflow to check if the Customer Company is Tax verified.Here is the example URL which is working to get the response: https://wl-api.mf.gov.pl/api/search/nip/7791011327?date=2025-01-09I already have a TaxIdNo and Date in correct format:  Now I am trying to Get a Response to handle with the IFS Rest Call: What should I do now to see the full _Response even where I can see the _Response?

Can someone point me to the location of the 24R2 Data Migration Manager Project Template file?

 To migrate data specifically for custom fields, follow the steps outlined below. After experimenting with multiple approaches, I have identified the most effective method for transferring data into custom fields. I hope this guide helps some of you resolve your challenges. As usual, you need to create two migration jobs:File Migration (CREATE_TABLE_FROM_FILE)Create the migration job in the standard manner. There are no special steps to follow for this process. Reference for creating a file migration job: Create File Migration Job.Here is the File Migration job created for this scenario, which you can use as a sample reference:

I have a user on my team that, when opening an EXCEL_MIGRATION job on a spreadsheet, gets the results where the “Result Column” is created but left outside the Excel Table, like this: odd results from the user In spite of that, if I do exactly the same steps this executing, I end up with a table where the “Result Column” is included: it works for meAt first I thought something was wrong with the Job configuration, but having confirmed this cannot be replicated in my computer (and it also worked fine for a 3rd user who tried it...) I am more inclined to believe this is an Excel issue on this user’s machine. Has anybody expe

In Progress….RCE_DATA (Source MJ)

Hi, I am trying to migrate some data into my new custom field.  The custom field is based on a custom logical unit which is referenced.I keep getting the error key violated - I have worked out that the issue is that the custom field _DB column is looking for the obj key or obj id from the custom logical unit - how do I get that please ? Thanks

Hello,I would need to pass OUT attribute from procedure as input for Insert to view.Situation:First method in Method list - C_COPY_SOURCE_ORDER_UTIL_API.Execute_Copy_Source_Order - there is one OUT attribute - in procedure statement it is like:...   C_COPY_SOURCE_ORDER_UTIL_API.EXECUTE_COPY_SOURCE_ORDER(      ifs_order_id_,      new_ifs_order_id_);   --   Client_SYS.Add_To_Attr('NEW_IFS_ORDER_ID_',new_ifs_order_id_,attr_);…I need to pass NEW_IFS_ORDER_ID_ attribute (ID of record created by procedure) as input attribute for “New” (Insert) to view in second row of Method list (this is not related view with procedure in first step - I need only store that ID there).I tried to find some help in documentation, but I was not successful.Could anyone help? Thanks. 

Hi All,We are using apps 10 and need to Migrate Inventory Parts with revisions set at 2 or higher. When we tested this the migration worked however in each case it created a Revision 1 as well as the revision we wanted. As an example we migrated a Part with revision 5, and it created a revision 1 and a revision 5.Is there a way to overcome this and only have the revisions required. Thanks and Merry Christmas

Hi IFS,There is a rumour that IFS migration tool will be removed from future IFS Cloud versions . Could someone verify this ? If yes, would you be able to share the timeline ? Thank you,Rohana.  

Hello, We have started to put the data together for our IFS implementation, but i have some questions that i cannot seem to get an answer from our group. As for maintenance, whats the grandparent/parent/child relation ripples for creating the right object type and those relations? which field labels are the broader items and which are the more machine-specific? How does that relation look in a stair-step map? 

Dear All, we want to use the Excel Addin as Transport Tool to Create or Update Customer Order / Sales Quotation Lines. Now when we use the Excel Add In we have to do the following Steps:1.Open Excel 2 .Open Excel Addin and Login 3. Choose the Migration Job 4. A Popup Window if we want to Load in Same Sheet or in a new SheetWith these 4 Steps we have then the data entry Colums and van work with Search, Validation an Execution.We want to get rid of the Steps 3 and 4. Furthermore we want to Save an Excel with the alrady loaded Data Entry Colums and already Choosen Data Migration Job.  Has anybody an idea if it it possible to do so? As an Alternative we would like to Automate the steps.Any Ideas? Thanks Stefan

Looking for support in migration of data from IFS10 into SAP HANA. Starting from data cleanup all the way into the final migration run. Any support or leads would be appreciated.

Hi IFS Data Migration Friends!In APPS 10, using the migration Toolkit, we had an extremely useful feature available to us when migrating large containers called the "Container Processing Rates" form.In that form you were able to see how the processing of that container was doing, how many rows were migrated per minute and how many errors were generated as the deploy unfolds in real time. It looked like this:I miss my Container Processing Rates features :(For large containers, this was an early warning that we may need to wait for 3 or 4 hours to see this container fully migrated. It would let us investigate some errors while we waited for the migration to complete. It even help us to early-detect a few cases where the migration simply "got stuck" and nothing was moving ahead. Fast forward to the Data Migra

Dear All, We have 1K plus customer projects that need to be migrated to IFS cloud from legacy application. I would like to check with you, if there is any way to mass approve all the projects in a go please ?I would also like to know if there is anyway to update service line information at Pre-Posting tab at finance project level, also code string completion? Appreciate your valuable inputs.Kind regards,Ashok.

Hello Community!Today I’m trying to insert some Units of Measure using Data Migration Manager. When I try to commit my changes, I see the error description “Method MODIFY failed : ORA-20122: IsoUnit.ERRUPDUSED: The field [USED_IN_APPL] is not valid for update for user defined codes.” in those UoM that are user defined.Any ideas how can I approach a solution for this? So far I tried setting the “USED_IN_APP” as “Out of Scope” in the Target Table definition but that doesn’t make any difference.

On our Accounts Payables lobby screen there are 21 invoices showing errors on the final posting proposals page that have been locked in there for years and they will not clear. They are all paid posted, however they all include this error: (Apps 10 EE) We are moving to Cloud in February and have a testing space currently where they also migrated over to this environment. I had read that it could be a bug, but it wasn't the same specific error so i’m not 100% sure. If this is the case and it is a bug, will it resolve itself once we fully transition to Cloud?  

HI, I have been trying to migrate data into the Organisation Units screen and im getting the below error, even though it has a value in the temp table. ORA-20124: Error.NULLVALUE: Field [SUP_ORG_CODE] is mandatory for Company Org and requires a value. select * FROM IFSAPP.IC_BTG_ORG_UNIT_LOAD_TAB Please help?ThanksStacy