Data Migration

Hi all,What are the options in migrating the counted qty using any migration method in IFS?I tried FND_MIG jobs with different procedures, but the issue is that I do not see the field (COUNTED_QTY) in the view INVENTORY_PART_PICK_SHIP_STOCK. What is needed here is to update counted_qty field.IFS Cloud 23R2  Thank you! 

Hi,We have imported several thousand Request Contracts using DMM. They are at status ‘Planned’ and we want them to be Active. Is there any way that we can automate making these Active? Presumably we need to update objstate and/or state fields on sc_service_contract but these fields don’t seem to be able in the mapping. 

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

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?

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.

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   

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

I’m not sure what’s going on but I have the projections for my migration job granted to the permission set that I need them granted to as well as permission for FND_ADMIN, and FNDMIG_EXCEL_ADDIN and I’m still getting this error in my production environment. I have less permissions granted in my test environment and it’s loading with no issue. I even imported the permission sets from my test environment to prod and it’s still giving me the error. Any help is appreciated.    

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

I am looking for a way to update Safety Stock, Planner, or any parameters in the inventory part screen. I would like to enter these changes in Excel and mass upload them to IFS 7.5 for now. We migrating to the cloud in January but, I would like to make this mass change in IFS 7.5 for now. Thanks in advance. 

What are some of the methods to export the photos in the Attachment DB in MWM as a file?

Hi All,I’m trying to create a data migration job for the Product Structure Header.When the structure type is ‘Manufacturing’ and if the record is already exists, I get an error ‘ORA-20112: ProdStructureHead.FND_RECORD_EXIST: The Prod Structure Head already exists.’ I have enabled modify option but it’s not letting me updating the record.I would really appreciate it if there’s any other ways we can try to make this work, please. Already tried to get the idea from the below post and unfortunately it didn’t work for me.Create Migration Jobs to Update Custom Fields(CF) | IFS Community also tried the bellow API call in objid fieldINTFACE_METHOD_LIST_API.GET_OBJID_FROM_KEY('PROD_STRUCTURE_HEAD', 'CONTRACT;PART_NO;ENG_CHG_LEVEL;BOM_TYPE_DB', CONTRACT||';'||PART_NO||';'||ENG_CHG_LEVEL||';'||BOM_TYPE_DB||';')Thank you in Advance!

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]."  

I’m new to IFS and currently exploring the Excel Plugin in V8 and the Excel Add-in in IFS Cloud.I successfully created an Excel migration job for the COUNTING_REPORT view (Count Report Transaction), exported the data, made necessary changes, validated and executed the job using the Excel Add-in. The changes were reflected in IFS as expected.However, when I followed the same process for the COUNTING_REPORT_LINE_EXTENDED view (Count Per Count Report Transaction), the changes did not reflect in IFS after execution.Could you please advise if there are any specific steps or configurations required for the physical inventory process when using the Excel Add-in with this view? Is there a limitation or approval workflow that I should be aware of?Thank you for your support.Best regards,Gowtham

Hi Everyone,In Cloud 25R1, we have 10 companies in one instance, and we are in a process to migrate/carve out one company (for ex: Company A) to a fresh instance and to remove that company (Company A) data from the existing instance.Is there an easy way to achieve this? your suggestions will be very helpful.And an easy way to know the list of screens/tabs which has that Company (Company A) data to be carved out.In other words:Is there a method to get a list of screens pertaining to the company that should be taken into consideration when carving off a company from our current instance and inserting it into a new instance? 

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.   

I want to know how to get the Sales Price List by API. When registering a Customer Orders in the migration job, I want to use the API to retrieve the sales price from the sales price list. Because the migration job does not appear to be referencing the sales price list.

Here goes a question for all of you who have some expertise deploying containers in the Data Migration Manager (or experienced in any type of migration tool with PAYMENT_ADDRESS as the destination).I’m trying to understand why, upon deploying PAYMENT_ADDRESS, I get the following error:Method NEW failed : ORA-20124: Error.NULLVALUE: Field [MAPPING_TYPE] is mandatory for Payment Address and requires a value. I am providing a value for MAPPING_TYPE as you can see in the screenshot:Error on Data Migration Manager. Notice the field has MAPPING_TYPE has data! I tried changing the value of mapping type to other values to see if that could be the reason (I tested with values such as “CHK” or “PAYMENTADDRESS”) but I always get the same error.I tried to insert manually and it seems to work.Entering the data manually seems to workIn this post (https://community.ifs.com/data-migration-333/data-migration-payment-address-56748?tid=56748&fid=333) I see someone reported something similar and the q