Data Migration

While working on migrating data out of IFS, we have noticed that ProjectTransactionSeq does not seem to be indexed in Apps10 UPD20. Is there some reason for excluding this key value from being indexed? Or is the idea to use some other value that is actually indexed? P.S. We are on Managed Cloud Services, so supported by the IFS Cloud.

It appears the Excel Migration procedure in Data Migration in IFS Cloud 23R1 no longer supports migration into Custom LU’s. This was always possible in Apps 10. This is a very useful piece of functionality that should have been uplifted. Does anyone know why this change has been made, and if there is a workaround, without having to resort to CREATE_TABLE_FROM_FILE/MIGRATE_SOURCE_DATA jobs as users will not be comfortable with that?

Anyone have luck using a Post Deployment process to change Routing Alternate or Product Structure Alternate from Tentative to Buildable in Data Migration Manager? I’m trying ROUTING_ALTERNATE_API.BUILD_ in this example. I can’t get it to fire off, no matter what settings I try. The Customer Order Status change is very straightforward in comparison, just requiring the ORDER_NO. I’m wondering if it has something to do with the migration not actually filling anything in for the OBJID or OBJVERSION. No idea what should go in the ATTR or ACTION sections.

In cloud version, cannot create data migration job for custom view. Returning “custom lu views are not supported” error. Any idea?

We found and issue while attempting to migrate PROD_STRUCTURE rows using the Data Migration Manager. In essence, once we reach the Deployment Container screen and when we click on Deploy, nothing gets deployed. Even worse, there is no error message or anything to indicate if the deployment failed or something else is preventing the action to complete. Because a video is easier to show this condition I uploaded this video on YouTube so you can see what exactly is going on. https://youtu.be/5z6YtX-Cz4s Any idea as to what could be happening?

I am trying to create a migration job to migrate custom data from our Apps 10 system to our new CLOUD system. I have set up a number of migration jobs for custom field in Apps 10 and I tried to replicate it in CLOUD, but it did not work. I am trying to find instructions for CLOUD. Does anyone have instructions for CLOUD.

INVENTORY_PART_UNIT_COST isn’t available to search for in DMM and when I try to add it, I get “The View You entered is not a valid view”. Is this a bug or are we supposed to use a different view for migrating unit costs?

I’m trying to migrate some inventory locations into IFS Cloud but seem to come across one issue. But, I can’t figure for the life of my see why it’s happening. This is the error that I’m getting, but every other location with the same location group is working fine. Has anyone else seen this issue and found a solution?

I did it once a while ago but forgot how to do it again. I am looking to extract the navigator items to excel in a format as such: >Scheduled Tasks Conversion 1 MENU >My Administration 1 MENU >My Administration>Basic Data Translation 2 PAGE >My Administration>Notifications 2 PAGE >My Administration>My Tasks 2 PAGE >My Administration>My Lobbies 2 INTERNAL >My Administration>My Industry Lobby Results 2 PAGE >My Administration>Subscription 2 PAGE >My Administration>Subscriptions 2 PAGE >My Administration>Scheduled Tasks 2 MENU >My Administration>Scheduled Tasks>New Database Task Schedule 3 ASSISTANT >My Administration>Scheduled Tasks>Database Task Schedule 3 PAGE >My Administration>Scheduled Tasks>Database Task Schedules 3 PAGE >My Administration>Scheduled Tasks>New Database Task Chain Schedule 3 ASSISTANT >My Administration>Scheduled Tasks>Database Task Chain Schedule 3 PAGE >My Administration>Scheduled Tasks>Database Task Chain Schedules 3 PAGE

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… I’m clearly missing something, but I don’t understand what. Why is it failing on Basic Data when the target environment DOES have that Basic Data available?

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 NowEnd Sub The main purpose its to automatically mark duplicated values in the excel report Thanks for your help!

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 MCH_CODE, src.DATA48 AS SUP_CONTRACT,

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.

Hi IFS Community! Upon running the Excel-Add In for Data Migrations on IFS Cloud for a specific job in Production, we get "Unexpected end of JSON file" with no further information as to why this is happening. We migrated the same data to a different environment last week (CFG) with NO errors whatsoever, so we know that the data we are migrating is not the issue. We checked permissions for the user running the migration and it all looks fine as well. Any ideas what could be causing it?

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 character Tried 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 The Database Links will be created to environments sitting under PROD. There will be no Database Links created to PROD, and that is why it normally should sit in the Installed Environment.