Skip to main content

Data Migration

This will include topics related to data migration.

  • 615 Topics
  • 1,520 Replies
615 Topics
G
Sidekick (Partner)
GaSoGBSidekick (Partner)
asked in Data Migration
IFS Cloud 24R1 - How do you access IALs outside IFS for Data Warehouse/Data lake purposes

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.

1892
K
Do Gooder (Partner)
J
Do Gooder (Customer)
japaukDo Gooder (Customer)
asked in Data Migration
IFS cloud, Data MigrationManager

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

2022
J
Do Gooder (Customer)
gegrno
Sidekick (Employee)
gegrnoSidekick (Employee)
asked in Data Migration
Please load a migration job to sheet appear in IFS 24R2SU1

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

361
gegrno
Sidekick (Employee)
Z
Do Gooder (Partner)
ZinTDo Gooder (Partner)
asked in Data Migration
Migration User - PreferredLanguage

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. 

532
Z
Do Gooder (Partner)
H
Do Gooder (Customer)
HoustonHockyMonDo Gooder (Customer)
asked in Data Migration
Potential Bug in DMM - 24R2 - Load Legacy Data from Server

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.

411
H
Do Gooder (Customer)
E
Do Gooder (Partner)
ERSADo Gooder (Partner)
asked in Data Migration
About DMM's environment settings

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 CloudThe 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.

500
E
Do Gooder (Partner)
J
Do Gooder (Partner)
jdelormeDo Gooder (Partner)
asked in Data Migration
MDW - Master Data Workbook

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.

220
J
Do Gooder (Partner)
C
Sidekick (Partner)
CSGarethFSidekick (Partner)
asked in Data Migration
Migration Project Template files

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

4966
A
Do Gooder (Employee)
W
Do Gooder (Customer)
wnaylorDo Gooder (Customer)
asked in Data Migration
Is there a database link between two related/opposite inventory transactions?

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

280
W
Do Gooder (Customer)
J
Do Gooder (Customer)
JWieczorekDo Gooder (Customer)
asked in Data Migration
Call external API with Workflow

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?I can not find any guide how to go further with this topic.Is it possible to do the thing I want with the Workflows or maybe there is any another better way to solve this? We are using 23.2.9 Cloud Version Kindly thank you for reading my question.

670
J
Do Gooder (Customer)
H
Do Gooder (Customer)
HoustonHockyMonDo Gooder (Customer)
asked in Data Migration
24R2 DMM Template Project File

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

870
H
Do Gooder (Customer)
Kusal Gunathilake
Do Gooder (Partner)
Kusal GunathilakeDo Gooder (Partner)
posted in Data Migration
Create Migration Jobs to Update Custom Fields(CF)

 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: Source Migration (MIGRATE_SOURCE_DATA)In this scenario, we are trying to migrate data into two custom fields created for the Part Window. The key identifier for this migration is the Part Number (PART_NO).In the CSV (Excel) file, three columns are defined as follows: Create the Migration Job:In the Database Information section, include both the migrated file tab

6230
Kusal Gunathilake
Do Gooder (Partner)
msurasky-price
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration
Excel Addin in IFS Cloud, "Result Column" Issue

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 experienced this behavior, and if so, can you tell me what can be causing this? Thanks!

831
M
Hero (Employee)
Kusal Gunathilake
Do Gooder (Partner)
Kusal GunathilakeDo Gooder (Partner)
posted in Data Migration
Create migration jobs to update custom fields.

In Progress….RCE_DATA (Source MJ)

961
M
Hero (Employee)
J
Hero (Customer)
JannetteCHero (Customer)
asked in Data Migration
Data migration to a custom field using a custom logical unit

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

912
Grzegorz Byrski
Hero (Employee)
ctnmtomasek
Do Gooder (Customer)
ctnmtomasekDo Gooder (Customer)
asked in Data Migration
Migration job - how to pass OUT attribute from procedure as input for Insert to view

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. 

340
ctnmtomasek
Do Gooder (Customer)
P
Sidekick (Partner)
PJIFSSidekick (Partner)
asked in Data Migration
Data Migration

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

280
P
Sidekick (Partner)
R
Do Gooder (Customer)
ronDo Gooder (Customer)
asked in Data Migration
IFS Data Migration Tool Future

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.  

6325
Rifki Razick
Hero (Employee)
P
Do Gooder (Customer)
paulyb36Do Gooder (Customer)
asked in Data Migration
Implementation

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? 

652
P
Do Gooder (Customer)
J
Do Gooder (Customer)
JAKSTEFREDo Gooder (Customer)
asked in Data Migration
Excel Add In Automation / Templates

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

1184
J
Do Gooder (Customer)
B
Do Gooder (Customer)
BaptistPDo Gooder (Customer)
asked in Data Migration
IFS - SAP Migration

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.

580
B
Do Gooder (Customer)
msurasky-price
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration
Where can I see Migration Progress in Data Migration Manager?

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 Migration Manager and now it seems that all that functionality is lost.Is there any place were we can find something similar? Although the “Background Jobs” screen let me see that a migrat

280
msurasky-price
Sidekick (Customer)
A
Do Gooder (Customer)
ashokvankaDo Gooder (Customer)
asked in Data Migration
Mass customer Project Approval

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.

693
Jens
Hero (Employee)
msurasky-price
Sidekick (Customer)
msurasky-priceSidekick (Customer)
asked in Data Migration
Data Migration Manager fails to enter UoM

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.

1093
NiyomalN
Hero (Partner)
T
Do Gooder (Partner)
TheanDo Gooder (Partner)
asked in Data Migration
Migration Job Using procedures

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

1786
NiyomalN
Hero (Partner)

Badges

Show all badges
Terms & ConditionsCookie settings