Data Migration

Hi, We have requirement to create Work Order and Work Task using Create Table from flat file and then MIGRATE Source Data.We are able to create the Work Order but unable to get the WO_NO (system generated) in order to create the Work Task. There is no getter function to get the WO_NO in ACTIVE_SEPARATE_APIAny help would really appreciated.Thanks,Nishith

I validated the Basic Data while transferring it from the Input Container to the Output Container, and also by the options available in the Output Container. I know that US is a Country Code transferred to the Basic Data Container, still the message is Validation Failed for Country DB. Shouldn’t it be validated Ok? Am I missing any steps?View in Output Container 

In the output container there isISO_LANGUAGE validation failed, basic data target cannot be foundandISO_COUNTRY validation failed, basic data target cannot be found.Then the Basic Data Container need to filled with data from the target environment, right?There is no option in the Basic Data Target Table drop down to select. Why is it empty? What is missing? 

Hello, I want to migrate my posted supplier invoices from 7.5 to the cloud version.To avoid double accounting of expenses, the expense postings must be replaced by an extra-accounting account,Is there any way of doing this migration that takes this requirement into account? What tools do you recommend for this migration? Best regards

Hi, I have forgotten the api/function call to get logged in users id, so I can pass it to a migration job. Please help

Hi, we have a requirement to update existing Customer Orders in IFS with a new External Transport Leadtime via a migration job. When we update this manually in Apps10, the Planned Ship Date is updated on each Customer Order Line, and a dialog box pops up to allow us to replicate the changes to any pegged orders.When I update the leadtime in the migration job, the Planned Ship Date is updated successfully on all Customer Order Lines, but the changes are not replicated to pegged orders. Is it possible to trigger this via the migration job to ensure that all connected purchase orders are updated with the correct date?So far, I’ve tried to amend the migration job to also loop over the order lines with the method “Customer_Order_Line_API.Modify__”, passing in various attribute/values which I identified in the debug console (see below).REPLICATE_CHANGESTRUECHANGE_REQUESTTRUECHANGED_ATTRIB_NOT_IN_POLFALSEUPDATE_PEGGED_ORDERSTRUESET_TAX_FROM_ORIGINALFALSEMULTIPLE_TAX_LINESFALSETAX_CLASS_IDHowe

We are doing a project re-organization and need to move activites under newly created projects. Would this be possible using the data migration tool or is it even possible?

Hi,We are currently upgrading from IFS to IFS Cloud.  We currently have a number of Excel migration jobs to support users in their daily work.I have overcome most of the issues encountered so far aside from the following:The Search functionality always throws a Malformed Request error.  Thereafter, nothing related to the Excel add-in works anymore without logging off/on again.Has anyone else encountered and found solutions to these issues? Thank you.  

Is it possible to get more granular information about what is contributing to our Database growth rate?   On IFS Cloud (IFS Hosted) for past 15 months?  This PowerBI report was generated via the Service Insight Studio on Build Place.    We started with essentially no transaction history so this growth rate seems quite high...   

I am trying to create a migration job for customer agreement using excel migration , i followed the steps and added two methods of both header and detail. CUSTOMER_AGREEMENT and AGREEMENT_SALES_PART_DEAL but while validating , am getting error message like "RmAccUsage.Developer Error: CustomerAgreementDEVELOPER_ERROR_03: Most likely a usage definition is wrongly defined for LU: [CustomerAgreement] in table RM_ACC_USAGE_TAB, internal exception: [Ex_Get_Id]"steps are as follows        

Good afternoon all,  I am after a little help/advise. My company are looking to add the Harmonized System (HS) codes to the inventory Part Record using the Customs Stat No field (unless anyone can advise me differently). We have identified over 100,000 inventory parts tariff codes and I wondered if anyone knows of a way to bulk upload them from an excel spreadsheet? At present the field is blank.  

Hi All, Do IFS have a document which has the correct object migration sequence?In most cases, Data Migration specialists working on IFS data migration using Data Migration Manager do not know about IFS. So they do not know for example you have to migrate ‘Master Part’ first before migrating an Inventory Part,It would be useful ,If we have a simple document which has the correct order of performing migration for at least commonly used Migration Objects. 

Hi all,Our IFS Application en Database servers are running on Windows 2012R2. We are currently in the process of updating those servers to Windows Server 2019. Before we proceed, we would like to hear from anyone who has experience with performing in-place upgrades to either Windows Server 2016 or 2019.Our team is considering the in-place upgrade route as it offers the advantage of retaining existing settings, configurations, and applications. However, we are aware that this process can be complex and potentially risky, so we are seeking insights and advice from those who have gone through this upgrade journey before.If you have successfully completed an in-place upgrade from IFS servers running 2012R2 to either Windows Server 2016 or 2019, we would greatly appreciate hearing about your experiences. Thank you in advance!

Hi All, Does anyone have any documentation on the difference between the data schema in Apps10 upd 18 vs IFS cloud 2024 r1. Trying to understand why there is a need for migration between the 2 versions and could there have been something IFS could have done to avoid this?

This is about enumeration items when creating mapping data forData Migration Manager.What is mandatory is the DB value, but the default value that is automatically set is set to the client value.So everything has to be changed manually.Am I creating this incorrectly?Or do I have to change them manually? 

Hi ,We are using Data Migration Manager for data migration and we encounter one issue related to deployment container.During bulk deploy into the Environment records getting inserted in CFG but Deploy Status in Deployment Container not getting updated ever after refereshing the screen.Deploy Staus getting updated while deploying singel record but not updating staus for bulk deploy and multiple record’s deploy.Really appreciate for your help. 

Hi Experts,After taking backup of database when run "alter pluggable database all open" showing error and database not open. what happended and suggest solution.

We have been attempting to migrate absence data into an environment as a trial for bringing absences in that are registered outside the system. The migration job uses the ABSENCE_REGISTRATION view using the INSERT_OR_UPDATE procedure.  I am experiencing two issues, this is the first. We are able to successfully bring the absences into IFS Cloud however when the value is less than one day (irrespective of the absence type setup being working hours or working days) the system automatically turns absences less than 1 day or less than the scheduled 8 hours into 1 whole day or a full day schedule. The issue we have is that it isn’t uncommon to book less than your scheduled hours yet when we try to migrate data into this view we aren’t able to successfully include a time in the format. Does anyone have experience of a similar migration job where you have encountered the same issue?Things I have tried so farUsing TIME_FROM and TIME_TO but only a date format is being accepted. When you run a r

Hello All,I have a simple question.Is it possible to copy bookmarks for one IFS Cloud user and paste them across all the user profiles for a client? Is it possible to use the Cloud Data Migration screen to achieve this?  A client wants to avoid setting up the bookmarks manually for each of their users.Thanks in advance!Best Regards,Sayeef

Hi,I will transfer data with the Excel program, but I get the error in the picture.1.I convert the Excel file to csv file.2. Start Job - Load File / I select and load the file and I get the error in the picture. 

Are there any steps for migrating excel data into customer order line using latest IFS excel migration.

Hello, We are using Apps 10, UPD13. We have sales parts in SITE1 (approx. 500K) and are trying to create the same sales parts in SIT99 using the script below but are getting an error message that the part already exists. They already exist as inventory parts in both SITE1 and SIT99.  Is anyone able to help us with resolving the error and creating the sales parts in SIT99 that already exist in SITE1? Thank you,Joann DECLARE  p0 VARCHAR2(32) := NULL;  p1 VARCHAR2(32) := NULL;  p2 VARCHAR2(32) := NULL;  attr_ VARCHAR2(32000);  action_ VARCHAR2(30) := 'DO'; CURSOR get_part_info_ IS    SELECT i.CONTRACT, i.PART_NO, p.CF$_SALES_GROUP    FROM  inventory_part i     left outer join sales_part s     on i.part_no = s.part_no     and i.contract = s.contract     left outer join    PRODUCT_CODE_X_REF_CLV p    on i.second_commodity = p.cf$_comm_group_2    and i.part_product_code = p.cf$_product_code    where     i.contract = 'SIT99'     and i.part_no like '%2'     and length(i.part_no) = 11     and s

Good day,I’m sure it’s a simple thing that I have overlooked, but I don’t have one of the Source Mapping Columns present in the Search function. I’m using IFS Cloud, and I believe COMPANY is the attribute of CUSTOMER_CREDIT_INFO.Missing column​Here is what the Source Mapping looks like: Here is what the Method List looks like: And lastly, the fetch condition is the following:CUST_ORD_CUSTOMER.CUSTOMER_NO=CUSTOMER_INFO_ADDRESS.CUSTOMER_ID and CUST_ORD_CUSTOMER.CUSTOMER_NO=CRM_CUST_INFO.CUSTOMER_ID and CUSTOMER_INFO_ADDRESS.CUSTOMER_ID=CUST_ORD_CUSTOMER_ADDRESS.CUSTOMER_NO andCUSTOMER_INFO_ADDRESS.ADDRESS_ID=CUST_ORD_CUSTOMER_ADDRESS.ADDR_NO and CUSTOMER_CREDIT_INFO.IDENTITY=CUST_ORD_CUSTOMER.CUSTOMER_NO Add-in version: 23.1.5.0Thank you!

The requirement is to read csv file from FTP folder for 'On Server' Data Migration. The file format should be dynamic name (file name concatenated with current date, for example PartMaster_&DATE.csv). But the 'On Server' migration is working with static file name format (PartMaster.csv) but not with dynamic name.  IFS responded that R&D team has identified this as the expected behavior of the IFS Cloud applications and as of now it only allows to write data to a on-server file with the extensions.The import functionality might be included in near future as an enhancement of the application.

Hi,I downloaded and installed the configuration analyzer tool from the IFS developer portal(https://developer.ifs.com/tools/confanalyzer).The tool installed successfully but when I launched the tool, The application opens and within a few seconds it closes immediately.Do you have any ideas why this happens?Thank you