Data Migration

I’m trying to test AccountSet (GET) API IFS Cloud Demo environment as follows. Im able to retrieve the bearer token using following IAM client but once I pass the bearer token to the API it gives me following error. Appreciate if you can help with resolving this error. {    "error": {        "code": "DB_ACCESS_ERROR",        "message": "Database access error. Contact administrator.",        "details": [            {                "code": 20105,                "message": "ORA-20105: Login.FUSRNULL: The directory id XXX is not allowed to run the application."            }        ]    }}

Hi, I have a migration job created to insert Material Requisition Lines, but I got below error. wondering how to fix it?ERRORBelow is my File Mappingincluded “P” and “K” fields Execution 

The Migration Job has a Schedule function, which I have not used before.Could someone who is familiar with this function explain to me how to use it and what its benefits are?Best Regards,Kanokkan

Hi everyone, I am trying to import CONFIG_SALES_COMB_VALUES table into IFS via DMM. The table has SEQUENCE_NO column which is used to order different combination values. Records are ORDER BY SEQUENCE_NO ASC and they are imported from smallest to largest sequence.  So, I would expect to see 8 records, and they should be displayed in correct order. However, only 6 records are displayed in IFS in different orders.  Please help!

Hi, Please could you assist me, we have a factory at work, and we need to be able to display statistics on screens, (multiple screens) without using separate log ins. We don’t need any access to anything other than the data for the lobby view. Is this possible please?

I am getting the following message when trying to complete an existing migration job Any help please

We are using the Migration Toolkit (mtk tables) to migrate from a legacy system to IFS Cloud. All is going well except for the material value of components issued to shop orders. For a given component, it can be issued to multiple shop orders at different values. The mtk lot serial table and the mtk material tables have fields for inventory value but what we put in these fields is ignored. Regardless of what we do, components are issued to the shop order using the inventory value on the inv part. Does someone have a process for migrating wip value when the component’s value can be different on different shop orders.

I get this error while running post deployment for CONFIG_PART_SPEC_REV. The post deployment is to update STATE from TENTATIVE to RELEASED.  error message: “IFS Web Version: 24.1.19.20251203093724.0Date: 2026-01-22T23:10:12.216Z---------------------------------------------------------------------------DeploymentContainer/Form (server error)Database error occurred. Contact administrator.Error details: [{"code":24344,"message":"ORA-24344: success with compilation error"}]Request Id: 721528be-1c67-4cf6-8eca-54fdaa496069Url: https://{}/main/ifsapplications/projection/v1/DeploymentContainerHandling.svc/PostMigrateDataCommit---------------------------------------------------------------------------”  

Hi, we have recently implemented IFS Cloud 24R2. In other words, we are quite new to IFS.It is important for us to be able to easily create Manual Vouchers in GL from an Excel template. External Vouchers and CSV files are not enough. We need to see any errors directly in the Excel document.Has anyone managed to use Excel Migration Job for this? 

 Hi everyone,I am working on a migration job where I need to copy the Functional Object from one site to another. The object id, site name changes; but the overall structure remain identical to the source site.I am attempting to use EQUIPMENT_OBJECT_UTIL_API.Copy_Functional_Object  in method list. However, I am unable to Copy the functional Object. I could have used only the EQUIPMENT_OBJECT_API to insert new one. But I also wanted to copy spares, Test points & Parameters, attributes from the existing one. So using “copy functional object” method.    I am even trying to pass the values from 1st method into the second one in Method List attributes. Any guidance on this procedure handling is greatly appreciated! Thanks in advance.​@dsj ​​@Jens

Hi.We’ve created a quick report to fetch some specific data and we’re hoping to schedule said report to run on a weekly basis and e-mail the file to a specific person.I have IFS_ALL permissions as the scheduling user.The report query is as follows:SELECT DISTINCT A.*, B.CF$_CC_SUPPLIERFROM PROD_STRUCTURE_CFV AINNER JOIN MULTI_LEVEL_STRUCTURE_CFV B ON A.COMPONENT_PART = B.COMPONENT_PARTWHERE A.QTY_PER_ASSEMBLY = 1 AND A.PRINT_UNIT = 'm' AND A.CONTRACT = 'ULV'AND B.CF$_CC_SUPPLIER = '5808'The report itself executes just fine within Cloud, and we can manually export the resulting data, but when we try and schedule it, the background job ends in an error. The errors listed in the Background Job details are as follows:ORA-31011: XML parsing failedORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_RPI", line 305ORA-19202: Error occurred in XML processingLPX-00007: unexpected end-of-file encounteredORA-06512: at "SYS.XMLTYPE", line 272ORA-06512: at line 1ORA-06512: at "IFSAPP.QUICK_REPORT_TEMPLATE_R

Good morning,How can I configure file imports from a specific location, e.g., a network directory, using external file transactions in the IFS CLOUD system?I assume that I have a .csv file in a specific directory and the system has a schedule for reading the file from that directory.I am considering this in the context of currency imports and wondering whether it would be reasonable to use the file reader mechanism in this case.

Hi,I would like to import Quick Reports from IFS8 to IFSCloud.Importing a single XML file is successful. Is it possible to import all reports at once? For example, by packing XML files into a ZIP file?Thank you,Tomasz   

Business Case:We have some migration jobs we want to run once a year. (some year incremental/YE jobs).In IFS we can schedule migration jobs, but only days, weekdays or interval of seconds,minutes, hours. Solution:We would like to be able to schedule on the first day of the month or year. 

In the master part we are migrating 25.488 as the net weight for one of our parts. Somewhere along the line, it was changed to 25.488581893. Given the high number of decimal places, I suspect an automated calculation or a UOM conversion is at play.I tried to recreate this by creating a new part and going through all migration jobs but had no luck. I don’t believe this was changed manually by anyone although it's not off the table.I should note that this is only affecting a small portion of parts.Any ideas? 

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 

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.