Data Migration

Hello All,Has anyone had success with migrating PSO users between environments?

I am trying to import a profile from one user to another new user and keep getting the error  “The file is invalid and cannot be imported .  The user profiles are saved and stored as .XML files    

Hi All,I can’t create a migration job.  What projection am I missing? Thanks,Rob

Hello All,I’m trying to migrate users between environments and I’m missing data.Why can’t I migrate the email address?If so, what do I add to the migration job.The field seems to be part of the same table, but does not get added to the migration job. Thanks,Rob

Hi, I migrated the charges to PURCHASE_CHARGE_SUPPLIER, but I received error message:“ORA-20124: PurchaseChargeSupplier.FORMAT2: Field [DISTRIBUTE_ON_RECEIPT] in Purchase Charge Supplier has an invalid value format. The value is: "FALSE".” File string : 102517;3D;CLO;1;0;1;;;102517;;;23;;;;;;;;FALSE;FALSE;0Attribute string:VENDOR_NO=102517CONTRACT=3DCHARGE_TYPE=CLOSEQ_NO=1CHARGE_AMOUNT=0CHARGED_QTY=1PRINT_PURCHASE_CHARGE=PRINT_PURCHASE_CHARGE_DB=PRINTCHARGE_BY_SUPPLIER=102517DISTRIBUTE_CHARGE_BY=DISTRIBUTE_CHARGE_BY_DB=FEE_CODE=23INTRASTAT_EXEMPT=INTRASTAT_EXEMPT_DB=FALSECHARGE=MIN_ORDER_LEVEL=MAX_ORDER_LEVEL=VALID_FROM=VALID_UNTIL=DISTRIBUTE_ON_RECEIPT=FALSEDISTRIBUTE_ON_RECEIPT_DB=FALSECHARGE_AMOUNT_INCL_TAX=0    Do you know why I have this error ? 

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:/DATAMIG2)File Name: CS_SJCB_POSTCODE_CHANGE_test2.csvFile Location: OnServerChar S

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;END;I have noticed that even when the IFSAPP.SALES_PART_API.MODIFY code I execute results in an PARTTYPEERROR Exception...… The block to handle that type of errors is never invoked. The exception

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_data_management/020_data_archiving/210_general_data_archiving/120_data_archive_orders.htm     How we can rectify this issueKindly advise Regards