Data Migration

Hi All, I’m having an issue with migrating persistent custom fields using the data migration manager. Seems like the objid and version in the deployment container is not passing even if I set it to in scope and  set auto generated flags on.in the deployment container it doesn't show the generated objid and version once the master record is deployed. this is related to part catalog (master part). master record deployed correctly but not the custom fields.  am i missing anything here or do we have any issues migrating custom field data using the DMM ? IFS cloud 24R2 Kind Regards!Niyo 

Hi.We’re hoping to create an OnServer CREATE_OUTPUT_FILE type migration job that would return all active employees in our organization, including the address data for their listed company work locations. Work location data already exists in the table, but the address data for the work location doesn’t. This is a copy of an older migration job that returns other employee results, and based on that I’ve created a SELECT statement in the File Mapping tab as follows: (SELECT ADDRESS FROM IFSAPP.PERS_COMMS4 WHERE COMPANY_ID = IFSAPP.COMPANY_PERSON.COMPANY_ID AND PERSON_ID = IFSAPP.COMPANY_PERSON.PERSON_ID) With this query, the job runs but returns only partial results and the following error: ORA-01427: single-row subquery returns more than one row As I understand it the Address field is a concatenation of multiple Address fields (Address1, Address2 etc). Is there a viable workaround this issue due to the nature of the Address field?I’ve also attempted a JOIN clause in the Database Informat

Hi All,  We are looking to get some basic data setup (Even if it’s just dummy data) in build placeWhen the environment  expires we lose a lot of time setting the basic data up for testing. Does anyone have experience with setting it up so when we build a new environment it already has data. We believe this is possible but we are struggling to get the process set off. ThanksCameron

Hello Everyone,I was trying to upload a user list using the “Insert or Update” procedure with the view name “FND_USER.” The users were uploaded successfully, but the user email and language fields were not included.Could someone please guide me on how to upload these fields along with the other user data?

Is there anyone here that uses IFS and connects it to Salesforce? I have so many questions about this integration and why certain fields don’t map as expected. We are using the Address Type in IFS to map to certain fields in Salesforce based on the Default Address value, but certain records aren’t getting updated as they should. I did notice that some records in Salesforce don't have the document address populated if the Latitude and Longitude in Salesforce doesn’t match IFS but that doesn’t seem to be consistent enough to me. Thoughts on this anyone?

Dear Community, We are looking for an expert in "migration jobs." The goal is to develop a migration process—specifically an "Excel migration"—to generate a manufacturing control plan (header + lines) from an Excel file, which itself is an export of the definition plan.!--startfragment>This approach aims to eliminate manual data entry, thereby reducing the risk of typos and saving valuable time.!--endfragment>!--startfragment>So far, we’ve successfully generated the header of the control plan (seq 10 in the job). However, the task becomes more complex when it comes to generating the individual data points.!--startfragment>Several views are involved in the process, and I’m currently feeling a bit lost navigating through all of them.!--endfragment>!--startfragment>!--endfragment>Has anyone here already implemented a migration job for creating manufacturing control plans (applicable version : 8) ?!--endfragment>!--startfragment>Thanks in advance

Hello, In view ENG_PART_MASTER_MAIN I have column description and I want to create excel data migration, but in this excel data migration i cannot see this column Description, why? I want to add some items with part_no and description. In IFS I added this column but I still cannot see Description in excel.  Thanks

Hello everyone,I'm trying to migrate customer orders and customer order lines. Everything's working fine, no problem. However, I'm trying to migrate the CODE_C of the lines using another job for pre_accounting, and retrieving the pre_accounting_id of a line, but I get an error I don't understand: ORA-20111: Site.NOTEXIST2: The Site object does not exist.Strange, because in the job, this indication does not appear, and only the pre_accounting_id seems mandatory.   How can I make these jobs work easily? 

Trying to migrate customer contacts using FNDMIG and we are receiving the error:   ORA-20124: Error.NULLVALUE: Field [PERSON_ID] is mandatory for Customer Info Contact and requires a value. We are currently using the CUSTOMER_INFO_CONTACT view and CUSTOMER_INFO_CONTACT_API 

Hi Can someone please help me with the following errorDictionary.CLIENTNAME_IS_NULL: Cannot convert the client name [NULL] into a database name.I have refreshed the serve cache also still getting the same error. 

I’m getting this error when trying to migrate data to a Custom TAB. ORA-02291: integrity constraint (IFSAPP.C_PART_INTERCHANGE1_CRK) violated - parent key not found Method List Attribute Source mappingNote: I tried to retrieve the objkey from the parent container and set it using the source mapping, but I'm still getting the same error.Any idea how to resolve this? 

HelloWith the latest version of excel, it seems IFS Excel migration does not work. cloud 23R2 version 

Hello, Test topic, to find out is community works or not. 

Hello,How can i include description header (description of each field instead of column name) on in my datamigration export in csv format ?  

I'm trying to update an existing record for functional objects using the Smart Data Migration Manager (DMM) tool. I've mapped the Equipment Object Seq field to the legacy source, but when I deploy from the deployment container, it treats it as a new INSERT and returns an error saying the functional object already exists.I've included all the configuration details and data in the description. Could someone help me identify what I might be missing or doing incorrectly?Excel Record I’m trying to Update :Legacy Data :Mapping : Deployment Container :Error;  

Hello;        I’m new to IFS & I’m quite surprised at the difficulty there is in changing a unit of measure. I’m a designer, & a portion of my former company was acquired by another who uses IFS. In the process there was a lubricant that got transferred & the unit of measurement was a pail. I’m not sure what the correct unit is but that wasn’t the unit it was supposed to be. Instead of being able to correct the unit, my main division of the company is saying the only thing we can do is create a new part no. with the correct unit of measure. This lubricant is used all over the place in 103 boms & 93 drawings which would have to be changed. Is this a limitation with IFS, & if it is, why would it be. I believe with our former system using CMS, we would have just revised the unit, & been done with it. I should add, it has already been used which seems to make it more of an issue.Thanks for any input in advance. SonDrum

Hi IFS Community!Upon running the Excel-Add In for Data Migrations on IFS Cloud for a specific job in Production, we get "Unexpected end of JSON file" with no further information as to why this is happening.We migrated the same data to a different environment last week (CFG) with NO errors whatsoever, so we know that the data we are migrating is not the issue.We checked permissions for the user running the migration and it all looks fine as well. Any ideas what could be causing it?

Hi All,My requirement is to update the total accumulated depreciation up to the cutoff date during the import process and set the cutoff date as the Thru_Date. Then, when running depreciation using the Depreciation Proposal, depreciation should be calculated correctly only for the period after the cutoff date.

Hi community,in IFSAPP10 I am trying to create new configuration for quotation line with migration job.I checked the configuration form and found these two tables: CONFIGURATION_SPEC and CONFIG_SPEC_VALUE.I used the table CONFIG_SPEC_VALUE as many times as I have parameters in my configuration revision. I am able to create new configuration with this migration job. I can see records in both tabels with new configuration ID, but I am not able to create the record regarding the connection between the new configuration and particular "Order Quotation Line".I found table CONFIG_SPEC_USAGE where you can see the records, that connect configuration ID with another object, but I am not able to use the table/method CONFIG_SPEC_USAGE in migration job. Could anybody provide any suggestions? How to solve the connection between new configuration and other object?Thanks a lot.IFSAPP10

Hello,I am looking to see if there are any column level definitions in any of the IFS documentation for fields like C1, C2 and N1, N2 etc that can be found on tables/views like Invoice_Item_Tab.I found some defitions for Invoice Header and Invoice_Line under the EDI messages page but nothing for the Invoice Item.https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/default.htm?openpage=https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/GeneralIFSApplications/AboutEDIMessages.htm (I replaced our local instance name with xxxxx)Is there a place where I can find these?Thank you

Hello,I am trying to locate some data from the Shipments page in the underlying views/tables but coming up empty. I am looking at Shipment Management > Outbound Shipment > Shipment, general Tab and then Weight.I have the following in there - Net Weight, Adjusted Net Weight,Tare Weight,Manual Gross Weight,Operative Gross Weight,Operative Adjusted Gross Weight. When I look at Debug > Page Info, I am told these are all part of the TotalWeightGroup element under the View Shipment.But when I query the Shipment view, none of these columns exist in it.Where can this information be found in the IFSAPP database?Thank you

Hi,There is a migration job to create or update suppliers. We want to add ‘30’ prefix for the supplier id if the the supplier is a new supplier. I would like to know how we can do this.  we tried to get next supplier id and add ‘30’ prefix in the Method  List attribute as below. but it didn’t work.Thanks,Sachini

We recently found out the External File Assistant has been (or is about to be) deprecated in IFS Cloud.  Is there any information on a replacement for this functionality?  Will that replacement be an additional cost?

Hi Experts, I want to clear existing values in DMM. How should I set it up? Here are some specific examples. I want to update the notes value to blank.Deploying blank data will not update the notes. How do I clear values in DMM?

I am trying to run a migration job to import a large number of test points and parameters on functional objects. I am experiencing the below issue Parameters: When 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 has a solution in IFS Cloud?  I ran migration job for Hours but the system generate and associates the parameter that is created in migration job to the test point id * Default Testpoint (there is no such parameter template). I even tried key manipulation by changing the flag on method EQUIP_OBJ_PARAM and EQUIPMENT_OBJECT_TEST_PNT for the attribute TEST_PNT_SEQ from “P” to “-” (minus sign) it errors something like this “exact fetch returns more than requested number of rows” suggestions are appreciated