Data Migration

Hi,We need to import Recurring Services using DMM. I’ve imported into recurring_service_program, recurring_service_scope and recurring_service_trigger. But in the Recurring Service Program screen, there is no data in the Scope tab and in the Item Information section of the General tab the Location is populated but the Model, Object and Object Site fields are empty. I can create Recurring Services from the front end and then data in the Scope tab is populated so it looks like I’m missing something with the migration. Are there more tables that I need to include to link the Object to the Recurring Service?All help appreciated. 

Hello Community!I’m writing today because I have noticed that, when I attempt to migrate Posting Control headers (POSTRING_CTRL) using Data Migration Manager, nothing seems to be migrated even though the tool seems to disregard or swallow the exception preventing the row to be inserted. Let me describe my problem in detail, hopefully you have seen this before:I tried to create an Inventory Positing Control for Location Group. That is, posting Type M1 (Inventory) and Control Type C83 (Location Group). I first tried to create it manually (just to make sure the row I’m testing works fine when using Aurena) and it worked well… I can insert this posting control using AurenaI proceed to remove this “test” Posting Control to prepare the system to receive the DMM data.Then I created an extract to generate EXACTLY the same thing in DMM and confirmed all the steps went as expected (from Legacy to Input, from Input to Output, from Output to Deployment and then Approve record and Deploy with Commi

I’m trying to insert new Equipment Objects (View Name: Equipment_Object) which have three object levels — Operation, Area, and Local Area. All of these represent functional objects.For linking purposes, I’m assigning the fields Sup_Contract and Sup_Mch_Code with the parent’s contract and machine code values. To display & link them correctly in the Equipment Object Navigator as a tree structure, I set the default value of Functional_Object_Seq as:EQUIPMENT_OBJECT_API.GET_EQUIPMENT_OBJECT_SEQ(SUP_CONTRACT, SUP_MCH_CODE) However, when I select and execute all three levels together (using Excel migration), they don’t seem to link up but all the objects are being created. After reloading data in excel, the fields Sup_Contract, Sup_Mch_Code, and Functional_Object_Seq appear as NULL. Interestingly, when I execute each object level individually, the hierarchy and tree structure display correctly on the screen. The values for the fields Sup_Contract, Sup_Mch_Code, and Functional_Object_Seq 

Hello;        I’m new to IFS & I’m quite surprised at the difficulty there is in changing a unit of measure. I’m a designer, & a portion of my former company was acquired by another who uses IFS. In the process there was a lubricant that got transferred & the unit of measurement was a pail. I’m not sure what the correct unit is but that wasn’t the unit it was supposed to be. Instead of being able to correct the unit, my main division of the company is saying the only thing we can do is create a new part no. with the correct unit of measure. This lubricant is used all over the place in 103 boms & 93 drawings which would have to be changed. Is this a limitation with IFS, & if it is, why would it be. I believe with our former system using CMS, we would have just revised the unit, & been done with it. I should add, it has already been used which seems to make it more of an issue.Thanks for any input in advance. SonDrum

I want to change the Email Addresses in a event action Type E-Mail with a pl/SQL script.I found the function FND_EVENT_ACTION_API.Modifyand prepared the Parameter: Client_Sys.Add_To_Attr('ACTION_PARAMETERS', rec_.new_param, attr_); But unfortunately it is not working. There is no error message but the text is not changed.Can somebody help me?

Hi, I have IFS Enterprise Explorer 10.5.8.0.I want to receive Purchase Order into stock using API in SQL.Do You know which API should I use, and what’s the easiest way to do that? Thanks for help.

Dear Sir/Madam,When I press the login button in EXCEL Add-in, the login screen does not appear.Can someone tell me how to solve this?

Hi,I recently got a new 25R1 repository in IFS Scope Tool and I downloaded the 25R1-Data Tracker Template File.What I found is that values are missing in Basic Data sheet - column K (Global/Company/Site). This is very valuable information for us since we are going to implement IFS to a multi Country/Company solution.Also we are also missing the entire Master Data Tracker sheet.My question is if there will be a second release of 25R1 Data Tracker Template including the missing values and the Master Data sheet?Kind Regards,Christian 

Hello everyone,I'm trying to migrate customer orders and customer order lines. Everything's working fine, no problem. However, I'm trying to migrate the CODE_C of the lines using another job for pre_accounting, and retrieving the pre_accounting_id of a line, but I get an error I don't understand: ORA-20111: Site.NOTEXIST2: The Site object does not exist.Strange, because in the job, this indication does not appear, and only the pre_accounting_id seems mandatory.   How can I make these jobs work easily? 

I’m getting this error when trying to migrate data to a Custom TAB. ORA-02291: integrity constraint (IFSAPP.C_PART_INTERCHANGE1_CRK) violated - parent key not found Method List Attribute Source mappingNote: I tried to retrieve the objkey from the parent container and set it using the source mapping, but I'm still getting the same error.Any idea how to resolve this? 

We are trying to change tax code for some purchase order lines with no no part and getting the below error when running the migration job ,is there any other way to update this field please   

Problem:I have a lot of instant invoices to make. So I made a few migration jobs to assist with this. I can create a header, add lines, add tax lines, this all goes well.There are 2 problemsThe account isn't set when creating the line There's also supposed to be postings created in the background, these are not created and I can't really find a way to create them. There's a Create_postings function in the INSTANT_INVOICE_API, but it's private, so you can't use it outside it's intended purpose. I've looked past many INSTANT_INVOICE related API packages, but I can't find how to trigger the create posting method. Does anyone have experience with this specific topic?

Hi,Our requirement is to add products to a contract so that we can schedule regular and ad-hoc servicing of the products.We have imported Request Contracts and Equipment Objects but would like advice on how to import Contract Lines to link the Equipment Objects to the Request Contracts. It looks like we need to import to psc_product_service_item and psc_contr_product but I feel that there is more to it than this.Any help much appreciated.

In the migration job function, I am getting the following error in EXCEL_MIGRATION for “CUSTOMER_ORDER_LINE” view.I have confirmed that deleting some columns in the source mapping tab resolves the error, but do you know of a way to resolve this without deleting them?- IFS Cloud 25R1 

We are trying to migrate Approved suppliers but the default status after the data migrated is set to not approved , I am trying to change the status to “ Approved “ using the below method name but getting the error saying this list doesn’t exist ,is there a source to show valid “method name” for API’s please to make this sort of changes  

Hello, I want to insert new part_no in view ENG_PART_REVISION through excel data migration, but it retrieves error: ORA-20111: EngPartMaster.FND_RECORD_NOT_EXIST: The Engineering Part Master does not exist.  How can I solve it?

Hello Everybody, we are trying to run a fairly simple Mig Job,  we are getting the following error message Start time - 24-OCT-2025 09:26:59   HFI_ENG_PART_ACTIVEError in  select   - ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table End time - 24-OCT-2025 09:27:00   HFI_ENG_PART_ACTIVE  Here is the Query we are running:  SELECT OBJID, OBJVERSION, 'DO', ROWID FROM ENG_PART_REVISION_REFERENCE WHERE State='Preliminary' ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved tableLength of statement : 121 characters Here below you will find a few screenshots of the Job itself, im fairly new at Mig Jobs and overall IFS, i have not been able to figure this out out. any help would be appreciated.   

Hello everyone, I hope you're all well!I'm starting to learn how to do a data migration in IFSCLOUD and I'd like to know if anyone has a step-by-step manual for importing data using an Excel spreadsheet.Thank You

I made a mistake when creating the product structures and set them to ‘Build’. Now I want to change the status back to ‘Tentative’. Is this possible?I need to do this because I also want to delete the part number, which is incorrect.Is there any way to do this?

Hi, Is it possible to modify the DEF_ADDRESS in the customer_info_addess_type using data migration ? When i try, i have this message: ORA-20112: CustomerInfoAddressType.FND_RECORD_EXIST: The Customer Info Address Type already exists.

Hello, I would like to know whether there is a functionality to “delete” data by using data migration:Let me explain:Data has been integrated in IFS using data migrationThe client wants to delete and update a new list of data. Is it possible to “delete” data by using data migration. Thanking you for your feedback.

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

Hi,I wan t to call a custom event action using a migration job. I am loading data from a file to IFS system using migration jobs after that I want to execute a custom action using a migration job. Can anyone help me by mentioning the steps for this?Thanks,Sachini

Hello,I’ve created a Migration job for importing new service resources in Cloud. By baseline, while creating a New Service Resource, it automatically creates a Maintenance Employee record and assigns it to the Service Resource created.But while creating a Migration job, the Maintenance Employee record is not created. Also the Resource Connection with the Company and Site are not setup properly.Below is the Method List used to create Service Resources and Connections. What could be the possible reasons? Any inputs would be appreciated.Kind RegardsPriyanka Cecilia

I'd like to know how to register new customer order headers and line items in the same migration job.I have tried this and confirmed that adding CUSTOMER_ORDER and CUSTOMER_ORDER_LINE to the "Method List" tab allows me to update them all at once. However, when I try to insert both the header and line items, I get the error "DEVELOPER_ERROR_03: Most likely a usage definition is wrongly defined for LU: [CustomerOrder] in table RM_ACC_USAGE_TAB, internal exception: [Ex_Get_Id]."