Data Migration

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! 

Is it possible for the receive_customer_order XML file to contain multiple orders?  From the same customer or from different customers?

Hi All,I would like to know what is the best way to move an External File Template from one environment to another ( Ex. STG to CFG) in IFS CLOUD 23R1? Thank you!

Dear IFS Community;Does anyone know how to import field Phone for a Lead with a Migration Job?I don’t understand why this field is not available in the File Mapping tab for BUSINESS_LEAD view (same issue with Mobile or Email).I try to add manually a field named "PHONE", no error on the execution but it’s not working. Missing Fields in the File Mapping tag for BUSINESS_LEAD viewAdd field PHONE manually (not working)If someone have a solution to this it’s will be very helpfull.Thanks

I am getting this error on a migration job.  I have refreshed the dictionary cache and that did not help.  I am currently on Apps 10 Update 16.

I’ve created an Excel migration job to modify values on a Sales Price List, but it seems that each time that I execute the job, a new record is created instead of updating the record that already exists. For this particular migration job, there will never be a requirement to insert new values, only update existing.   Any ideas what I am doing incorrectly? Environment: 23R1 SU 1 Source Mapping:Method List Attributes: 

Hi,We are looking into different options for migrating data from external systems into IFS Cloud. It is my understanding that the recommended approach is to use the Data Migration Manager component to import data into IFS Cloud via flat file.We are expecting to import a huge number of records into IFS and we are looking for an alternative to flat file import method due to performance impact. Are there any other options for migration? (e.g. external database connection) If not, are there plans on improving this feature in the near future?Any insights will help. Thanks!

Hi Acquisition value was done with process import even this was a new asset. There is a acquisition value but when running the depreciation proposal there is no value. Can we cancel this import?

Hi,I am trying to run a migration job to import a large number of test points and parameters on functional objects. I am experiencing two issues:1. Testpoints: for some reason I cannot migrate into the custom fields I have set up on Testpoints (EQUIPMENT_OBJECT_TEST_PNT). Any idea’s why the migration job will not let me migrate into my persistent custom fields?2. Parameters: When I run the second method of my migration job (EQUIP_OBJ_PARAM), it updates the Parameter for the Default testpoint not my newly created Testpoint. Anyone had a similar issue or

Hi,Does anyone have a migration job or script for mass uploading documents, images into IFS? Instead of having to do it one by one using “Upload Document” screen

Hi All,We are Migrating Employee Records using DMM. As per requirement we would need Person ID to be generated automatically if person id in legacy data is blank, in case if any person id provided in legacy record, then DMM shouldn’t generate the ID. We have enabled Auto Generation feature for Person ID column in PERSON_INFO target table. It is working fine where Person ID is blank in legacy records, but it do generate ID for records where Person ID is not blank. Any feature available to restrict generating the ID incase legacy record have any value passedThanks,Nishith 

Hello, We’re getting errors when trying to migrate the Procurement Clause Connection Rules in 22R2, using FNDMIG. We’re getting errors not wanting a value for Connection ID, but when left null, we’re getting an ORA:00936 missing expression error. Data inputs without error manually. Has anyone  come across or found a fix/work-around for this?  Any help is very much appreciated! 

Hi,I need my mig job to update null values against a custom field since we inserted the wrong values against it the first time around.I have put the default value as NULL against the custom field in the mig job but it isn’t updating it