Data Migration

Anyone have luck using a Post Deployment process to change Routing Alternate or Product Structure Alternate from Tentative to Buildable in Data Migration Manager? I’m trying ROUTING_ALTERNATE_API.BUILD_ in this example. I can’t get it to fire off, no matter what settings I try. The Customer Order Status change is very straightforward in comparison, just requiring the ORDER_NO. I’m wondering if it has something to do with the migration not actually filling anything in for the OBJID or OBJVERSION. No idea what should go in the ATTR or ACTION sections. 

Hey everybody, I am facing a problem with Excel Add In in IFS Cloud. The search functionality has changed from Apps to Cloud. Eg “%” or “;” doesn´t work anymore (at least it seems). Is there any documentation about search possibilities that can be used? Is there a possibility to use SQL statements in the search bars? Thank you in advance, Johannes

HI!How i transfer my all employee from one company to another company. Please give me suggestion and working process. when i transfer one by one using ifsapp UI it will huge time to be done.

I want to bulk upload some new parts (part cat, inv part, sales part), structures & routings.I though there were some standard CSV formats & migration import jobs as part of  the “Apps 9 Toolbox Standard Data Migration Jobs” that allow you to just prepare the data in a specified CVS format and then upload using a standard migration job. Is anyone aware of this? Are there such standard upload CSV templates & jobs? Thanks

Hi All,When we do Data Migration using old Data Migration tool, we create legacy data file structure based on the Migration job we write.For example assume we need to migrate Customers.In the csv file we define headers as CUSTOMER_ID, NAME,CUSTOMER_CATEGORY,DEFAULT_LANGUAGE etc. based on the DM job column order  and then fill data in csv file  accordingly.Based on new tool ‘Data Migration Manager’ documentation, it looks like we do not need to do this anymore. Instead we can export legacy data into csv files as it is in the legacy system  and then import them into IFS Data Migration manager. After the import it looks like we can map legacy data into target tables as we require.We can also use dblink in order to map legacy data tables into target tables as well. Could someone explain and confirm if my understanding is correct?   

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. 

Hi,In APPS10, we’re getting this error when trying to perform an inventory movement. Upon checking the inventory location, it appears that it’s because Bay Route Order, Row Route Order and Tier Route Order are NULL.This is odd as the location’s Bay ID, Row ID and Tier ID are populated so I would expect the route orders to have the same value.Bay ID, Row ID, Tier IDBay Route Order, Row Route Order, Tier Route OrderI’m not able to use a migration job to populate these fields as they’re not stored values. Is there a way to almost refresh/re-execute the

Hey, I am trying to fix a broken excel migration job, but it keeps throwing the following error:Expected ',' or '}' after property value in JSON at position 222 (line 1 column 223) My issue is that I don’t know how I can check what the JSON file looks like that is created from the Excel file. Is there a way to see that, perhaps inside the debugger?Please let me know if you need more information regarding this problem to better understand.Thank you for your assistance in advance!

Hello,I am trying to migrate the work location for the emplyee file. I tried it via template EmployeeWorkLocation, but I didn’t manage. The two-step job works fine, but the field “work location” is empty.I am using the Cloud version 22R1I appreciate any help on the subject!Kind regards,Aleksandra 

HiNeed to understand in FSM whether or not possible to migrate the Historical data. I mean to say that Previous year all requests which are even closed /completed  along with its transactions from’ Request to Invoice’  can this be done.  As the customer wants to decommission the old systems and data to be ported back on to IFS FSM.Any inputs to this will be of great help.Thanks in advanceSatwik G S

Hi Experts, at the moment we are trying to configure DMM too to do the migration for a new implementation. The customer hosting the 23R1 version on premise and we are having some hard time to get the DB links works for  non production environment. We have setup the Template project in PROD and then created a project based on the template projects. However, not clear about how we can create DB links to add non production environments as connected environments.  can someone help me to find out the proper way of doing it  like what user we need to use here and stuff like that. Kind Regards!Niyomal.

Hello Community!I have the following Code-- In this block we perform the actual change.DECLARE PARTTYPEERROR EXCEPTION; [SOME_OTHER_VARIABLES]BEGIN FOR sale_part_to_update_rec IN ( [SOME_SQL_TO_PERFORM_LOOP] ) LOOP p0_ := NULL; p1_ := sale_part_to_update_rec.OBJID; p2_ := sale_part_to_update_rec.OBJVERSION; client_sys.add_to_attr(name_ => 'SOURCING_OPTION', value_ => sale_part_to_update_rec.SOURCING_OPTION, attr_ => p3_); client_sys.add_to_attr(name_ => 'RULE_ID', value_ => '', attr_ => p3_); p4_ := 'DO'; BEGIN IFSAPP.SALES_PART_API.MODIFY__( p0_ , p1_ , p2_ , p3_ , p4_ ); COMMIT; EXCEPTION WHEN PARTTYPEERROR THEN [MY_ERROR_HANDLING_CODE] END; END LOOP;

Hi all, Can to convert the status of structures from Tentative to Buildable in one move? Best regards,Ozge

HiThis is a IFS cloud 22R1 environment. I need to export .ins file of a migration job.I have used FNDMIG_EXPORT.Deployable file is generated. But when I click the “Export to File” button, the it populates an error. Restricted file type.        Url: https://karopharma-cfg.ifs.cloud/main/ifsapplications/projection/v1/ExecuteJobHandling.svc/ExportExecuteJob(IntfaceFile=null,IntfaceName='FNDMIG_EXPORT')        Date = 2022-05-27T12:40:04.539Z        Request Id = 63c800a2-eda1-4a57-a5f3-82205ace9850        Client version = 22.1.1.20220406123110.0 I have exported .txt f

Is there a process to get the system populated with example, demo, or dummy data?We are new to IFS Cloud, and will be starting our implementation process with our partner soon. However, we would like to be able to see what a basic setup would look like.Our prior ERP system had an example database which had the minimal setup with some dummy transactions. This was helpful in exploring functionality not implemented and was helpful to the development process.

Hi All,How we can use Project basic data setup in DMM and how we can import DMM project export file with any sample data and from where we get DMM project file for importRegards

Hello,I receive below error when trying to execute a Excel Migration,Any idea why?

What setups are necessary to use the IFS Smart Data Manager?   I do not see the permission sets SDT_CLOUD_FULL and SDT_CLOUD_MIGR_FULL.  Is there something that has replaced these?  We are on 21r1.

I have the exact same Excel Migration Job over BUS_OBJ_REPRESENTATIVE in our DEV and TEST environments and they do not perform the same.   The migration job in DEV will perform a modification as expected and return the “Updated” result.The migration job in TEST will not perform the requested update and returns a result of “Business Object Representative already exists”.   of course it exits, I want to update the “Representative Type” associated with the record.We have check all permissions and have no idea what would be causing the difference in functionality.Any help is greatly appreciated. Sincerely,Vince

Hi,Has any one used Data Migration Manager in Cloud (22R2) to copy data (basic data as well as transactional data) from PROD to lower system such as TEST or PROD?For an example, we want to copy all basic dataset up and transactional data from PROD to TEST.Documentation says this is possible but couldnt find any step by step guide.Thank you.

Is there an “easy button” to move one site under another company within the same IFS instance? Or does that require a full blown data migration to move data from one company to another? How have other IFS customers resolved this situation?

To extract data from IFS, Is the use of ETL like Boomi prevent the use of other mode of Extraction( flat files extraction ) ? that is to say, if i use Boomi to extract data from IFS i cannot do so using flat file in the same time ?

Does IFS Data Migration Manger have built in Number series functions which can be used in the Input Container as Transformation Rules.For example assume a Customer in the legacy system has multiple addresses.If they do not have Address IDs in the legacy system , how do we generate Address IDs in IFS (Say Address IDs 01,02,03,04,05)

Trying to set up an External File Template to import Customer Payments.  Whether I use a system-provided template or one I set up on my own using the great advice in this community, I get this error:  “ORA-20111: ExtPayParameter.NOTEXIST2: The Ext Pay Parameter object does not exist.”  For example, I’ve tried the system template CUP_USCUSCHK.  Does anyone know what this error means???Thanks.

Hi Everyone, We are looking at populating the Custom Stat No field with the HS codes (unless anyone advises otherwise).We’ve identified around the HS codes for around 100,000 parts so far (with many more to go). Does anyone know if there is a way to change them on bulk to add the code to the part (the field will be empty at present)?