Data Migration

Hi All,We're developing a excel migration job for creation of parts.We're using ENG_PART_MASTER_SEQ.NEXTVAL in this job.We would like to see in the excel migration job what the number is.So,  if we want to use the part after creating the part with the migration job, we don't have to search in IFS to find the created part_no.Any idea's how to manage this?   

Hello Community,I am attempting to migrate code parts in the Authorizer Assigning Rule (view name: AUTH_ASSIGN_RULE_CODEPART1) using the Data Migration Manager.However, I'm encountering the following error:Method NEW failed: ORA-01400: cannot insert NULL into ("IFSAPP"."CODESTRING_COMB_TAB"."ACCOUNT")This is despite the account being present in the legacy file, mapped, and transferred to Deployment.Note: I successfully migrated the same file using the INSERT_OR_UPDATE Migration Job, but encountered the same error mentioned above when using CREATE_TABLE_FROM_FILE and MIGRATE_SOURCE_DATA.Has anyone experienced this issue before and can offer assistance?Thank you 

Hello,Anyone knows how to capture the actual receipt date of inventory when the opening balance migration is doing for Apps 10? 

Our customer uses excel-addin for creating and updating parts. We are trying to figure out what flags creates new records and what flags updates existing record from the excel. Is there a simple explanation? For example I get that is you create a new Part no there is a new record and of you add a new site to an existing Part no it will create a new record. So basically, are all P and K flags creating new records or is it all M flags as well?  Hope you understand my question :) Best RegardsEmma

Hello, I need help please. I created a mapping to mass import serial objects with an Excel file, I managed to get all the desired fields working except for a "Belongs to Object ID" and I don't understand why this field doesn't start working. update when I insert a new serial object. I modified the "Flags" several times but it didn't change anything. *I specify that this field contains a list of objects already existing in the database Thank’s 

I want to change the Responsible field and export it to IFS, but it doesn’t work. Has anyone made this change before?orCan we add different columns in MS Project add-in?

HelloCan we create a shortcut keys for windowsI mean if we press Alt + C then a customer order window will open, and so on Or press F10 then  a customer order window will open.Thanks. 

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: