Data Migration

HI Im creating a job in app9 to read in a purchase order through migration job, which calls many methods. What every method is surposed to do is: -Create a part & supplier for Purchase part via assortment if Part does not exists on the site -Create purchase order header-Create Custom tab “retail info” -Read in data in CF in retail info -Create line(s) in Extension table “box lines” on Po-Read in data to a Cf on box lines tab on PO-Create multiple charges (per line) -add a history loggingthe only method that is not working is method 32 RETWHO_PO_BOXES_CFP.Cf_New__I get an issue when trying to insert data into the CF on RETWHO_PO_BOXES stating: ORA-01400: cannot insert NULL into ("IFSAPP"."RETWHO_PO_BOXES_CFT"."ROWKEY")when i compare th

How to execute a IAL view/ quick report and export its out put to file location?I know we have two migration tools in IFS cloud 24 R2. Data Migration and DMM. I see the options to do that using Data Migration but I don’t have access to it. Not sure if it has to do with licensing. However, I have access to DMM. How to achieve this task using DMM? I used DMM for importing CSV files and move the data from source to target tables. Any thoughts on this would be helpul.

We have developed a CRIM for a customer for Spend Analysis of suppliers. it is a localization requirement. Where each supplier get points if compliant. We have migrated the Suppliers, the challenge is that each supplier has a Compliance certificate which needs to be attached to the Supplier record in IFS Cloud. Does anyone has any idea how to migrate Documents in IFS Cloud? 

The customer environments had been upgraded from 25.1 (unknown SU) to 25.2.3.I was going to import a migration job that was previously used in the project and imported several times without problems. The import was done using the standard job FNDMIG_IMPORT and suddenly it went wrong with error message ""The uploaded CSV is malformed". Investigation showed that the export file for the migration job contained the character ", a double quote, which caused the issue.The double quotation was used to restore a text, where double quotation had been replaced by something else in the data export. The double quote was replaced by CHR(34) and then the job was imported successfully.

Hi, Im trying to setup a migration job to update our supplier statistic groups. I cannot figure out why I get the error - ORA-20114: SupplierInfo.FND_MODIFIED: The Supplier Info record has already been changed. Please refresh the record and reenter your changes.I received the error in both INSERT_OR_UPDATE and also EXCELThe view Im using is - SUPPLIER_PURCH_SRM_INFO_CFV  

Looking for some help with the Data designer.Are you able to put a join in on the Definition Screen. If so how.Or how can we use the data source from a quick report    

Hello,  When I am doing excel migrations with rows more than 3000 (ish), I get an error when validating or executing.  “The argument is invalid or missing or has an incorrect format”When I select smaller amounts in chunks, everything validates/executes fine.This is very inconvenient when there are 10000s of records. takes forever to do in chunks. has anyone encountered this issue? Any knows fixes?Thank you,Kalindu 

We are on IFS Cloud 25.1.2.  Microsoft just forced updated Office to 2507 (19029.20136) which broke our IFS Excel add-ins.  Users that stayed on 2506 are still OK.Issue is, when you click login, the add-in panel briefly flashes and does not bring up the login window for IFS cloud.Anyone else have this issue? 

Hello, Currently, IFS provides pre-built reports that are hosted in a data lake.My question is whether it is possible to create a dashboard that retrieves and combines data from two different semantic models—for example, integrating Sales and Inventory data into a single report or dashboard.Do we have any existing solution, standard approach, or built-in capability that supports this type of cross-model reporting? 

Hi all,I am getting below error when migrating data to ORDER_QUOTATION_LINE using FNDMIG job.Even when there is a value assigned to the field ‘BASE_SALE_UNIT_PRICE’ i get this error.Have you experienced this before?Any ideas or thoughts on how to resolve this would be much appreciated!“ORA-01407: cannot update ("LORA1APP"."ORDER_QUOTATION_LINE_TAB"."BASE_SALE_UNIT_PRICE") to NULL” Thank you!Disna M.

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 processing

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 

I did it once a while ago but forgot how to do it again. I am looking to extract the navigator items to excel in a format as such: >Scheduled Tasks Conversion 1 MENU >My Administration 1 MENU >My Administration>Basic Data Translation 2 PAGE >My Administration>Notifications 2 PAGE >My Administration>My Tasks 2 PAGE >My Administration>My Lobbies 2 INTERNAL >My Administration>My Industry Lobby Results 2 PAGE >My Administration>Subscription 2 PAGE >My Administration>Subscriptions 2 PAGE >My Administration>Scheduled Tasks 2

Hi,I would like to know how I can send an excel business report from IFSAPP 10 to SharePoint. I am using Power Automate for this. I want to know how to send an excel file to Power Automate when sending POST JSON request using Power Automate API. I have the Power Automate API. Just want to know how to add an excel file to JSON payload. is it possible to convert BLOB to   Base64 ? Thanks,Sachini

Hello everyone!Right now I need to figure out a way to convert date that will come through the Oracle Service Bus and create an automation with select or PL/SQLso that I can specify the automatic conversion of any topology of their network.Let me know if any other information is required.Kind regards!

What would cause the send log to display a less quantity than what has been authorised for payment? 

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

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

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?

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!

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 together,we are currently in an Upgrade Project to 22R2 and we want to migrate Notes.We found the topic Job migration of Business Opportunity - Note issue | IFS Community but when we enter the method BUSINESS_OPPORTUNITY_API.Write_Note_ in the Method List of the Mig Job we get the following error. So we checked the API in PL/SQL Developer and saw that the datatype for rowid_ is ROWID. This seems wrong.Does anybody have the same issue? Do you know how to fix that error?