Data Migration

Dear all, we are setting up our new PSO environment on ifs-cloud 24.2.2 and want to insert several thousands of customers with their names, adresses and contact information via REST-API calls. Currently we can successfully create the customer via REST-API “…/CustomerHandling.svc/CustomerInfoSet”. How can we add the communication-information via REST (the endpoint …/CustomerInfoContactEntity.svc/CustomerInfoContactSet seems not to be active)? How can we add the Address-information via REST (the endpoint …/CustomerInfoAddressEntity.svc/CustomerInfoAddressSet seems not to be active)? The json structure to POST this data seems to be correct. Best regards Michael

Hey All, I have a query, is there any way to extract the data from IFS Cloud via the ETL tool(talend, boomi etc.) to our data warehouse? Is their any documentation regarding this. Thanks and Regards, Mani Shankar

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 knowledge GreetingsMarkus

We are currently using IFS app 9 and some of the users do use the Simple Data migration Tool. So they use xls files to load data into IFS. Now I'm looking for a similar tool in IFS Cloud and was going through different threads in this community. It seems the future is available in 24R2, but I cannot find any comfirmation on this. Can anyone tell if it is yet availbale?

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, In the sale quotation, there is a State field and a Status field. The State field corresponds to CLOSED_STATUS/CLOSED_STATUS_DB in the database.accepted values : won / lost / no decision / null I can't find the Status information in the database, and I need it for data migration. Does anyone have any information on this subject?

Hi All,Thank you in advance I have the below depreciation requirement. financial year - 2024/1/1 - 2024/12/31 Asset acquisition date - 2024/May/15 Asset value - 12000 Estimate life - 10 year Depreciation method - straight line but in the year of the acquisition, depreciation should be calculated for half and distributed equally among the periods. Example as per my scenario, deprecation will start from May but the amount posted for each period should be = 75 12000/10 --> 1200 per year 1200/2 = 600 in the first year 600/8 = 75 per month in the first year (8 = no of months in the first year) Can someone please help me to set this depreciation method?

Hello, I’m preparing a CREATE_TABLE_FROM_FILE migration job to upload data in EMPLOYEE_ACCESS_SUP. Looking at the proposed File Mapping, I was surprised by the column list which is pre-set : SUPERVISOR_BU_TYPE_DBVALID_FROMVALID_TOTRANS_FROMTRANS_TOGENERAL_ACCESSORG_CODERELATION_IDINCLUDE_SUB When I try the SQL command : select * from EMPLOYEE_ACCESS_SUP I get a list of columns that makes much more sens, 28 columns, such as : Org Bu IdSupervisor Person IdSupervisor Company IdSupervisor Emp NoSupervisor Bu Type DbSupervisor Bu TypeEmp Company IdEmp NoEmp Bu IdEmp Pos CodeAccess RoleValid FromValid ToTrans FromTrans ToGeneral AccessOrg Bu TypeOrg CodeEmployee GroupPerson GroupRelation IdSupervisor Relation IdSupervisor Pos CodeStructure IdStructure TypeOrig Bu IdInclude SubOrganization Assignment Why such a difference ?Should I manually add every missing row in the mapping ? Thank you for your help

Dear All, I am conducting research to analyze the primary source applications from which migrations to IFS most commonly occur. Have you observed migrations from JDE, PeopleSoft, Infor, SAP, AS400, or any other systems? ThanxWarna

Is there a secret to using User Defined Target Fields in Data Migration Manager? I’ve created the fields but they’re not showing up anywhere. Is this another bug?

Hi all, I am planning to upload a part creation template as an external file and one of the parameters which has been decided is the Site. This is not in the .csv upload, but rather in the assistant. Is it possible to put multiple values into the parameter in order to facilitate multiple external file transactions like the following? ie. Site = SITE1;SITE2;SITE3

Hi, I would like to copy an external file template from an environment to another one. Can somebody heklp me. Regards Christophe

I am trying to migrate subcontract with DATA MIG Tools. I got an error when loading the informations related to the Revision line . When I look into the solution the expected values for this area are as follows. Can somebody help ! Thank you Christophe.

While working on migrating data out of IFS, we have noticed that ProjectTransactionSeq does not seem to be indexed in Apps10 UPD20. Is there some reason for excluding this key value from being indexed? Or is the idea to use some other value that is actually indexed? P.S. We are on Managed Cloud Services, so supported by the IFS Cloud.

It appears the Excel Migration procedure in Data Migration in IFS Cloud 23R1 no longer supports migration into Custom LU’s. This was always possible in Apps 10. This is a very useful piece of functionality that should have been uplifted. Does anyone know why this change has been made, and if there is a workaround, without having to resort to CREATE_TABLE_FROM_FILE/MIGRATE_SOURCE_DATA jobs as users will not be comfortable with that?

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.

In cloud version, cannot create data migration job for custom view. Returning “custom lu views are not supported” error. Any idea?

We found and issue while attempting to migrate PROD_STRUCTURE rows using the Data Migration Manager. In essence, once we reach the Deployment Container screen and when we click on Deploy, nothing gets deployed. Even worse, there is no error message or anything to indicate if the deployment failed or something else is preventing the action to complete. Because a video is easier to show this condition I uploaded this video on YouTube so you can see what exactly is going on. https://youtu.be/5z6YtX-Cz4s Any idea as to what could be happening?

I am trying to create a migration job to migrate custom data from our Apps 10 system to our new CLOUD system. I have set up a number of migration jobs for custom field in Apps 10 and I tried to replicate it in CLOUD, but it did not work. I am trying to find instructions for CLOUD. Does anyone have instructions for CLOUD.

INVENTORY_PART_UNIT_COST isn’t available to search for in DMM and when I try to add it, I get “The View You entered is not a valid view”. Is this a bug or are we supposed to use a different view for migrating unit costs?

I’m trying to migrate some inventory locations into IFS Cloud but seem to come across one issue. But, I can’t figure for the life of my see why it’s happening. This is the error that I’m getting, but every other location with the same location group is working fine. Has anyone else seen this issue and found a solution?

I did it once a while ago but forgot how to do it again. I am looking to extract the navigator items to excel in a format as such: >Scheduled Tasks Conversion 1 MENU >My Administration 1 MENU >My Administration>Basic Data Translation 2 PAGE >My Administration>Notifications 2 PAGE >My Administration>My Tasks 2 PAGE >My Administration>My Lobbies 2 INTERNAL >My Administration>My Industry Lobby Results 2 PAGE >My Administration>Subscription 2 PAGE >My Administration>Subscriptions 2 PAGE >My Administration>Scheduled Tasks 2 MENU >My Administration>Scheduled Tasks>New Database Task Schedule 3 ASSISTANT >My Administration>Scheduled Tasks>Database Task Schedule 3 PAGE >My Administration>Scheduled Tasks>Database Task Schedules 3 PAGE >My Administration>Scheduled Tasks>New Database Task Chain Schedule 3 ASSISTANT >My Administration>Scheduled Tasks>Database Task Chain Schedule 3 PAGE >My Administration>Scheduled Tasks>Database Task Chain Schedules 3 PAGE

Hi All, I was following the below URL to use Excel migration job to insert/update Note field in BUSINESS_LEAD page in IFS. (IFS Cloud 24R1) https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/050_data_migration/002_migration_types/030_excel_migration/default.htm?_gl=1*1kzdxq4*_ga*MTI0OTMxMDg4OC4xNzA0ODM1MDgw*_ga_H7YJR9R7Q1*MTcwODUzMzQ2Mi45MC4xLjE3MDg1MzM0OTAuMC4wLjA And I got below error when trying to insert or update the Note field. I have attached the migration job I used. What could be the reason or any idea of resolving this error will be much appreciated. Thank you!

I have a Basic Data Table called COMPANY_FINANCE. One of the fields is CURRENCY_CODE and it is validated against an environment we have called STG. When I validate basic data on COMPANY_FINANCE I get an “Error, Basic Data” message and upon inspection I see that “ISO_CURRENCY validation failed, basic data target table cannot be found” The ISO_CURRENCY table on STG does have a value for USD… so it should NOT fail… I’m clearly missing something, but I don’t understand what. Why is it failing on Basic Data when the target environment DOES have that Basic Data available?

Hello all, I’m trying to upload some data into IFS Cloud CFG and have come across an error message that I can’t figure out the cause of. It says the following: ORA-20124: Error.NULLVALUE: Field [MAPPING_TYPE] is mandatory for Payment Address and requires a value. If any of you have come across this before and found a solution, your help would be greatly appreciated!