Data Migration

I have a Basic Data Table called COMPANY_FINANCE. One of the fields is CURRENCY_CODE and it is validated against an environment we have called STG. When I validate basic data on COMPANY_FINANCE I get an “Error, Basic Data” message and upon inspection I see that “ISO_CURRENCY validation failed, basic data target table cannot be found” The ISO_CURRENCY table on STG does have a value for USD… so it should NOT fail…  

Hello all, I’m trying to upload some data into IFS Cloud CFG and have come across an error message that I can’t figure out the cause of.  It says the following:ORA-20124: Error.NULLVALUE: Field [MAPPING_TYPE] is mandatory for Payment Address and requires a value. If any of you have come across this before and found a solution, your help would be greatly appreciated! 

Hello everyone and thanks for reading me. I currently have some quick reports that are scheduled to be sended to coworker emails with an excel file (from a query). Its there a way to add VBA code to the excel attached like the following: Sub Sample()   Debug.Print Now   Dim ws As Worksheet   Dim wsTemp As Worksheet   Set ws = Sheet1   Set wsTemp = ThisWorkbook.Sheets.Add   ws.Columns(1).Copy wsTemp.Columns(1)   wsTemp.Columns(1).RemoveDuplicates Columns:=1, Header:=xlNo   If Application.WorksheetFunction.CountA(ws.Columns(1)) <> _      Application.WorksheetFunction.CountA(wsTemp.Columns(1)) Then       Debug.Print "There are duplicates in Col A"   Else       Debug.Print "duplicates found in Col A"   End If   Application.DisplayAlerts = False   wsTemp.Delete   Application.DisplayAlerts = True   Debug.Print

Hi, I’m migration Parts with Serial Nos into Inventory Part in Stock table in IFS using Data Migration Job. But my Part & Serial Nos are not reflecting in Part Serial screen. But if I create them manually, they reflect in Part Serial screen. How can see them in Part Serial screen using Migration Job?

Hi,We are currently exploring a solution for one of our clients in the Defense sector.They aim to secure their Sensitive Data on IFS Cloud while ensuring compliance with ITAR regulations, especially in terms of Data display and access (e.g., Parts, Suppliers, etc.).Do we have an integrated solution in IFS to manage Sensitive Data and ITAR requirements, or do we have any references or documentation on how we can address this type of issue? Thanks in advance!

Hello All,We have a lot of Migration Jobs, and we want to migrate all of them in a new IFS Cloud environment.Are there any ways to accomplish this at once? Can we make a Migration Job for this task? Thank you for your help.

Hi,Is it possible to create multiple lines in the output files.  The csv file gets like this. I want it to be like this I was referring to other community posts. But did not manage to get it correct

I have a question about the Additional Deployment Process functionality in Data Migration Manager projects. In short, is the functionality even implemented correctly in 24R2 or am I wasting my time in trying to get this to work? I’m trying to migrate the EQUIPMENT_SERIAL object and eventually update the hierarchy. For performance reasons, the EQUIPMENT_OBJECT_SEQ field is auto generated and in the hierarchy, based on the SUP_CONTRACT and SUP_MCH_CODE fields, the FUNCTIONAL_OBJECT_SEQ (others also) is updated. Thought I could implement a Pre Deployment process of type UpdateMissingKeys to retrieve the Sequence from the database but it’s not working. The SQL that I would guess would be generated as the basis of the deployment would be the following using the EQUIPMENT_OBJECT_API.GET_EQUIPMENT_OBJECT_SEQ method as the basis to get the key. The SQL works so I’m guessing that DMM in 24R2 is completely foobared.SELECT  src.DATA1 AS CONTRACT,        src.DATA2 AS MC

Hello,I created a custom projection. I added Entities but from the allowed operations, I could only select READ.What do I have to change to also select CREATE, UPDATE and DELETE?Thanks, Golo 

Hi All, How do you normally access IALs in IFS Cloud 24R1 Production environment from outside IFS for Data Warehouse or Data Lake requirements.I assume you use IFSINFO - ReadOnly user to access database directly but I would like to know your experience on this.

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.