Data Migration

Here goes a question for all of you who have some expertise deploying containers in the Data Migration Manager (or experienced in any type of migration tool with PAYMENT_ADDRESS as the destination).I’m trying to understand why, upon deploying PAYMENT_ADDRESS, I get the following error:Method NEW failed : ORA-20124: Error.NULLVALUE: Field [MAPPING_TYPE] is mandatory for Payment Address and requires a value. I am providing a value for MAPPING_TYPE as you can see in the screenshot:Error on Data Migration Manager. Notice the field has MAPPING_TYPE has data! I tried changing the value of mapping type to other values to see if that could be the reason (I tested with values such as “CHK” or “PAYMENTADDRESS”) bu

Hi everyone,I need to replace a large number of skills on standard tasks, but doing it manually is not feasible. I tried using Excel Migration, but I encountered an error and it seems this method might not be supported for deletions.As an alternative, I’m considering uploading the new skills in bulk and removing the old ones. Does anyone know how to properly remove skills using Excel Migration? Any guidance or examples would be greatly appreciated.Thanks in advance!Best regards,Stefania 

Hello everyone, I want to update the supplier association number using a data migration job.I have identified the relevant package to use: Supplier_Info_General_API.Modify__.When I call this package through a PL/SQL script, it works as expected and successfully updates the value.the package is called by the crud_update method :supplier_handling_svc.crud_update(                '*',                v_supplier_id,                'ASSOCIATION_NO' || chr(31) || v_association_no || chr(30),                'DO',                supplier_info_general## => ''            );However, when I run the same operation through the data migration job, no changes occur. Any idea why please?The select statement generated by the datamigration job do return the correct value :

Hi,I am using Data Migration Manager.An error message is generating in the Deployment Container:Template: CUST_ORD_CUSTOMER_ENTError: Field [RECEIVE_PACK_SIZE_CHG] is mandatory for Customer and requires a value.RECEIVE_PACK_SIZE_CHG is not in the Target Table Definition, but RECEIVE_PACK_SIZE_CHG_DB is.RECEIVE_PACK_SIZE_CHG_DB is not mandatory.Has anyone previously come across this and found a resolution?

Hello, I'm Markus and I'm new here in this community, and this is my first post.One of my tasks is to prepare the master data from the old ERP and migrate it to the IFS cloud. Of course, a lot of mapping is necessary, as we don't have this many columns and tables in the old ERP.I learned from our consulting to use these data migration tools: Migration Job for LOAD and for MIGI have a VPN to the IFS cloud and can select the data VIEWS via ORACLE SQL Developer to reconcile the column names and fields for the migration job files or to build the mapping for this.Is there a best practice for the migration of master datafrom our old ERP to our IFS cloud?Thank you very much for your knowledgeGreetingsMarkus 

What method should I use to change the status Plannable to Tentative? Thanks in advance,

Hello ​@Jens ,I am trying to migrate some data to the Purchase Part screen using Source Migration.I also want to migrate the document text value.Do I need to have a separate job for Document Text?Can you please help me out by providing your suggestion. Thanks,Thean

Hi Community,I was trying to Migrate the Translation for Customs Statistics Number. in screen Basic Data Translation for English and PROG Data will alredy exist.I am trying to migrate the data for french Language via Excel Migration Getting error ORA-20110: BasicDataTranslation.PROGNOTEXIST: Corresponding basic data does not exist for attribute key  Any idea how to solve this error?Thank You

After upgrading from App8 to cloud, the ‘Close Shop’ operation has been changed to ‘Park’. Does anyone have any insights or information regarding this change?

Has anyone seen this error message when loading or validating data for jobs with the Excel addin?  Last week we could load data the COA to the worksheet without error.  This week we are getting the above error for any of the migration jobs.  Office365Aurena  

when using Excel add-in for data work with IFS - I can’t perform any functions in the spreadsheet as the buttons disappear.Does anyone have a solution please?When I first log in - the buttons & mig job tree is available:After the first interaction, say load data - everything disappears: 

I am trying to run a migration job to the customer credit limit table. I am using the excel add-in tool. We have to update some customer credit limits in bulk. The problem is the job keeps telling me that I am trying to update the PARTY_TYPE and that I’m not allowed to. I do not care to modify the party type, as it should remain Customer. I have tried to modify the migration job by eliminating the source code (column) for Party_Type and/or Party_TypeDB, and set up defaults as “CUSTOMER’ and ‘Customer’ and all possible combinations of such. No matter what, the system is convinced I am trying to “update” the party type, when all I want to do is update credit limits. Any advice or resources? This is for IFS Cloud 24R1. I was pointed to IFS Apps 10 - IFS Data Migration Excel Add-in Overview and De

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.

Hi, I would like to update the list price in the view SALES_PART with the data migration. When i try, i have the same message on everyline when i launch the MIGRATE_SOURCE_DATA: ORA-20122: SalesPart.UPDATE: Field [CATALOG_TYPE] in Sales Part may not be modified. The value of [CATALOG_TYPE] is ‘NON’. Is it possible to proceed so ? Thank’s Julien.    

Apps 10 update 12:I am trying to load some new Inventory Locations.  The migration job is pretty straight forward, see below.When I try and execute, the first row is successful but second and subsequent rows fail.  The error is:Insert into WAREHOUSE_BAY_BIN_TAB failed - ORA-20112: WarehouseBayBin.FND_RECORD_EXIST: The Warehouse Bay Bin already exists. (Error caused by line: 3)It appears that there is a LOCATION_SEQUENCE which retrieves from a sequence (if the field is empty in the attribute string).  Looking at the output of the failures, it is trying to use the same LOCATION_SEQUENCE value for each record.  Anybody have any ideas or have been successful in data migrating inventory locations?Thanks in advance,Dom

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? 

We are trying to migrate Open stock  which I am trying to do using migration job , the data is loaded successfully and can see it under “Inventory Parts in Stock “, what are the next steps to transfer the balance to GL please? I am trying “ Transfer Inventory Transactions “  option but I can’t see any transactions generated ,is there a step in between I am missing here to generate the inventory transactions so that they can be transferred to GL? I can’t see any data under Inventory transaction history as well so looks like I am missing a step here  

I am using Excel add-in for data migration most of the time no issues.in a few examples i need to do some data retrieval/lookup and have used an expression in the ‘default value’ column in the migration job.However, as yet i am struggling to do the same with a simple SQL select. Is it not possible or is my syntax incorrect. I have no guidance so I am making it up as a I go, I could be doing it incorrectly.I did write a select first in quick reports to prove it was correct, although it is so simple I did not really need to.When I click validate or execute - I don’t get any feedback, (the debug feature does not work) - but if I remove the select my other data updates - so something about my approach is failing. Thank you for any suggestions!  

I’m looking for some sort of materials to get trained on how to use the excel add-in tools for data migration. Would love to learn more about designing migration jobs, setting defaults, strategy, and more. I can’t seem to find anything on Community or Academy for resources. Where do you go to learn?

Hi, I wan’t to update only certain fields (the adresses) of the customer info adress view by data migration. Is it possible ? What do I hace to do to recuperate the other fields that I don’t wan’t to update ?How can I construct the field “Adress” that seems to countains the new address ?Thank’s.Julien.  

Dear Experts, I’m trying to build an Excel Migration job that would need to:create some functional objects - EQUIPMENT_OBJECT_API apply a parameter template after the functional object is created - Asset_Param_Template_Util_API.Apply_TemplateBelow is the Medthod List The problem I have is how to pass EQUIPMENT_OBJECT_SEQ when applying the parameter template.This method expects EQUIPMENT_OBJECT_SEQ which is created by method 10 - EQUIPMENT_OBJECT_API. However it seems that at the point of executing method20 the equipment_object_seq is not available.In Mig Jobs - migrate source data it was possible to set a COMMIT rule - I was thinking if such a thing is possible for Excel migration - for example to commit after each method.

Hi CommunityI have created a Excel Migration for Invoice planning screen.I have given the default value for Invoice sequence- Every time when I load the data to excel the field gets too wider, is there any way to adjust the column width in excel and also to remove the timestamp? Thanks in advance,Thean

Hi.There’s an existing thread on this with a fix here, but following it I was unable to get the migration job working and I’m still receiving the same error. We’re aiming to update only the CODE_F field with a migration job, but running the MIGRATE_SOURCE_DATA job after the CREATE_TABLE_FROM_FILE results in the ORA-20111: Site.NOTEXIST2: The Site object does not exist. error for every line in the file. As  mentioned in the post above, I’ve attempted to add the CONTRACT field into the file mapping, but sadly it has not solved the issue. Any help here would be appreciated. 

We have an existing migration job that worked until Update 20 was applied. The job adds lines to a sales quotation. Now the lines are added successfully only for rows where the customers price list has a value in the Discount Type field for the part in question. The job looks like this:The error returned is “Field [DISCOUNT_TYPE] is mandatory for Order Quote Line Discount and requires a value.”. The migration job doesn’t currently include a method list entry for the Order Quote Line Discount view so it isn’t possible to add a default value for this field: What we would like is to be able to add a default value if there isn’t one on the price list. Is there a way of doing this?

Hi all.My client is upgrading fron IFS App 10 to IFS Cloud 24.2.In IFS Apps 10 they share the consults that are saved with others users and it is a good functionality for them. They asked me if this functionality is allowed in Cloud and I do not find anything related to that.So, is it possible to share the bookmarks? I’m not meanning to export/import functionality between profiles but share the bookmark when you set it up.