Data Migration

Hi,We have a requirement to create Functional Objects via Migration Job.  The job should also insert Belongs to Object and Contract.In Cloud, while creating Migration Job (tried with Excel and Migrate Source Data) on EQUIPMENT_FUNCTIONAL, the columns SUP_MCH_CODE (Belongs to Object) and SUP_CONTRACT (Belongs to Site) not at all visible in Column mapping.We tried using modify Method to update these columns, but still it is not updating and Migration Job ending with an error as belowAPI Methods used: EQUIPMENT_OBJECT_PARTY_API.Modify__ Also used this method, EQUIPMENT_FUNCTIONAL_API.MODIFY__ , but in both cases it ended with same errorError:ORA-06550: line 1, column 43:PLS-00225: subprogram or cursor 'MODIFY__' reference is out of scopeAny thoughts or idea really helpful on thisThanks,Nishith

I want to map IFS FSM Stock table with IFS Cloud, Which IFS View\Table would be appropriate. Please suggest.

How to migrate customer order and customer order lines using MIGRATE_SOURCE_DATA procedure?I tried to separately make a task to migrate an order and another to migrate a line and I keep getting an error.  

I tried to upload an external file to IFS, but encountered an error. When I enter the figures in the amount field, the upload is successful. However, if I enter the figures in the currency amount field, I receive the following error: ORA-20110: ExtCheck.VOU_NOT_BAL: Voucher 28-AUG-24 is not balanced in accounting currency.How can I resolve this issue?

Hi all, this is on IFS EE Apps 10 Upd 20 for the Report in Work Order screen. I’m updating an existing Excel migration job to include the new fields Cust Warranty Claim, Output Type, (Note ID?), and Notes.. which has involved adding in 3 more views. WORK_ORDER_RETURNS_UIVWORK_ORDER_RETURNS_UIV_CFVJT_TASK_UIVDOCUMENT_TEXTI’m able to take the existing ‘Work Task’ lines and create the ‘Returns’ lines via the job and the Cust Warranty Claim field populates fine. However, the Document Text (Output Type and Notes) is not populating. When I remove the “On New Master” checkbox under Method List, I get an error that the NOTE_ID field is mandatory. However, I can’t figure out how to have this field autogenerate the value like it would in the GUI.. I’m at a loss and am hoping for some help for this rookie… I’ve included screenshots of everything I’ve got. Let me know if additional info from me is needed, I really appreciate any i

Hi, I am currently looking to understand how IFS loads data into the system incrementally during data migration. You have to think about IFS as a whole system not just a strict set of components. For the TEST-A-REST data sampling, the data can be pushed into a QA cloud environment which has inspired this question. Is is possible to determine a load order from the IFS oracle tables which must adhere to table constraints and foreign key understanding. I understand that generally; CustomerSuppliersParts  Have to be loaded into the system before orders can be migrated in to avoid cascade errors. Is it possible to understand a loading order for IFS oracle table names based on the above information?? I need a full list of IFS oracle tables in the correct order which will allow data to be loaded without any cascading errors occuring.

Is there a screen I can go to in cloud 23r1 where I can get a list of all configured views we have in our environment ?I am looking for a list of views themselves.

Hello,  I have a question please about the inventory migration. I hear about “NREC” to migrate inventory. Can you explain how it works ? Is it a type of external voucher ? Best regards

Hello,  We are migrating from 7.5 to cloud, We have tax transactions that are not reported yet, How to migrate those tax lines ? Do you have any example of the file to use ? Best regards.

can somebody help me with load template for user and person for IFS cloud. 

Hi,We are in the middle of IFS 9 to Cloud upgrade and testing to make sure our Migration Jobs still work in IFS Cloud.We have a migration job in Apps 9 to migrate Supplier data to related screens and tabs. This job isn’t working in Cloud and throwing this error:Reliability_Status and Reliability_Status_Db are new columns added to Supplier → Address screen | Document Tax Information tab in Cloud, so we went ahead added both columns to our migration job and set default values. However, the issue persists.Wondering whether anyone has seen the same issue migrating Supplier data into Cloud before?

Hello Ifs communityI have created migration job to load data in Part Based tab for sales price list page.Lines are inserted but when i want to deleted or updated it i get this errorAnd when i try to modify one column of this line insert through migration job i had this error message :but I have no problem deleting or modifying manually created lines. I only have this problem for lines loaded via data mig job.This is my migration job source mapping : thank you in advance for your help.  Regards.  

How do I go about finding a report that lists the last time a part number was sold. Keep in mind there will be a lot of them. This would be for IFS 10 App

Is it possible to Update the Profiles and Business roles for the user using Migration jobs ? Thanks in advance./Thean

Hello IFS Community, im fairly new in the IFS world, i’m using the DMM tool, we are cloud 24R1 and im trying to migrate suppliers, when adding the Invoice setup into the IDENTITY_INVOICE_INFO table, im getting the following error for all my records“INVOICE_PARTY_TYPE_GROUP validation failed”i know the Group im using exist, but i still don't know what am i doing wrong…your help will be truly appreciated      

Hello everyone, I have do difficulties wih invoice migration in IFS, I have question about the VAT lines. Question about the migration of customer or supplier invoices with VAT already declared Is it necessary to use an extra-accounting migration account? Use a specific account? Example for a customer invoice of 1000€ excluding VAT and 200€ VAT declared For the product part, it's clear to me that you need to use a migration account that must be balanced with an analytical p&l.The third-party account will balance the balance account.What should I do with the tax line? My current scheme is as follows: Debit 411 - €1200 Credit 9701 - €1000VAT?                         200€ on which account in general? For invoices with undeclared VAT, should I use the same tax codes as the customer currently uses?  Or Use an external voucher for VAT lines?  

HelloCan we use the Development Tools to create new window, Master and details for Aurena  

Hi all, i want try to set to active customer schedule agreemant via migration job, but still im getting the same error message.ORA-20115: CustSchedAgreement.The "Cust Sched Agreement" has already been removed by another user. Could somebody help me where could be the problem please? Thanks.there is my migration job: 

Hi,When trying to setup connected environments in Data Migration Manager, I cannot see the Database Link Name. We have created database links from the production environment to the other environments and we can see the links in the database link view/table using PL/SQL. It looks like you can only see the database links in the frontend if you are using the IFSMIG (the view has a where clause) but not sure how I can login using the IFSMIG service account. Can anyone help?

Hi Admin team, Since the beginning of this year, all the contents of the posts on the community have been blocked for me. They are covered by block of plain colour patch like purple. Not sure whether just me get this issue or same to some of the members. Is this issue related to expiry of my membership or not? 

As I’m learning Data Migration Manager I have created a few projects. For a couple of them, while Mapping Legacy Tables to Migration Object there has not been any Target Tables available in the Smart Mapping assistant and I have had a hard time figuring out why. Am I missing any setup? What are the requirements for Target Tables to be available for Smart Mapping? 

Hi experts, What is the process if I want to deploy multiple times from the same legacy source in Data Migration Manager? 1st data.ID, nameA aaB bbC cc Transfer and deploy these. 2nd dataID, nameA aaB bbbbD dd(A is unchanged, B has been renamed, C has been deleted and D has been added). Transfer to input container is OK.When transferring from the input container to the output container, I think that if the first data remains approved, B will not be changed and C will be subject to deployment again.If I want to deploy multiple times, do I have to manually delete the data in the output container?What is the correct process flow? Thank you,Eri

Hello,I have created a CLU with a number of persistent fields.  I am trying to create a running total of one of the persistent fields but not having much luck.This is what I have so far, what am I doing wrong please ? Want to achieve the following : 

Hi, We have requirement to create Work Order and Work Task using Create Table from flat file and then MIGRATE Source Data.We are able to create the Work Order but unable to get the WO_NO (system generated) in order to create the Work Task. There is no getter function to get the WO_NO in ACTIVE_SEPARATE_APIAny help would really appreciated.Thanks,Nishith

I validated the Basic Data while transferring it from the Input Container to the Output Container, and also by the options available in the Output Container. I know that US is a Country Code transferred to the Basic Data Container, still the message is Validation Failed for Country DB. Shouldn’t it be validated Ok? Am I missing any steps?View in Output Container