Data Migration

Just starting out with DMM in IFS Cloud 22R2. I need to pull data from two tables into one target table. The documentation indicates how legacy tables are joined is important but gives no information on how to do this.Somehow this worked when there were two legacy tables with the same key simply by identifying the keys on the Legacy Table definitions.In this new situation, there are three tables involved and I need data from tables T1 & T3. T1 and T2 have the same key. I labeled them Key 1 & 2.T2 and T3 are linked by a different field. I tried labeling these as Key 3, but that did not work.Is this possible to do and if so how?  

I’m executing a loader job via OnServer route and once I select the file from the SFTP Server, getting an error “Invalid value for property “IntfaceFile””. Any suggestion on the reason of this error and how to fix it.Thanks

I am trying to import supplier records into my IFS8 system using xml files generated by an external system. The xml files are supposed to be using utf-8 encoding. However, because some of the records are generated from Korean and Ukrainian sources, not all the characters are utf-8 despite the xml referencing <?xml version="1.0" encoding="UTF-8"?>. As a result, when the connector reader gets the xml file, it reports:com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.And the file is not processed any further.Sometimes the control characters will clobber the xml tags, which nullifies the entire file structure.Aside from forcing the sender to reformat the data, is there anything I can do in IFS to compensate for the bad characters when the connector reader tries to pick it up?Here is an example of one of the bad xml files opened in notepad++. 

Hi expertsWhen i try to login into the Migration excel add inI always get into this login mask    can i somehow access the system with the migration tool as an admin with the following loginscreen? I allready tried to enter the Admin URL but i always get an error message​​​​

Hello,I am using an external Excel/CSV file as a source, imported by the user into a specific IFS repository. After importing and retrieving the data, I need to store it in multiple IFS tables.Could you please provide guidance on how to achieve this?

Any one know how to download docker container and heml chart for AirGap installation for IFSCloud 23R1?Where should i find the “download.sh” file?  ./download.sh -u your_username -p your_password -j jfrog_artifactory_url -r x.y.z --ifs-helm 

Hello want to build migration job wich based on the service resource assistant creation. The reousrce will be based on existing person and resource group. Is it something we can do by using the API method ? and if yes where i can find list of method of this API or have acces to the view.New service resource creation 

I am looking for a way to run a replication job for Inventory Parts from Contract A to Contract B. However, I want to change the value of a few fields when it goes to Contract B. Overall, we are changing to streamline our part creation process and one of the challenges we have faced was trying to replicate 80% of the inventory part into a new contract, but there are few value changes. Example would be Inventory Part Planner 17 for Contract A = Inventory Part Planner 20 for Contract B. Is it possible to change values of certain fields through the replication job? 

Hello IFS Community, I hope you're all doing well. I'm currently in the process of evaluating cloud services for our IFS (Industrial and Financial Systems) implementation, and I wanted to reach out to this knowledgeable community to gather insights and recommendations on the criteria we should consider when making this important decision. Choosing the right cloud service provider is pivotal to the success and efficiency of our IFS deployment. Here are a few questions and criteria I've been pondering: Scalability: How well does the cloud service provider accommodate the scalability needs of IFS as our business grows? What are the options for scaling up or down, and how easy is it to implement these changes?Security and Compliance: What security measures and compliance certifications should we look for to ensure that our sensitive data and operations meet industry standards and regulatory requirements?Performance and Reliability:

HI All,I got the below situation recently for a customer environment in IFS Cloud 23R1. I  had only CUSTOMER_INFO and CUSTOMER_INFO_ADDRESS target tables were marked as ‘In Scope’. When clicked on Expand Scope by Target Table's References One Level, it was taking long time and hung up.Have anyone of you experienced this ?Do you know any particular reason for this and how to overcome this issue?  Thanks in advance!  

 During the installation of version 1.2.0, we encountered an issue with the delivery process known as the 'Delivery Not in Sequence Error'. It appears that the delivery order was not completed correctly. I have attached a screenshot for further information.  

How to find the LTU user list? Who should import the licenses to the application?  Migrated from IFS 9 to IFS cloud through DB upgrade all the users are also active without importing  new license key, if there is any additional users are requested by customer, so do we need to get the new license from IFS and what is the process of this? what are the steps which we needs follow to import the new license key in IFS cloud instance which will be issued by IFS, NOT able to find import option in the system. 

Hello All,I'm looking for guidance on how to update a custom field in IFSAPP9 using an Excel Migration job. While I've created several migration job in the past this is the first one I'm creating that requires me to dump data into a custom field. The Custom field Is named HB_Origin. when looking at the debug console I see that IFS use the OBJID to update the field. How can get the OBJID from the Part_No the end user enters?  

Hello, I need to run a data load for the General Ledger . and i get the error below : The AD user Mapping already addedd :  and i executed  the environment Set up after addinf the AD user Mapping .But i still get the same Error .Need Help Please :) 

Hello!I’m trying to find out why my Navigation Link Command is not taking me to the correct page. The name; CPEGEN_OpportunityLinesList_NavigateToForm(1) is correct but the NavigationToForm(1) is navigating to the wrong page. Is there a way for me to find out why this is happening or a way to configure NavigateToForm(1) to the right page^

Hi Community, I have tried to add the Excel migration Add-in (IFS Excel Add-in - 21.2.0.2) using both Excel windows client and office 365 web client for IFS Cloud. When I click the IFS Excel Add-in icon in the Excel, I am getting the ADD-IN ERROR.For the window client, I have opened the Excel as ‘Run as  Administrator’. so this is not a privilege issue.  Any idea on how to resolve this issue? Best Regards,Kapilan

hiI am looking for some ways how I can create service contracts easily in IFS without manually creating them.I can get service contract on paper( could be hand written) or I can get in excel.  This is kind of urgent. as we have lot of service contract to be created I am trying to see my ways . Appreciate any help/

Hello everyone,I have met one tough problem from time to time. I often need to upload Customers’ Purchase Order into IFS 10. Most formats of theses POs are PDF, and they contain less than 20 lines, in this case, I would upload them into IFS manually. But there are some POs in Excel format and contain more than 100 lines (we can see Sales Part Number, Quantity, Unit Price with Currency, Wanted Delivery Date, etc. In short, all the key information is provided) It may take me more than one hour to deal with it if I choose to set up it in IFS and this is what I did for a several times before. Time-consuming job!!! So, does anyone here know how to do migration job for upload one PO of Excel format containing more than 100 lines one time? Also, does anyone here know how to create a lot of sales parts (usually more than 50) one time? All the sales parts belong to the same product family. A lot thanks.Ple

We are setting up an additional Site within one of our companies, and would like to know if there is a quick way to “copy” from site A to B.  If so, what are the parameters that are copied over?   Thanks DAVE 

Hi All,What are the file size limitations for data migrations? For example, when migrating text and JSON files, are there any specific constraints? Additionally, is there a character code specification and delimiter specification involved ?

Issue I'm using Plsql_Rest_Sender_API.Call_Rest_Endpoint_Json to call rest API service. It works fine for POST and GET, but it does not work for PATCH. I'm getting following error message:ExecutionException from Sender thread Caused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending data Caused by: ifs.fnd.base.SystemException: Patch error: 405 (Method Not Allowed)The same PATCH call works fine from Postman, so there is no issue on receiver side.Product Version: 22R2SU8  Resolution Restarting the ifsapp-connect container will the solve the initial issue. Then you might see the below error,ExecutionException from Sender threadCaused by: ifs.fnd.connect.senders.ConnectSender$TemporaryFailureException: Exception while sending dataCaused by: ifs.fnd.base.SystemException: Patch error: 201 (Created)This happens because b

Hi,I am facing an error “ORA-20105: MaintenanceConnection.INVEQUIPOBJ: The Equipment Object does not exist” when trying to migrate the prepare work order.The object ID, i am using is already available in functional object screen.Data migration screen snap 

Is there a way to export a context and all its configuration from a test instance to PROD?Please advise. Thank you!

Hello - I am trying to create an IAL but it keeps failing with the following (Failed executing statement (ORA-00903: invalid table name).  I can run the same code in SQL developer with no issues, can someone tell me what I am doing wrong please ?

Hi  What permissions do I need to add in order to be able to display all menus of Data Management?Thanks & Best regards!