Data Migration

Hello, I currently have an event, an event action, and a workflow. The event action triggers the workflow. I want to export/import this process between environments. I am able to add the event and action to an Application Configuration Package, but I cannot add the workflow itself. This is what my ACP looks like at the moment:  And when I try to import this ACP into a new environment, I see this:  I understand that my workflow design is not imported yet, so therefore the ACP cannot import either. My question is, how do I actually export/import the workflow? I cannot find anything on the “Workflow” page for this. Mark

I'd like to wish you all a very happy new year. I'm creating migration jobs for customer orders where I'd like them to retrieve as much information as possible automatically. At the moment, I only have 3 mandatory pieces of information to enter.   I'd like the order number to be entered automatically, based on the last existing order number. Is this possible? Where do I enter it? For the example, my last order number is "S23000005957".I'd like the order number to be automatically set to "S23000005958" when I run my job, and for the countdown to take place naturally. If I manually recreate an order, my number should be "S23000005959".

Hello All!I need to update (migration task) many lines to personal files table. Which view should I choose to update all fields of the following person views together : PERS, PERSON_INFO, PERSON_INFO_ALLThank to all advices from HCM experts.

Hi guys,Anybody here has a detail procedure how to update my TEST environment using PROD environment data?I already asked this question a long time ago,  but no good answer.Our environment is IFS Cloud 23.2.5, on premises.Thanks,Gianni Neves 

I created migration job named “PURCH_REQ_MIGRATE_MNTJ”. But the user can not see this. How can I activate the migration job to the user.  Or should I confirm the permission set?  

Hello everyone,I need to create a migration job for customer orders. My customer would like a unicity check to be performed on the field CUSTOMER_PO_NO when the job is launched.  If the value already exists on IFS, the line that should be imported by the job should be blocked.   Is it possible to add this control and blocking directly to the migration job? Knowing that, the field is optional.   

We’re implementing our first FIFO site in IFS and trying to migrate the actual Received Dates for their raw material inventory.  Seems IFS wants to always set these to the import date and not the actual date value.  Anyone faced this or have a workaround?

Hello,I have the following syntax in a procedure, but it is failing to compile with the following : Can anyone tell me what I am doing wrong please ?  

Hi .. I was trying to set-up new migration job to update CUSTOMER_INFO_ADDRESS View for changes in address and postcode values. This supposed to update around 17000+ records so i choose to use Procedure “INSERT_OR_UPDATE” from csv file.As soon as i run the job i am getting below error. I did investigated further into this and noticed actual issue is - Address column value holds multiple comma seperators, which seems to be root cause of this. Is there any way i can mitigate this issue without removing extra commas from address value ? if i add double quotes around this column value, do you think this will insert double quotes also in data ?double quotes  Start time - 19-JAN-2024 11:13:18   CS_SJCB_POSTCODE_CHANGE_MIG - Execution No 0 Insert into CUSTOMER_INFO_ADDRESS_TAB failed - ORA-20111: CustomerInfo.FND_RECORD_NOT_EXIST: The Customer Info does not exist. (Error caused by line: 2)File Path: DATAMIG (F:

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;

How do I get to print off a Truck Spec Sheet from IFS? I used to have a shortcut saved but it got deleted.    

Dear Community, @Jens (you're a DMM guru I've been told ;))When using in Cloud 22R1 the Data Migration Manager, deploying the object Suppliers [SUPPLIER_GENERAL_INFO], we face an error when the output container is deployed, during the deployment: "Field [ON_NEW] is mandatory for Deploy Definition Attributes and requires a value.”In the target table definition this field ON_NEW is not available. Has anyone seen this error before and has a solution to fix it? At the moment we can't deploy the data to the target environment.  

After making a few updates in the excel field for the add-in, I validate and get the Object does not exist message. I am using the correct search function to pull in the data and it has worked in the past. Will someone please help me understand what went wrong and how to fix this?

Hi, From where I can find the IFS Cloud 23R1: Data Migration Manager Template Project file?I have found a community post for 22R1 and a post related to an 23R1 Internal file only.When the releases are made,  is there a public URL where these templates are made available to  downloaded from?Thank you

I have a customer who is implementing IFS Cloud 23R1.  Their question: Is there a list of all possible data objects along with their dependencies? For example:  To migrate Shop Orders into IFS, you must first have migrated Inventory Part, Routing, Product Structure, Work Guideline data objects from your source system(s) into IFS.  

Dear All,I would like to know if it is possible to use Data Migration Manager(DMM) tool to migrate 'Resource Deatails' and 'Resource Connections' in IFS. Has anyone done that already?If possible, how do we do that? How do we handle sequence numbers in DMM? Any examples?Can we use 'resource_connection_seq.nextval'?Any reference documentation/materials will also be helpful.Thank you!

Hello, I have created an event action as follows, but when I RMB and print order I get the print as expected but also get the default print.  How do I stop the default one ? Thanks

 Hello good morning team, could you help me with this question pleaseSince property is added to a Binding, I need to put a new property 

Hi all,I’m running ifs-cloud-23.1.6-penyzy3-3.5.0I’m trying to import the data from CUSTOMER_INFO_ADDRESS but the CREATE_TABLE_FROM_FILE job is splitting the ADDRESS field like so:ADDRESS=4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA In Excel export it looks like this:4291 5th Ave ES6V 7V6 - Prince AlbertSaskatchewanCA - CANADA How do I keep the information in the same record?I’m assuming it’s processing a Hidden Tab from Excel .csv file Thanks,Rob

I have created a Data Archive Job for Shop Order, I follow the documents properly  by using following documentshttps://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/020_data_archiving/210_general_data_archiving/020_how_to_setup.htm?_gl=1*a5k3p6*_ga*MTk5MzI4Mzk2LjE2Nzc0ODIwMTU.*_ga_H7YJR9R7Q1*MTcwMzIyNDczNC4xMzAuMS4xNzAzMjI2NjI4LjAuMC4w https://docs.ifs.com/techdocs/Foundation1/040_administration/260_dat

I am using the Data migration tool in Apps9 to update an existing custom field. This field is indexed and coming up with the error:- Execution No 0Error creating index CREATE  INDEX IC_SM_SALES_PART_PP_REF_IX1 ON IC_SM_SALES_PART_PP_REF_TAB() - ORA-00936: missing expressionDo I need to set up the DM job in a certain way?

Any idea why ifs cloud does not allow function_result@5 in the column name?Column name is a drop list with all the columns from the source mapping tab. 

​Hello everyone,I have a tricky problem for you.As part of a go live project with IFS APP10, we migrated the financial data, including the ledgers. We went through external assistant and everything went smoothly.Later, the finance team realised that for many rows the E code was the wrong one. So we modified the E code using Excel Add-in with the GEN_LED_VOUCHER_ROW_UNION_QRY view.This worked well, so the E code has been modified. In the view GL Voucher Rows Analysis, the CODE E is good. All the CODE E are ‘EXTERNE’ But when we look at the view GL Balance Analysis different results from 'EXTERNE' still exist.  When We look at the SQL Query Tool :It is therefore clear that the 'accounting balance' view has not been updated.This table is used to summarise the balance. The balance has therefore not been updated.So I tried to recreate an excel add in to update the valu

Good afternoonI would like to know how to insert one object inside another, that is, make it a sub item.I think changing the level would work but I don't know how to do it and I would like to ask for help.Best Regards 

Hi all,We are trying install IFS Excel Add-In in AWS VM with Windows Server 2019 OS but getting the error.We are using Microsoft 365 (Enterprise). We did reinstall the excel and update the chrome browser version, but it still doesn't work.Below is the documentation we follow.https://docs.ifs.com/techdocs/22r1/070_remote_deploy/400_installation_options/010_data_management/030_data_migration/Can you advise what will be the issue and suggest some method to resolve.Thanks